INFO20003 Database Systems 4 University of Melbourne Unary One to One Person ID

Info20003 database systems 4 university of melbourne

This preview shows page 4 - 9 out of 14 pages.

INFO20003 Database Systems 4 © University of Melbourne Unary: One-to-One Person (ID , Name, DateOfBirth, SpouseID ) Conceptual Design: Logical Design: ID Name DOB SpouseID 1 Ann 1969-06-12 3 2 Fred 1971-05-09 NULL 3 Chon 1982-02-10 1 4 Nancy 1991-01-01 NULL CREATE TABLE Person ( ID INT NOT NULL , Name VARCHAR (100) NOT NULL , DateOfBirth DATE NOT NULL , SpouseID INT, PRIMARY KEY (ID), FOREIGN KEY (SpouseID) REFERENCES Person (ID) ON DELETE RESTRICT ON UPDATE CASCADE ); SpouseID Implementation:
Image of page 4