Skip to content
Related Articles

Related Articles

Algorithms Quiz | Sudo Placement : Set 1 | Question 9

View Discussion
Improve Article
Save Article
Like Article
  • Last Updated : 07 May, 2020

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

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

My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!