CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 55

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
For this lab, you will be creating SQL statements to build a series of
relational tables, using SQL CREATE