@Utkarsh Joshi
We can decompose R as R1(A,B,C) and R2(B,D,E)
where is F ?
if you add F in R1 then it will lead to PFD, isn't it?
for 2NF, it requires 3 tables i.e., one of the decomposition is R1(A,B,C) , R2(B,D,E) and R3(A,C,F)
for 3NF/BCNF, it requires 4 tables i.e., one of the decomposition is R1(A,B,C) , R2(B,D) R4(D,E) and R3(A,C,F)
Shaik Masthan the thing is i completely forgot to take F in consideration i thought we are having just ABCDE as F was not part of any FD.
https://gateoverflow.in/?qa=blob&qa_blobid=11466423765690194514
Maybe for bcnf.
64.3k questions
77.9k answers
244k comments
80.0k users