/* ------------------------------------------------------------------------- Yu Cheng ICS 321 Assignment 2 October 23, 2008 PART 1.1 Modify the PERSON table required for compliance with the Metadata Dictionary provided above. Be sure to establish a PK/FK recursive constraint relationship. ------------------------------------------------------------------------- */ USE DB9975 GO -- Update the PERSON table based on the Metadata Dictionary. Note that -- nowhere in the assignment is it specified WHO a person's supervisor is, -- so this script will create the column but not enforce the NOT NULL -- constraint as specified in the 'ENTITY DEFINITION HWA2F08.doc' file. ALTER TABLE PERSON ADD Supervisor INT NULL CONSTRAINT FK_PERSON_PERSON FOREIGN KEY (Supervisor) REFERENCES PERSON(Id) GO -- Also note the modifications to this table to support the badge assignment -- are done in part two of this assignment.
