Consider the following functional dependencies for relation R(A,B,C,D,E) and find normal form

$A B \to C D, D \to A, B C \to D E$

3 NF

Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses

BCNF

No worries! We‘ve got your back. Try BYJU‘S free classes today!

2 NF

No worries! We‘ve got your back. Try BYJU‘S free classes today!

1 NF

No worries! We‘ve got your back. Try BYJU‘S free classes today!

Open in App

Solution

The correct option is A 3 NF
Above relation is in 3 NF
Candidate key are AB, BC, DB
For $A B \to C D a n d B C \to D E$

AB and BC are candidates key
And
For D $\to$ A, A is prime attribute.

Suggest Corrections

Similar questions

F = {A \to B C, C D \to E, B \to D, E \to A}

F = {B C D \to A, B C \to E, A \to F, F \to G, C \to D, A \to G}

C o n s i d e r a r e l a t i o n R (A, B, C, D, E) w i t h f u n c t i o n a l d e p e n d e n c i e s : N u m b e r o f c a n d i d a t e s k e y i n a b o v e r e l a t i o n R i s______. F = (A E \to C, C D \to E, C \to A, C \to D, D \to E]

F = {A \to B, B C \to E, E D \to A}

F = {A \to B, B C \to E, E D \to A}

Join BYJU'S Learning Program