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
