/[cvs.andrew.net.au]/uni/COMP2400/a1DB.sql
ViewVC logotype

Diff of /uni/COMP2400/a1DB.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1 by apollock, Sat Aug 7 11:07:01 2004 UTC revision 1.2 by apollock, Mon Aug 9 02:39:13 2004 UTC
# Line 1  Line 1 
1  -- A V Peterson   26-07-2004  -- A V Peterson   26-07-2004
2    -- Updated 05-08-2004: added FOREIGN KEY constraint on Parents(PersonId)
3  -- Database for Assignment 1  -- Database for Assignment 1
4    
5    
# Line 28  CREATE TABLE Parents Line 29  CREATE TABLE Parents
29    MotherId VARCHAR(6),    MotherId VARCHAR(6),
30    FatherId VARCHAR(6),    FatherId VARCHAR(6),
31    CONSTRAINT Parents_pk PRIMARY KEY (PersonId),    CONSTRAINT Parents_pk PRIMARY KEY (PersonId),
32      CONSTRAINT Parents_Person_fk
33         FOREIGN KEY (PersonId) REFERENCES Person(PersonId),
34    CONSTRAINT Parents_Mother_fk    CONSTRAINT Parents_Mother_fk
35       FOREIGN KEY (MotherId) REFERENCES Person(PersonId),       FOREIGN KEY (MotherId) REFERENCES Person(PersonId),
36    CONSTRAINT Parents_Father_fk    CONSTRAINT Parents_Father_fk
Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2
  ViewVC Help
Powered by ViewVC 1.1.22