http://tools2think.org/csprojects Software Projects for Students Mon, 29 Dec 2008 05:11:19 +0000 http://backend.userland.com/rss092 en Students in various software institutions will be getting closer to their last semester. Normally they are required to do some projects. I plan to add several of them to this site over the next few weeks. Here are some broad categories. If you are a student or an instructor, feel ... http://tools2think.org/csprojects/?p=15 Generate an Entity Relationship Diagram from a Database Functionality User specifies a database The ERD lists a set of tables User picks - All or a set of tables User specifies the ERD options - Overview, Detailed An ER diagram is generated with the following: Tables Columns for each table Index items marked Foreign Key relationships Extensions: Convert the diagram to PDF ... http://tools2think.org/csprojects/?p=14 Resources Database Describes both physical and virtual resources. Consists of: Resources Table Todo: Create the table. Create indexes Add/Delete/Change Form - Create a form Enter at least 10 meaningful (not aaa, bbb etc.) records in the table View Form - View the list of records as a list (in a table) When a user clicks on one of the ... http://tools2think.org/csprojects/?p=13 Jobs Database Jobs database describes a set of jobs. It consists of: Jobs Table Todo: Create the table. Create indexes Add/Delete/Change Form - Create a form Enter at least 10 meaningful (not aaa, bbb etc.) records in the table View Form - View the list of records as a list (in a table) When a user clicks on one ... http://tools2think.org/csprojects/?p=12 Events Database Describes various types of events both physical and non-physical. Consists of: Events Table Todo: Create the table. Create indexes Add/Delete/Change Form - Create a form Enter at least 10 meaningful (not aaa, bbb etc.) records in the table View Form - View the list of records as a list (in a table) When a user clicks on ... http://tools2think.org/csprojects/?p=11 Organzations Database This db consists of a set of tables that describe an organization. Tables: Organizations Table Todo: Create the table. Create indexes Add/Delete/Change Form - Create a form Enter at least 10 meaningful (not aaa, bbb etc.) records in the table View Form - View the list of records as a list (in a table) When a user clicks ... http://tools2think.org/csprojects/?p=10 A series of small incremental projects starting with the first and gradually improving as you go along. wfa-1: Basic Accept one parameter - input file Open file - raise exception if it does not exist and exit the program Read input file, line by line For each line, tokenize (separate into words) Eliminate any punctuation ... http://tools2think.org/csprojects/?p=9 This project reads the bookmarks from your browser and stores it in a database. The bookmark database consists of: users table userid name email Bookmarks table UserId Title URL tags ( a list of comma separated tags) Share (boolean - Yes or No) This can be a desktop application or a web application: 0. User logs in (uses email and password previously ... http://tools2think.org/csprojects/?p=4 Analyze the first words of sentences and create a frequency table. The number of distinct words is supposed to be around 2000 according to this paper. * The program takes text file and performs an analysis of sentences Rules for detecting the first word of a sentence. 1. First word in a paragraph ... http://tools2think.org/csprojects/?p=3 A simple database project is a contacts database. Skills required for the project: Java Programming JDBC API SQL (create table, insert, delete, update, select, parameterized queries) For Web Cleint JSP Development HTML Forms Servlet Programming For Desktop Client Swing Here is what you need. 1. A database engine (MySQL, Postgres SQL or any other open source relational database) 2. JDBC ... http://tools2think.org/csprojects/?p=1