Register

BCNF decomposition

1,148 views
1 1 vote

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · Test SeriesNext → · Graph theory
← Previous in category · Full Outer JoinNext in category → · Virtual Gate test se...
Position:
Show:

Related questions

2 2 votes
1 1 answer
101
101 views
GO Classes asked Sep 19
101 views
GO Classes DPP | GATE CS, DA | DBMS | BCNF Decomposition
Which statement correctly describes the guarantee of the standard BCNF decomposition procedure?Every relation has a decomposition that is simultaneously BCNF, lossless an...
4 4 votes
1 1 answer
110
110 views
GO Classes asked Sep 19
110 views
GO Classes DPP | GATE CS, DA | DBMS | BCNF Decomposition
Consider $R(A,B,C,D,E,F)$ with $F=\{A\to B,\ A\to C,\ BC\to E,\ BC\to D,\ E\to F,\ BC\to F\}$.Suppose the following BCNF decomposition is used:$R_1(B,C,E)$$R_2(B,C,F)$$R_...
3 3 votes
1 1 answer
148
148 views
GO Classes asked Sep 18
148 views
GO Classes DPP | GATE CS, DA | DBMS | BCNF Decomposition
Consider $\text{GSL}(D,M,N_1,N_2,G_1,G_2,C_1,C_2,E,R)$, where $M$ is the primary key, together with$M\to D,$$E\to R,$$N_1\to G_1C_1,$$N_2\to G_2C_2,$$G_1C_1\to N_1,$$G_2C...
4 4 votes
1 1 answer
122
122 views
GO Classes asked Sep 18
122 views
GO Classes DPP | GATE CS, DA | DBMS | BCNF Decomposition
Consider $R(A,B,C,D,E)$ with $F=\{AB\to C,\ BC\to D,\ CD\to E,\ DE\to A\}$.Suppose the BCNF decomposition begins with the violating FD $:CD\to E$.Which set of relations i...