How to approach the database design question

Copyright may 2007 william tan sauder school of

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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

{[ snackBarMessage ]}

Ask a homework question - tutors are online