closed by
1,344 views
2 votes
2 votes
closed with the note: Duplicate of : https://gateoverflow.in/20483/decomposition

Suppose a relation is given $R\left ( ABCDEF \right )$ with the given set of FD's

$\left \{ A \rightarrow BCD, BC\rightarrow DE, B\rightarrow D,D\rightarrow A \right \}$


A). Compute the Canonical Cover ?

B). Give 3NF decomposition of R based on canonical cover ?

C). Give BCNF decomposition of R based on original set of FD ?

closed by

Related questions

11 votes
11 votes
3 answers
1
0 votes
0 votes
0 answers
2
rahul sharma 5 asked Dec 15, 2017
1,180 views
Minimum relations to decompose into BCNF and 4NF.List only relation names with attributes and total number of relations
3 votes
3 votes
1 answer
3
Tuhin Dutta asked Jan 19, 2018
651 views
F: { A- BC, B->C, AC->B }G: { AB->C, A->B, A->C }Does G cover F?