1,660 views
5 votes
5 votes
Consider the following FD set {A → BC,B → AC, C → AB}. The number of different minimal covers possible for the above FD set __________ .

2 Answers

3 votes
3 votes

Minimal Cover means that you should not take those Functional Dependencies which could be derived without taking that Functional Dependency. In simplar words if there is Functional Dependency like A-->B you should not be able to derive it by A+ without A-->B. 

For this question we get 2 Functional Dependency sets which are minimal : 

A-->B, B-->C, C-->A

A-->C, B->A, C-->B

3 votes
3 votes
A--->B, A--->C, B-->A, C-->A

A--->B, B--->A, B-->C, C-->B

A--->B, B--->C, C-->B, C-->A

A-->B, B-->C, C-->A

 A--->C, B-->C, C-->A

total 5

Related questions

0 votes
0 votes
1 answer
1
Yogesh_Jangde asked 5 days ago
65 views
Consider R(A,B,C,D,E,H) be a relational schema with the following functional dependencies:A->BC, CD->E, E->C, D->AEH, ABH->BD, DH->BCFind minimal cover ?
0 votes
0 votes
1 answer
2
Mrityudoot asked Jan 8
235 views
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?
0 votes
0 votes
1 answer
3
0 votes
0 votes
1 answer
4
Shamim Ahmed asked Dec 20, 2018
592 views
I came across the questions where questions are asked about finding minimal cover and number of different minimal cover possible. Are they same?https://gateoverflow.in/28...