Dark Mode

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?

Mrityudoot asked in Databases Jan 8

216 views

0 votes

1 answer

2

Database : Minimal cover How to approch this type of questions?

Ashutosh_17 asked in Databases May 21, 2023

2.0k views

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?

Tuhin Dutta asked in Databases Jan 19, 2018

665 views

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.

pa-try asked in Databases Nov 13, 2017

by pa-try

1.4k views

1 vote

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 .

set2018 asked in Databases Jul 26, 2017

659 views

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$

Bikram asked in GATE Feb 9, 2017

by Bikram

346 views

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 ?

Kapil asked in Databases Nov 20, 2016

by Kapil

1.4k views

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.

Amit parida asked in Databases Nov 19, 2016

5.3k views

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.

Srushti Makhija asked in Databases Aug 13, 2016

by Srushti Makhija

573 views

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 \}$

Payal Rastogi asked in Databases Aug 7, 2016

by Payal Rastogi

718 views

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.

learncp asked in Databases Jan 26, 2016

528 views

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

Purple asked in Databases Jan 24, 2016

by Purple

18.0k views

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?

Pooja Palod asked in Databases Oct 21, 2015

3.5k views

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

amarVashishth asked in Databases Jul 25, 2015

by amarVashishth

10.5k views

To see more, click for the full list of questions or popular tags.

Recent questions tagged canonical-cover