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