Date Assigned: Monday,
May 3, 2004
Date Due: Tuesday,
May 18, 2004
Total Points: 100
For the final project for CS230 you need to design and
implement a database of your choice.
The database should minimally contain the following:
- Three
tables. These tables need to be related somehow.
- Three
queries. Design and implement three queries that could be used by the
users of your database in certain scenarios. At least one of these queries
must use more than one table.
- Two
forms. Again the forms must be designed and implemented for realistic use
by the users of your database. At least one of the forms must display
images and one of the forms must contain data from multiple tables. One of
your forms should also contain a combo box.
- Two
reports. You should create two reports that can be printed out. These must
be designed in such a way that they are useful to the users of your
database.
You will give a presentation on the day of the final. Your
presentation should describe the domain where your database would be used, the
design of your database and sample queries, reports and forms. You should also
give a demonstration of your database.
What to Submit
You should submit
- The
database. Place it in the drop box by the day of the final.
- The presentation.
Again, place your presentation in the drop box.
- Documentation.
This should describe the domain in which you would use the database.
Describe the user of the database and run through some scenarios that
might occur in the domain and how your database would be used. Describe
the rationale behind the queries, forms and reports that you created.
Grades
20% of the grade will be on the design.
10% of the grade will be on the presentation.
10% of the grade will be on completion.
20% of the grade will be on the queries.
20% of the grade will be on the forms.
20% of the grade will be on the reports.