Vehicle-Relational-Schemas

Vehicle-Relational-Schemas - Vehicle Schema ER style Person...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Vehicle Schema ER style Person (SSN , name) Driver (SSN , driver-license), where SSN is a foreign key to Person.SSN Professional-Driver (SSN , medical-record), where SSN is a foreign key referring Driver.SSN Vehicle (make, year, license-plate, owner-SSN, insure-company- Name, max-liability, max-loss) where owner-SSN is a foreign key referring Person.SSN Car (license-plate , body-style), where license-plate is a foreign key referring Vehicle.license-plate Truck (license-plate , capacity), where license-plate is a foreign key referring Vehicle.license-plate Insurance-Company (name , phone-number) Operates (license-plate , SSN ), where license-plate is a foreign key referring Truck table, SSN is a foreign key referring to Professional-Driver table. Drives (license-plate , SSN ), where license-plate is a foreign key referring Car table, SSN is a foreign key referring to Driver table. Discussion: The above design is ER style. You can try to use OO style, or use nulls to map ISA relationship, and think about the pros and cons. 1.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

Vehicle-Relational-Schemas - Vehicle Schema ER style Person...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online