Test: Quiz: Identifying Relationships

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