This preview shows page 1. Sign up to view the full content.
Unformatted text preview: Exercise 16.9 Lease (leaseNo, invoiceNo, matricNo, placeNo) Primary Key : leaseNo Foreign key : invoiceNo references Invoice (invoiceNo) Foreign key : matricNo references Student (matricNo) Foreign key : Room references Room (placeNo) Room (placeNo, accomodationNo) Primary Key : placeNo Foreign Key : accomodationNo references Hall(hallNo) and Flat (flatNo) Student (matricNo, courseNo, NOK) Primary Key : matricNo Hall (hallNo) Primary Key: hallNo Flat (flatNo) Primary Key: flatNo Staff (StaffNo) Primary Key: staffNo Inspection (flatNo, staffNo) Primary Key: flatNo, staffNo...
View Full Document
- Spring '10