Test: Quiz: Arcs

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

Arcs
(Answer all questions in this section)

1. Which of the following can be added to a relationship? Mark for Review
(1) Points

an attribute

an arc can be assigned (*)

a composite attribute

an optional attribute can be created

2. Secondary UID's are Mark for Review
(1) Points

not permitted in data modeling

mandatory in data modeling

useful as an alternative means identifying instances of an entity (*)

always comprised of numbers

3. Which of the following would best be represented by an arc? Mark for Review
(1) Points

STUDENT (senior, junior)

STUDENT (graduating, non-graduating)

STUDENT (will-attend-university, will-not-attend-university)

STUDENT ( University, Trade School) (*)

4. If the entity CD has the attributes: #number, *title, *producer, *year, o store name, o store address, this entity is in 3rd Normal Form ("no non-UID attribute can be dependent on another non-UID attribute). True or False? Mark for Review
(1) Points

True

False (*)


5. Which of the following is the definition for Third Normal Form? Mark for Review
(1) Points

All attributes are single valued

An attribute must be dependent upon entity's entire unique identifier

No non-UID attribute can be dependent on another non-UID attribute (*)

All attributes are uniquely doubled and independent

6. To visually represent exclusivity between two or more relationships in an ERD you would most likely use an ________. Mark for Review
(1) Points

Arc (*)

UID

Subtype

Supertype

7. This diagram could also be expressed as a supertype/subtype construction. True or False?

Mark for Review
(1) Points

True

False (*)

8. All parts of a UID are mandatory. True or False? Mark for Review
(1) Points

True (*)

False