CIS 336 All Assignments CIS 336 All Assignments | Page 42

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
way for checking that FKs have been properly created.
Examples:
DESCRIBE STUDENT;
SHOW CREATE TABLE STUDENT;
This is the end of Lab 3