in Databases
1,006 views
1 vote
1 vote

How is A answer?

in Databases
by
1.0k views

1 comment

I think answer should be c
0
0

1 Answer

5 votes
5 votes
Best answer
Lossless: B is the intersection between two tables and B is the key in table 2.

Dependency preserving :
FD on R1 : A -> B

FD on R2 : B->D and D -> BC

union of these two can cover original FD set.

Hence dependency preserving.
selected by

2 Comments

I think there is a mistake in the question as in the first FD A->D, there should be A->B.

Isn’t it?
0
0
A->B fd is not in question. how did you do that? Can anyone please explain where the given decomposition is dependency preserving or not.
0
0

Related questions