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 (*)
7.As a database designer it is your job to store data in only one place and the best place. True or False? Mark for Review
(1) Points
True (*)
False
