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
ERD ( provided above ) for this lab . Be sure to follow the guidelines given above on how and where to
create the different types of constraints for each table . This will include PK , FK , and NOT NULL
constraints . STEP 3 : The INSERT Statements for the Data
The third step is to create the insert statements to insert the sample data into the tables created in
Step 2 . The data for each table is contained in text files , named for the table whose data it contains .
Modify the format of the data ( e . g ., date formats and add or eliminate quote marks ) as needed to craft
your insert statements , but do not change the inherent value of the data .