CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 57

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_____
===================================================

CIS 336 iLab 4 Introduction to Select, Insert, Update, and
Delete Statements (only SQL Command, No output)

FOR MORE CLASSES VISIT