Register

Recent questions tagged canonical-cover

303
views
1 answers
0 votes
Minimal Cover
In questions asking for the number of FDs in minimal cover if I get sayA $\rightarrow$ BA $\rightarrow$ CD $\rightarrow$ EFThen what do I count them as2 or 3 or 4 FDs?
User Avatar
2.8k
views
1 answers
1 votes
Database : Minimal cover How to approch this type of questions?
User Avatar
706
views
1 answers
3 votes
FD cover
F: { A-> BC, B->C, AC->B }G: { AB->C, A->B, A->C }Does G cover F?
User Avatar
1.5k
views
1 answers
3 votes
Canonical cover
FDs are :A->CAC->DE->ADE->HFind :i) Number of FDs in canonical form.i) Number of FDs in minimal form.
User Avatar
682
views
0 answers
1 votes
canonical cover
for the relational scheme R=(A,B,C), and the set F of functional dependenciesA BCB CA BAB Ccompute Fc .
User Avatar
371
views
1 answers
0 votes
Test by Bikram | Mock GATE | Test 3 | Question: 38
Consider a relation $R$\left ( A, B,C,D, E \right )$ with the following $FD$ set $F$: $A\rightarrow BC$ $CD\rightarrow E$ $B\rightarrow D$ $ ... $A\rightarrow BC$ , $B\rightarrow E$ , $B\rightarrow D$ , $E\rightarrow A$
User Avatar
1.4k
views
0 answers
2 votes
DBMS Decomposition into 3NF and BCNF
Suppose a relation is given $R\left ( ABCDEF \right )$ ... on canonical cover ?C). Give BCNF decomposition of R based on original set of FD ?
User Avatar
5.7k
views
2 answers
0 votes
Database:
Consider f is AB->C, C->A, BC->D, ACD->B, BE->C, CE->FA, CF->BD, D->E then find the canonical cover.
User Avatar
606
views
1 answers
3 votes
Made easy
Consider following set of FDs on R(A,B,C,D,E,F)A $\rightarrow$ BCDB $\rightarrow$ DEB $\rightarrow$ DD $\rightarrow$ ACompute the canonical cover.
User Avatar
810
views
1 answers
2 votes
Ace Page# 12, Q# 29
Consider the following set of functional dependencies on the relation (ABC), ... \rightarrow BC, A \rightarrow B \}$\{A \rightarrow B, B \rightarrow C \}$
User Avatar
550
views
1 answers
2 votes
Virtual Gate Test Series: Databases - Aggregation
Which of the following is not true?Generalization is the result of taking the union of two or more disjoint entity sets to produce a higher ... component of the database is responsible for handling the concurrency control policies.
User Avatar
18.3k
views
4 answers
2 votes
Canonical cover of a set
Consider the following set of functional dependency on the scheme (A, B,C) A-->BC, B-->C, A--> B, AB-->C The canonical cover for this set is:(A) A-->BC and B--> CB. A-->BC and AB--> CC. A--> BC and A--> BD. A--> B and B--> C
User Avatar
3.7k
views
3 answers
11 votes
Decomposition
Consider following set of FDs on $R(A,B,C,D,E,F)$A \to BCD$BC \to DE$B \to D$D \to A$Compute the canonical cover.Give 3NF decomposition of $R$ ... on original set of FD.Can you get same decomposition of $R$ as above using canonical cover?
User Avatar
11.5k
views
3 answers
6 votes
Find canonical cover for the given set of functional dependencies.
Consider the following set of functional dependency on the scheme (A, B,C)A→BC, B→C, A→B, AB→CThe canonical cover for this set is:A. A→BC ... A→BC and AB→CC. A→BC and A→BD. A→B and B→C
User Avatar
To see more, click for the full list of questions or popular tags.