in Databases
3,583 views
3 votes
3 votes

How is it option D??

in Databases
3.6k views

2 Answers

3 votes
3 votes

option d

0 votes
0 votes
Here candidate keys are AB ,BC and F.

There is partial dependency in FD ( B->D ).

I think C->A is not partial dependency ,since A is key attribute.

So to eliminate that divide the table into two tables as

take B+ = { B,D,E } as one table and remaining as others and B is the common attribute .

So (ABCF) , (BDE) .

Correct if anything wrong.
edited by

4 Comments

okay.
0
0
Why there is a need to take closure of B....we can go with option B as B->D is only relation having PD ??
0
0
It's right ans
0
0

Related questions

0 votes
0 votes
1 answer
2