CIS 336 All Assignments CIS 336 All Assignments | Page 39

· The data for one table intentionally contains a record containing an FK constraint that is not
resolved by a record in the parent table. This orphaned record has been included as an exercise
for you to find. Because this record has an unreconciled FK constraint, it cannot be successfully
inserted. You will need to delete or comment out the insert statement for this one record in
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 one-
line comment.
–Jane Smith
–Lab 3
2. Your script file must execute without error. It is recommended that you begin early in the
week,
and post any questions to the Q & A discussion in order to produce a working script by the due