Which normal form addresses partial dependencies, i.e., non-prime attributes dependent on part of a composite primary key? MCQ with Answer and Explanation
Which normal form addresses partial dependencies, i.e., non-prime attributes dependent on part of a composite primary key?
A. BCNF
B. 1NF
C. 2NF
D. 3NF
Answer: Option C
Solution (By JKSSB Mock Tests)
Second Normal Form (2NF) eliminates partial dependencies by ensuring all non-key attributes are fully functionally dependent on the entire primary key.
No comments yet. Be the first to start the discussion!