Multiple choice

Which of the following normal forms is depicted when a relation where primary key contains multiple attributes and no non-key attributes should be functionally dependent on a part of the primary key?

  1. 1 NF

  2. 2 NF

  3. 3 NF

  4. 5 NF

  5. BCNF

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Second normal form (2 NF) is depicted when a relation where the primary key contains multiple attributes and no non-key attributes should be functionally dependent on a part of the primary key.