CIS 336 STUDY Extraordinary Success /cis336study.com CIS 336 STUDY Extraordinary Success /cis336study.c | Page 55

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.
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