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

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