Section 6
(Answer all questions in this section)

  1. What is the rule of Second Normal Form?

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. An entity can be on 2nd Normal Form even if it has repeated values. True or False?

True

False


3. 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

CLASS ID

DURATION

SUBJECT

TEACHER NAME AND ADDRESS