in Databases
441 views
1 vote
1 vote
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.
in Databases
by
441 views

2 Comments

edited by
How you decompose?

I'm  getting $4$
0
0

@Lakshman Patel RJIT Please explain fully. I have a lot of doubts in such questions.

0
0

1 Answer

2 votes
2 votes
Best answer

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

selected by

2 Comments

@Lakshman Patel RJIT

Great answer thanks.

One irrelevant question. How do you write such a colorful answer?

I mean which tool? 

0
0

@

https://en.wikipedia.org/wiki/Microsoft_Paint

I use only when required to draw something. otherwise write in text form is better.

thanks

1
1

Related questions