Open In App

Algorithms Quiz | Sudo Placement : Set 1 | Question 9

Like Article
Like
Save Article
Save
Share
Report issue
Report

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
Previous
Next
Share your thoughts in the comments
Similar Reads