A relation which is in 1NF and no attribute that is not a part of the Primary…
2022
A relation which is in 1NF and no attribute that is not a part of the Primary Key is partially dependent only on a portion of the Primary Key is in which Normal Form?
- A.
2NF
- B.
3NF
- C.
4NF
- D.
5NF
Attempted by 879 students.
Show answer & explanation
Correct answer: A
A relation is said to be in Second Normal Form (2NF) if: It is already in First Normal Form (1NF), and No non-primary key attribute is partially dependent on the primary key. Partial dependency occurs when a proper subset of a composite primary key determines a non-key attribute. Removal of such dependency leads to 2NF.