Database Design Project

Your project can be broken down into following tasks:

• Logically design a database, its tables, fields and relationships. This task will result in the completion of an E-R diagram. The database must contain at least two tables.
• Physically design a database. This task will be performed using Microsoft Access.
• Populate the database (tables) with sample data. This may be done interactively using the Microsoft Access Data Window.
• Design at least one Access form.
• Design at least on Access report.
• Develop a list of five (5) questions that can be answered via standard SQL. At least one of the questions must require a multitable join to answer. For example, how many record albums do I own that were recorded by Elton John in the decade of the 70's, and what is the full name of the album.
• Code the SQL statements to answer these questions.
• Write a report of sufficient length to explain what the database is meant to capture, the reasoning for your design and the lessons you were able to learn and apply as you completed the project. Suggested length: NOT including your E-R diagram, 3 pages.

Your project will be graded based on the following criteria:

• Quality of your written report
• Quality of your logical design and physical implementation. For instance, do you have multiple tables, and are they in 3rd Normal Form. 
• Quality of your naming conventions for both tables and fields.
• Quality of your fields--are they properly named. Are the data types correct. Do you have field validation.
• Quality of your relationships. Are you enforcing referential integrity?
• Quality of the design of your form. Bear in mind you are to prevent Database anomalies from being created. Garbage-In, Garbage Out!
• Ability to answer, using standard SQL queries, the questions you have posed.