Which normal form requires that a table is in 1NF and all non-key attributes are
Practice Questions
Q1
Which normal form requires that a table is in 1NF and all non-key attributes are fully functionally dependent on the primary key?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
Questions & Step-by-Step Solutions
Which normal form requires that a table is in 1NF and all non-key attributes are fully functionally dependent on the primary key?
Correct Answer: Second Normal Form (2NF)
Step 1: Understand what a normal form is in database design. It is a way to organize data to reduce redundancy and improve data integrity.
Step 2: Know that the First Normal Form (1NF) requires that all entries in a table are atomic, meaning each entry must contain indivisible values.
Step 3: Learn that the Second Normal Form (2NF) builds on 1NF. It requires that the table is already in 1NF.
Step 4: Understand that 2NF also requires that all non-key attributes (columns that are not part of the primary key) must depend on the entire primary key, not just part of it.
Step 5: Conclude that the normal form that requires a table to be in 1NF and ensures all non-key attributes are fully functionally dependent on the primary key is called Second Normal Form (2NF).
