Scenario and Summary
The lab for this week addresses taking a logical database design( data model) and transforming it into a
physical model( tables, constraints, and relationships). As part of the lab, you will need to download the
zip file titled CIS336Lab3Files from Doc Sharing. This zip file contains the ERD, Data Dictionary, and test
data for the tables you create as you complete this exercise.
Your job will be to use the ERD Diagram found below as a guide to define the table structures and
constraints using both CREATE TABLE and ALTER TABLE statements. Once this has been done, you will
need to write the INSERT INTO TABLE statements to insert the data provided into the table. The data
should verify that the constraints you have created are valid and define the correct referential and data
integrity constraints asked for. Lastly, you will write SELECT statements to query the tables and verify
the data was populated. Please use exactly the data provided, without addition, deletion, or alteration
except as directed, as your results may be evaluated against expected results generated using this exact
data set. Narrative / Case Study