cannot be successfully inserted into the table unless the record for the prerequisite course has
already been inserted . This may require you to reorder the insert statements to resolve FK
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 ).
· 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 .