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

order to produce a script that runs without errors.
· Aside from reordering the data for the COURSE table as necessary,
and commenting
out/deleting the ONE record whose FK dependency cannot be resolved
by the data provided,
you are NOT to modify, add to, or delete from the data provided. Your
SQL script must produce
tables containing data identical to the expected solution set, or points
will be deducted.
· ALL character strings must be enclosed in single quotes. This
includes alpha strings and
alphanumeric (remember that any formatting within a numeric string
makes it alphanumeric).
· If you are inserting a NULL, do not enclose the word NULL in single
quotes, as this will insert the
word NULL into the row. To insert a null you simply use the word
NULL.
Deliverables
The deliverable for this lab will include the following documents.
1. Your script file. Create this file in Notepad, or another PURE TEXT
editor—NOT Word. Make sure
your name is in a comment area at the top of the script file. Use a
double dash to create a oneline comment.