0 votes 0 votes How many minimum number of tables will be formed if the relation R(A,B,C,D,E,F) with FD{A→BF,CD→E,B→D,E→A}is decomposed into BCNF? Anirban Biswas asked Dec 27, 2016 Anirban Biswas 506 views answer comment Share Follow See all 0 reply Please log in or register to add a comment.
0 votes 0 votes candidate keys :{ EC ,AC, BC,CD} DECOMPOSITION : (CDE) (EA) (ABF) (BD) SO TOTAL we need 4 relation to be in BCNF .?? correct me if wrong !! focus _GATE answered Dec 27, 2016 focus _GATE comment Share Follow See 1 comment See all 1 1 comment reply Mahima Manik commented Dec 28, 2016 reply Follow Share I'm also getting the same answer. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes Minimum is Three tables (A,B,F),(E,A),(C,D,E) shayal chhabra answered Jan 2, 2017 shayal chhabra comment Share Follow See all 0 reply Please log in or register to add a comment.