In database design, which normal form requires the table to be in 1NF and have all non-prime attributes fully functionally dependent on the primary key (no partial dependency)?
Subject: Database Systems
Topic: Database Normalization
Options:
- Option A: Second Normal Form (2NF)
- Option B: Third Normal Form (3NF)
- Option C: Boyce-Codd Normal Form (BCNF)
- Option D: Fourth Normal Form (4NF)
Correct Answer:
Option A: Second Normal Form (2NF)
Explanation:
2NF is violated when a non-key attribute depends on only a part of a composite primary key. Removing partial dependencies puts the table in 2NF.