7 votes 7 votes Consider the following FD set {A → BC,B → AC, C → AB}. The number of different minimal covers possible for the above FD set __________ . Databases databases minimal-cover + – srestha asked Feb 5, 2017 retagged Aug 5, 2017 by Arjun srestha 3.5k views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply vaishali jhalani commented Jan 25, 2017 reply Follow Share What is the proper method to find the minimal cover 0 votes 0 votes wxyz commented Jan 25, 2017 reply Follow Share {A->C, B->C, C->AB} 0 votes 0 votes Please log in or register to add a comment.
14 votes 14 votes here every key is a primary key.. numbber of minimal covers = 5 i think 1)A-->B, B-->C, C-->A 2)A-->C, C-->B, B-->A 3)B-->AC, A-->B ,C-->B 4)A-->BC , B-->A, C-->A 5)C-->AB ,A-->C, B-->C did i miss any? Anusha Motamarri answered Feb 5, 2017 Anusha Motamarri comment Share Follow See all 11 Comments See all 11 11 Comments reply Show 8 previous comments akharatgate commented Oct 10, 2018 reply Follow Share Insufficient answer without any detailed approach. 0 votes 0 votes Shamim Ahmed commented Dec 20, 2018 reply Follow Share @srestha Maam. the answer should be 4 right ? A-> C, B-> C, C-> A, C-> B. 0 votes 0 votes srestha commented Dec 20, 2018 reply Follow Share no selected ans is correct 0 votes 0 votes Please log in or register to add a comment.
3 votes 3 votes The minimal cover is A->C,B->C,C->A,C->B Another two are A->B,B->C.C->A and A->C,B->A,C->B . Thus total different minimal covers are 3. Arnabi answered Jan 25, 2017 edited Jan 26, 2017 by Arnabi Arnabi comment Share Follow See all 4 Comments See all 4 4 Comments reply vaishali jhalani commented Jan 26, 2017 reply Follow Share We have the find out the number of different minimal cover possible 0 votes 0 votes Arnabi commented Jan 26, 2017 reply Follow Share Is it 3? Other two are A->B,B->C,C->A And A->C,B->A,C->B 0 votes 0 votes Ashwani Kumar 2 commented Jul 22, 2017 reply Follow Share Can someone suggest the proper method to find all minimal covers 1 votes 1 votes Shamim Ahmed commented Dec 20, 2018 reply Follow Share @Arjun @srestha @Mk Utkarsh Is this the correct answer? 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes 4 IS THE CORRECT ANS krmanish043 answered Dec 20, 2018 krmanish043 comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 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 Pankaj Joshi answered Jan 28, 2017 Pankaj Joshi comment Share Follow See all 2 Comments See all 2 2 Comments reply vaishali jhalani commented Jan 28, 2017 reply Follow Share How did you find? 0 votes 0 votes Pankaj Joshi commented Jan 28, 2017 reply Follow Share I don't have any proper method I just some intution in selecting the set and then see if it is minimal or not 0 votes 0 votes Please log in or register to add a comment.