Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Recent questions tagged canonical-cover
0
votes
1
answer
1
Minimal Cover
In questions asking for the number of FDs in minimal cover if I get say A $\rightarrow$ B A $\rightarrow$ C D $\rightarrow$ EF Then what do I count them as 2 or 3 or 4 FDs?
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?
Mrityudoot
235
views
Mrityudoot
asked
Jan 8
Databases
databases
canonical-cover
+
–
0
votes
1
answer
2
Database : Minimal cover How to approch this type of questions?
Ashutosh_17
2.3k
views
Ashutosh_17
asked
May 21, 2023
Databases
databases
canonical-cover
+
–
3
votes
1
answer
3
FD cover
F: { A-> BC, B->C, AC->B } G: { AB->C, A->B, A->C } Does G cover F?
F: { A- BC, B->C, AC->B }G: { AB->C, A->B, A->C }Does G cover F?
Tuhin Dutta
665
views
Tuhin Dutta
asked
Jan 19, 2018
Databases
databases
database-normalization
canonical-cover
+
–
3
votes
1
answer
4
Canonical cover
FDs are : A->C AC->D E->AD E->H Find : i) Number of FDs in canonical form. i) Number of FDs in minimal form.
FDs are :A->CAC->DE->ADE->HFind :i) Number of FDs in canonical form.i) Number of FDs in minimal form.
pa-try
1.5k
views
pa-try
asked
Nov 13, 2017
Databases
canonical-cover
databases
+
–
1
votes
0
answers
5
canonical cover
for the relational scheme R=(A,B,C), and the set F of functional dependencies A BC B C A B AB C compute Fc .
for the relational scheme R=(A,B,C), and the set F of functional dependenciesA BCB CA BAB Ccompute Fc .
set2018
657
views
set2018
asked
Jul 26, 2017
Databases
databases
canonical-cover
+
–
0
votes
1
answer
6
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 canonical cover of the above $FD$ set is: $A\rightarrow BC$, $C\ ... , $BC\rightarrow D$ , $E\rightarrow A$ $A\rightarrow BC$ , $B\rightarrow E$ , $B\rightarrow D$ , $E\rightarrow A$
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...
Bikram
343
views
Bikram
asked
Feb 9, 2017
GATE
tbb-mockgate-3
databases
database-normalization
canonical-cover
+
–
2
votes
0
answers
7
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). 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 ?
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)...
Kapil
1.4k
views
Kapil
asked
Nov 20, 2016
Databases
database-normalization
databases
canonical-cover
+
–
0
votes
2
answers
8
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.
Consider f is AB->C, C->A, BC->D, ACD->B, BE->C, CE->FA, CF->BD, D->E then find the canonical cover.
Amit parida
5.4k
views
Amit parida
asked
Nov 19, 2016
Databases
databases
canonical-cover
+
–
3
votes
1
answer
9
Made easy
Consider following set of FDs on R(A,B,C,D,E,F) A $\rightarrow$ BCD B $\rightarrow$ DE B $\rightarrow$ D D $\rightarrow$ A Compute the canonical cover.
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.
Srushti Makhija
569
views
Srushti Makhija
asked
Aug 13, 2016
Databases
canonical-cover
+
–
2
votes
1
answer
10
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\}$. Find the canonical cover for the above FD set $\{A \rightarrow BC, B \rightarrow C \}$ $\{A \rightarrow BC, AB \rightarrow C \}$ $\{A \rightarrow BC, A \rightarrow B \}$ $\{A \rightarrow B, B \rightarrow C \}$
Consider the following set of functional dependencies on the relation (ABC), $\{ A \rightarrow B, \: \: AB \rightarrow C, \:\: A \rightarrow BC, \:\: B \rightarrow C\}$.F...
Payal Rastogi
750
views
Payal Rastogi
asked
Aug 7, 2016
Databases
database-normalization
canonical-cover
+
–
2
votes
1
answer
11
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. Specialization is an abstraction in which ... condition. The concurrency control management component of the database is responsible for handling the concurrency control policies.
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...
learncp
530
views
learncp
asked
Jan 26, 2016
Databases
databases
canonical-cover
database-normalization
virtual-gate-test-series
+
–
2
votes
4
answers
12
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--> C B. A-->BC and AB--> C C. A--> BC and A--> B D. A--> B and B--> C
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 ...
Purple
18.1k
views
Purple
asked
Jan 24, 2016
Databases
database-normalization
databases
canonical-cover
decomposition
+
–
11
votes
3
answers
13
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 cover. Give BCNF decomposition of $R$ based on original set of FD. Can you get same decomposition of $R$ as above using canonical cover?
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...
Pooja Palod
3.5k
views
Pooja Palod
asked
Oct 21, 2015
Databases
databases
database-normalization
canonical-cover
+
–
6
votes
3
answers
14
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→C The canonical cover for this set is: A. A→BC and B→C B. A→BC and AB→C C. A→BC and A→B D. A→B and B→C
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...
amarVashishth
10.8k
views
amarVashishth
asked
Jul 25, 2015
Databases
databases
canonical-cover
database-normalization
+
–
To see more, click for the
full list of questions
or
popular tags
.
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register