CIS 336 help Making Decisions/uophelp.com CIS 336 help Making Decisions/uophelp.com | Page 38

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
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.
2. The CREATE TABLE statements required to build the six tables.