1,121 views
1 votes
1 votes
R(ABCDEF)

FD set{

AB->CDE. CD->E, E->C

}

False statement?

A. 2 NF decomposition possible

B.3 NF decomposition possible

C.BCNF decomposition possible

D. ALL

2 Answers

1 votes
1 votes
ABF is the candidate key in the relation. And I think 3NF decomposition is possible which would be ABF, ABCD, CDE. in relation CDE the FD E-> C will not satisfy BCNF condition.
0 votes
0 votes
since they have only asked if a decomposition is possible and not about lossless or FD preserving hence all are true it is always possible to decompose to BCNF

Related questions

2 votes
2 votes
2 answers
2
atulcse asked Jan 22, 2022
598 views
If AD is the only candidate key for some relation R(A,B,C,D,E) then will CD → E be considered a partial dependency?
1 votes
1 votes
2 answers
4
Na462 asked Jun 29, 2018
545 views