410 views
1 votes
1 votes
Consider a relation R(ABCDE) and functional dependency F1 = {A → B, C → E, B → D}.

If the relation is decomposed into BCNF with lossless decomposition and dependency preserving then total number tables is ___________.

I am getting 3 but the answer given is 4.

1 Answer

Best answer
2 votes
2 votes

The relation is decomposed into BCNF with lossless decomposition and dependency preserving then total number tables $=4$

selected by

Related questions

0 votes
0 votes
2 answers
3
Suvam Chatterjee asked Sep 9, 2015
509 views
I think conservative 2PL prevents deadlock also. What should be the answer? 
2 votes
2 votes
1 answer
4
h4kr asked Dec 8, 2022
293 views
I think the answer should be (B) would be right, because lets say in R, there is a FD NPA - CK, it won't qualify as BCNF even if CK is single attribute