Section 1
1. Relationships always exist between Mark for Review
(1) Points
3 or more entities
2 entities (or one entity twice) (*)
2 attributes
3 or more attributes
2. Relationships can be either mandatory or optional. True or False? Mark for Review
(1) Points
True (*)
False
3. In a business that sells computers, choose the best relationship name from CUSTOMER to ITEM (computer, in this case). Mark for Review
(1) Points
Each CUSTOMER must be the buyer of one or more ITEMS. (*)
Each CUSTOMER must be the seller of one or more ITEMS.
Each CUSTOMER may be the maker of one or more ITEMS.
Each CUSTOMER may be the producer of one or more ITEMS.
4. What are the three properties that every relationship should have? Mark for Review
(1) Points
Transferability, degree, name
Name, optionality, degree (*)
A UID bar, a diamond, an arc
Name, optionality, arcs
