o Create all NOT NULL constraints as indicated in the ERD . o Create all PK constraints as indicated in the ERD . 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