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
Last Updated :
07 May, 2020
Like Article
Save Article
Share your thoughts in the comments
Please Login to comment...