STEP 4 : The SELECT Statements
The next step of the lab will be to create the select statements to verify the data was inserted
correctly . You should have six select statements ; one for each table . The command is SELECT * FROM
Table _ Name ; For example , to select all columns from the Student table , the command would be
SELECT * FROM student ; Be sure to save all of the above statements in your script file . STEP 5 : Testing and Verifying Your Script
Now we come to the point of verifying that your script file works by creating all of the tables and
inserting and selecting all of the data . Your script should execute without errors , and select the entire
contents of each table in turn . Inspect your query results to ensure that each column and row from
each of the tables is as expected . Correct and repeat testing of your script until no errors occur , and the
results match expectations . You may also use the DESCRIBE command to display the table structure of
each table , and verify that PK and NULL constraints have been properly created . The SHOW CREATE
TABLE statement is useful for displaying the SQL that would regenerate a given table , which is a useful