Assignment Type:Individual Project
Deliverable
Length:1 Database Diagram; DDL for 7 Tables

Points
Possible:125
Due Date:10/28/2012 11:59:59 PM CT

The following is the same database diagram from Unit 3:

Using this diagram, address the following:

• Establish the relationships between the tables in the SQL server
  environment.
• Ensure that all primary keys are properly created and that the foreign key
  columns are defined correctly.
• Make sure that the 3 additional tables you added in Unit 3 are also shown
  and have established primary and foreign keys to appropriate tables.
• Update the database diagram, and generate the data definition language (DDL)
  for the new tables.
  • Describe what changed in the DDL for each table.
  • Describe any changes that were needed from the original model to create the
    relationships.
• Submit a consolidated Word document with all screenshots and the DDL.

Please submit your assignment.

For assistance with your assignment, please use your text, Web
resources, and all course materials.

Course Materials