Test: Quiz: Second Normal Form

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

Second Normal Form
(Answer all questions in this section)

1. What is the rule of Second Normal Form? Mark for Review
(1) Points

All non-UID attributes must be dependent upon the entire UID (*)

Some non-UID attributes can be dependent on the entire UID

No non-UID attributes can be dependent on any part of the UID

None of the Above

2. Examine the following entity and decide which attribute breaks the 2nd Normal Form rule:
ENTITY: CLASS
ATTRIBUTES:
CLASS ID
DURATION
SUBJECT
TEACHER NAME AND ADDRESS

Mark for Review
(1) Points

CLASS ID

DURATION

SUBJECT

TEACHER NAME AND ADDRESS (*)

3. All instances of the subtypes must be an instance of the supertype. Mark for Review
(1) Points

True (*)

False

4. Not all instances of the supertype are instances of one of the subtypes. Mark for Review
(1) Points

True

False (*)

5. A supertype should have at least two subtypes. Mark for Review
(1) Points

True (*)

False


6. An entity can be on 2nd Normal Form even if it has repeated values. True or False? Mark for Review
(1) Points

True

False (*)