CIS 336 iLab 3 Building the Physical CIS 336 iLab 3 Building the Physical | Page 7

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