Register

Recent questions tagged canonical-cover

0 0 votes
1 answers 1 answer
720
720 views
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 2 votes
1 1 answer
5.9k
5.9k views
Database : Minimal cover How to approch this type of questions?
User Avatar
3 3 votes
1 1 answer
1.1k
1.1k views
FD cover
F: { A- BC, B->C, AC->B }G: { AB->C, A->B, A->C }Does G cover F?
User Avatar
3 3 votes
1 1 answer
1.9k
1.9k views
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
1 1 vote
0 0 answers
918
918 views
canonical cover
for the relational scheme R=(A,B,C), and the set F of functional dependenciesA BCB CA BAB Ccompute Fc .
User Avatar
0 0 votes
1 answers 1 answer
983
983 views
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$ $E\rightarrow A$The canonica...
User Avatar
2 2 votes
0 0 answers
1.7k
1.7k views
DBMS Decomposition into 3NF and BCNF
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)...
User Avatar
0 0 votes
2 2 answers
7.7k
7.7k views
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
3 3 votes
1 answers 1 answer
853
853 views
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
2 2 votes
1 answers 1 answer
1.0k
1.0k views
Ace Page# 12, Q# 29
Consider the following set of functional dependencies on the relation (ABC), $\{ A \rightarrow B, \: \: AB \rightarrow C, \:\: A \rightarrow BC, \:\: B \rightarrow C\}$.F...
User Avatar
2 2 votes
1 1 answer
867
867 views
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 level entity set.Specializatio...
User Avatar
2 2 votes
4 answers 4 answers
19.6k
19.6k views
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 ...
User Avatar
11 11 votes
3 answers 3 answers
4.9k
4.9k views
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$ based on canonical cove...
User Avatar
6 6 votes
3 answers 3 answers
15.1k
15.1k views
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 and B&r...
User Avatar
To see more, click for the full list of questions or popular tags.