Open In App
Related Articles

Algorithms Quiz | Sudo Placement : Set 1 | Question 9

Improve
Improve
Improve
Like Article
Like
Save Article
Save
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