violations when loading the table . You may reorder the data provided for this table , but do not
alter it .
· 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 ).