900 views
6 votes
6 votes

Decompose this table in BCNF ,decomposition should be lossless and dependency preserving.

plz clarify me how to decompose to get a lossless decomposition here.BCNF decompostion

3 Answers

Best answer
5 votes
5 votes
This table can be decomposed into BCNF as AC, CE, BD, AB . In AC, no FD is present, so it is in Bcnf form (a table with 2 attributes is always in Bcnf) in CE table, C is the superkey, in BD table, B is the superkey and in AB table, A is the superkey , and it will be dependency preserving as well as lossless decomposition.
selected by
2 votes
2 votes
4 tables created ..

here candidate key is AC...

so A->B fails to be in bcnf ....so we divide it in table ABD....in which B->D fails so we divide in AB and BD...

C->E again fails so we divide ....CE is table...

lastly to maintain KEYS ...we have AC...

so totals tables are

(AC)(BD)(AB)(CE)

Related questions

2 votes
2 votes
0 answers
1
4 votes
4 votes
1 answer
2
1 votes
1 votes
2 answers
3
Na462 asked Jun 29, 2018
541 views
1 votes
1 votes
2 answers
4