Database Design Project Your
semester-long project is about designing a database. You will ultimately
implement the logical design of your database using Microsoft Access. You will
use the tools and skills you have picked up as you complete the Access Tutorial
you will work on.
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
- 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.
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,
- Ability to answer, using standard SQL queries,
the questions you have posed.