Which of the following may contain partial dependencies,but cannot contain repeating groups?
A) unnormalized data
B) first normal form (1NF)
C) second normal form (2NF)
D) third normal form (3NF)

Question

Which of the following may contain partial dependencies,but cannot contain repeating groups?​
A) ​unnormalized data
B) ​first normal form (1NF)
C) ​second normal form (2NF)
D) ​third normal form (3NF)

Quizplus · Accepted Answer

First normal form (1NF) requires that each table has a primary key, and all fields within the table are atomic (indivisible). It may contain partial dependencies, but it cannot contain repeating groups. Unnormalized data (option A) may contain repeating groups and partial dependencies. Second normal form (2NF) and third normal form (3NF) address other types of data redundancies and dependencies but do not restrict repeating groups.

Which of the Following May Contain Partial Dependencies,but Cannot Contain