diff --git a/STINK_student_records/STINK_student_records.xml b/STINK_student_records/STINK_student_records.xml index fa37fbb..5b2699b 100644 --- a/STINK_student_records/STINK_student_records.xml +++ b/STINK_student_records/STINK_student_records.xml @@ -352,7 +352,7 @@ -- CONSTRAINT Staff_PK PRIMARY KEY ( Staff_ID ), CONSTRAINT Staff_FK_to_Person - FOREIGN KEY ( Staff_ID ) REFERENCES Person ( Person_ID ) + FOREIGN KEY ( Staff_ID ) REFERENCES Person ); CREATE TABLE Student @@ -364,11 +364,11 @@ CHECK ( International IN ( 'T', 'F' ) ), Supervisor_ID NUMBER(7), -- optional -- - CONSTRAINT Student_PK PRIMARY KEY (Student_ID), + CONSTRAINT Student_PK PRIMARY KEY ( Student_ID ), CONSTRAINT Student_FK_to_Person - FOREIGN KEY (Student_ID) REFERENCES Person (Person_ID), + FOREIGN KEY ( Student_ID ) REFERENCES Person, CONSTRAINT Student_FK_to_Staff - FOREIGN KEY (Supervisor_ID) REFERENCES Staff (Staff_ID) + FOREIGN KEY ( Supervisor_ID ) REFERENCES Staff );