CIS 336 All Assignments CIS 336 All Assignments | Page 40
date.
Be sure your name is on all documents and that all documents have been included in a single
zip file for
this week’s assignments.
Refer to the following ERD in constructing your solution.
Student
PKStudent_ID
Salutation
First_Name
Last_Name
Street_Address
Phone
Employer
Registration_Date
FK1Zip
Enrollment
PK,FK1Section_ID
PK,FK2Student_ID
Enroll_Date
Final_Grade
LAB STEPS
STEP 1: The DROP Statements
A DROP TABLE statement must appear in your script file, prior to the SQL statements for
creating