Algorithms Quiz | Sudo Placement : Set 1 | Question 9

Consider the relation R (ABCDE):
FD = { A → B, B → C, C → D, D → E}
Find out the highest normal form.
(A) 1 NF
(B) 2 NF
(C) 3 NF
(D) BCNF

Answer: (B)
Explanation: Here candidate Key is A and B -> C , C -> D , D -> E all are. (Non prime attribute -> Non prime attribute.).

This type of FD must not be present in 3NF therefore highest normal form of this FDs are 2NF.

Option (B) is correct.
Quiz of this Question