CS224 Class Project - Oct02 Term
Goal: To create a database based on either a hobby, personal interest or business need, complete with design documentation, queries, forms and reports.
Phase 1 (Project Description)
Write up a one-page description of your database: what kind of data does it contain, how will it be used, etc.
Deliverable: Database Description
Phase 2 (Table Design, Dependency Diagrams, Normalization)
Create a document detailing your database tables (you can use a spreadsheet), dependency diagrams for each table and any normalization you had to perform and why.
Deliverable: Table design document, dependency diagrams and normalization documentation.
Phase 3 (Business Rules, ERD)
Document the business rules for your database (how do the fields relate to each other, what kinds of questions will it answer, etc.). Based on the business rules, create an appropriate ERD.
Deliverable: Business rules document and ERD
Phase 4 (Implementation)
Using Access, create the database, complete with tables, relationships and some sample data.
Deliverable: a copy of the Access database file.
Phase 5 (Queries)
Based on the business rules you developed in Phase 3 above, create at least four Access queries:
- A select query
- An update query
- An append query
- A delete query
Deliverable: an updated copy of your database.
Phase 6 (Forms)
Create at least four forms for your database:
- Allow the user to enter simple queries
- Allow the user to add records
- Allow the user to delete records
- Allow the user to modify existing records
Deliverable: Updated copy of your database
Phase 7 (Reports)
Based on your previous documentation, create at least two reports based on your database:
- Summary report based on a crosstab query.
- A report with totals and subtotals
Deliverable:
Hints:
- Avoid choosing too trivial or uninteresting a topic. It should be one that has more than one sub-category of data. For example, if you decide to use your CD collection as a starting point, you might have a table for albums, another for artists, a third for musical style and a fourth for recording label. In any case, you want to choose a topic that will hold your interest for the full term. Really give this some thought!
- As you add features to your Access database, you might want to save off a copy of the old database before continuing so you always have a backup copy.
- Feel free to be creative and have fun with this project. Don’t be afraid to do more than the minimum work required and be sure to give each phase a lot of thought.