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
- Fall '12
- Many-to-many, Candidate key, One-to-many, Sauder School of Business, William Tan