CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 55

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