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 .
STEP 4 : The SELECT Statements
The next step of the lab will be to create the select statements to verify the data was inserted