CIS 336 iLab 3 Building the Physical CIS 336 iLab 3 Building the Physical | Page 5

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
the table in question. This will allow you to run and re-run your script file as often as you need
to. The
very first time you run your script the table does not exist, so the IF EXISTS clause causes the
statement
to be ignored. Thereafter, the table will be deleted, ensuring that your CREATE TABLE
statement creates
the table fresh and clean, with only the attributes present in the current revision of the CREATE
statement. Here is an example of one of the six DROP TABLE statements you will need to
create.
DROP TABLE IF EXISTS `ENROLLMENT` ;
STEP 2: The CREATE TABLE Statements
Next, define the CREATE TABLE statements for the six tables that you are to create based upon
the