Logical Design and ImplementationPhase

Due: April 15

For this portion of the project you may use either Access or MySQL.

  1. Create the tables for the relations in your relational database. Make sure you define all domains as well as you can.

    Link all tables by connecting foreign keys to primary keys. Be careful if you are using MySQL, not all engines allow foreign keys - pick one that does.

    If you are using Access, hand in a CD/flash drive containing ONLY your database. This would include your saved queries.

    If you are using MySQL, hand in a CD/flash drive containing ONLY a dump of your database. This dump will give the CREATE and INSERT commands to create your database.

  2. For each relation give (this part has to be hard copy):

    - all its candidate keys
    - its primary key
    - the functional dependencies it satisfies (other than those based on keys)
    - its normal form (if it is not in fifth normal form, explain why)

  3. Choose any 8 queries from your original list. Implement these.

    If you are using Access please save them as part of your database. It really helps if you name them Q1, Q7, etc. so that they match with your original query list.

    If you are using MySQL, print screen shots showing your queries and the results of executing your queries. Include this as part of the hard copy portion that you turn in.

  4. Each member of the team must answer the following questions: a. Why did you choose the DBMS you used?
    b. What was the easiest portion of this phase?
    c. What portion of this phase was hardest? Why?
    d. If you were making this into a production database, what would you do next?
    e. What is the single most important thing that you have learned this semester about designing and implementing a database?