CIS 336 STUDY Great Stories/cis336study.com CIS 336 STUDY Great Stories/cis336study.com | Page 57

o Create all FK constraints as indicated in the ERD.
· Create all of the tables and all of the constraints before populating
any of the tables with data.
· Because FK constraints will be in place when the insert statements
are executed, you will need
to consider carefully which tables must be created before others in
order to ensure that FK
constraints are not violated.
· The COURSE table has a self-referencing FK constraint. Specifically,
some courses have
prerequisite courses. Consequently, the record for a course possessing
a prerequisite course
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