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. 2NF
B. 3NF
C. BCNF
D. 1NF
Answer: Option A
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.
Explanation:
Flat-file is not a database model; it is a simple file containing records. Hierarchical, Network, Relational, and Object-oriented are database models.
No comments yet. Be the first to start the discussion!