Week4.Metro.Exercise.Solution

Week4.Metro.Exercise.Solution - UnitID Primary key UnitSize...

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

View Full Document Right Arrow Icon
Metro Project Solution TRACT is the parent to BUILDING: One-to-Many. One Tract can have one or more Buildings. One Building can only be in one Tract. BULDING is the parent to UNIT: One-to-Many. One Building can have one or more Units. One Unit can only be in one Building. TRACT TractID (Primary Key) TractSize TractName TractLocation BUILDING BuildingID (Primary Key) BuildingAddress BuildingName BuildingManagerName
Background image of page 1

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

View Full DocumentRight Arrow Icon
BuildingPhoneNumber TractID (Foreign key to TRACT table) UNIT BuildingID Primary key and (Foreign key to the BUILDING table.)
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: UnitID Primary key UnitSize NumberOfBedrooms Occupied BuildingID and UnitID make up the composite primary key. There is one primary key in the table but it is composed of two columns. Makes sense to do this since several buildings can have the same unit numbers (apartment numbers ) in them. Adding the Building ID to the primary key will allow you to use the unit numbers as part of the primary key because each building ID will be unique unlike unit numbers....
View Full Document

This note was uploaded on 04/22/2010 for the course CIS CIS321 taught by Professor Burnham during the Spring '10 term at DeVry Arlington.

Page1 / 2

Week4.Metro.Exercise.Solution - UnitID Primary key UnitSize...

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