This preview shows page 1. Sign up to view the full content.
Unformatted text preview: ust an “attribute” in the
Movie table (in reality, it is an entity in a one-to-one relationship). Copyright © May 2007 – William Tan, Sauder School of Business Page 1 of 3 8. If we need to track more about the studio (e.g. address, contact person, etc) then it
should be a table by itself. See below. One-To-One One-To-Many Determine The Relationships
9. Note that the table design on the left has Studio and Movie in a one-to-one
relationship. The table design on the right has Studio and Movie in a one-tomany relationship.
10. If an item is just an attribute, see which table each data item might best be
attached to. For example, attaching date and time of call to the Client...
View Full Document
This note was uploaded on 01/26/2014 for the course COMM 335 taught by Professor Y.m.cheung during the Fall '12 term at The University of British Columbia.
- Fall '12