This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full 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
- Spring '10