Below there are four projects that you can choose from. Each team should
pick the project they want to work on and then e-mail us their selection.
There is a maximum of four teams that can choose the same project. Each
team will be enrolled on a project on a first-come first-serve basis.
This is a schedule of deadlines for different phases of the project. You will
be graded only on the entire project you submit at the end of the quarter.
However, we STRONGLY encourage you to make the preliminary deadlines and
receive our feedback on your work.
-
October 16 - you must have your project selection mailed in
-
October 23 - E/R diagrams and schemas (points 1 and 2 of the project)
-
November 3 - Data Insertion and Customer Information schema (points 3 and
4 of the project)
-
November 17 - Sample Application due (you should have part of the
application done - demonstrate some query capabilities of
your application).
-
December 6 - Project Due-Date. Turn in everything. You will get a project
grade.
There are a few questions you need to know the answers to.
- How to create a table. For a tutorial click here.
Note: For point 3 of the project we want your SQL script file (like the
one above) that populate (inserts rows) into your tables. You should have
at least 25 rows into your main tables.