CiS 336 STUDy Learn Do Live /cis336study.com CiS 336 STUDy Learn Do Live /cis336study.com | Page 51

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
statements in a script file format for the Student Database. You will
then populate those tables through
the use of INSERT statements with sample data.
You will need to create a script file and name it YourName_Lab3.txt
containing the following code.
1. The drop table statements listed later in the specifications of this lab.