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.