Reference no: EM133564901

Question: This milestone involves evaluating your design from Milestone 1 to ensure it is properly normalized, then creating the SQL Data Definition Language to define a database that implements your model. Finally, you will create the database using a DBMS that matches your DDL. The preferred DBMS for this project, especially for those new to database, is MS Access. You may use other DBMSs if desired.

Complete the following activities:

• Demonstrate that your database is in at least 3rd Normal Form. This means evaluating all of your entities to ensure they are in INF, i.e., a key is identified and no repeating attributes or repeating groups exist, then 2NF, i.e., no partial dependencies exist, and finally 3NF. i.e., no transitive dependencies exist in your entities. Think the following statement when evaluating each attribute of each entity in your design: "this attribute is functionally dependent on the Key of this entity, the entire key of the entity, and nothing but the key of the entity."
• Write the DDL to create the tables for your design. You should use the format presented in sections 7-2e and 7-2f of the book.
• Below are links to the Module 7 recordings and slides for sections 7-1 and 7-2 that explains how to write CREATE TABLE statements needed for this Milestone. Please review them prior to starting the DDL for this assignment.