1 votes 1 votes R(ABCDEF) FD set{ AB->CDE. CD->E, E->C } False statement? A. 2 NF decomposition possible B.3 NF decomposition possible C.BCNF decomposition possible D. ALL Databases databases + – parthbkgadoya asked Feb 1, 2017 parthbkgadoya 1.1k views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply Dulqar commented Feb 1, 2017 reply Follow Share 2NF possible . 3NF not possible since non - key values determine non key terms 1 votes 1 votes Kaushik.P.E commented Feb 1, 2017 reply Follow Share pls verify my answer. and post a screenshot of the solution if possible. 0 votes 0 votes Please log in or register to add a comment.
1 votes 1 votes ABF is the candidate key in the relation. And I think 3NF decomposition is possible which would be ABF, ABCD, CDE. in relation CDE the FD E-> C will not satisfy BCNF condition. Kaushik.P.E answered Feb 1, 2017 Kaushik.P.E comment Share Follow See all 4 Comments See all 4 4 Comments reply Dulqar commented Feb 1, 2017 reply Follow Share How 3NF possible ?? CD -> E NonPrime Attribute is determine Non Prime Attribute which is not allowed in 3NF Moreover, CD-> C is Trivial FD CD->E and E->C should not be present due to transitivity . The given Relation is 2NF only 0 votes 0 votes Kaushik.P.E commented Feb 1, 2017 reply Follow Share CD and ED are candidate keys of the decomposition CDE. You must find the FD's of each decomposition by using closure, then find the candidate keys.And finally check for PDs and TDs within the decomposition. By practise you'll be able to do this intuitively and very quickly. 0 votes 0 votes Dulqar commented Feb 1, 2017 reply Follow Share Can u explain me the question ? Doesn't it meant to find the highest normal form of the relation given ? Im confused with the word "decomposed " in the question . 0 votes 0 votes Kaushik.P.E commented Feb 1, 2017 reply Follow Share When a relation doesn't satisfy a normal form, we can decompose it(split into multiple tables) in such a way that the resultant relations satisfy it. For eg: For 1NF if there's a multivalued attribute in a relation we decompose it into two tables. One with primary key and multivalued attribute and the other table will have the key and remaning attributes in the original relation. And referential relationship will exsist between the two new tables. Refer Navathe. best resource for DBMS. or refer techtud videos in youtube. 0 votes 0 votes Please log in or register to add a comment.
0 votes 0 votes since they have only asked if a decomposition is possible and not about lossless or FD preserving hence all are true it is always possible to decompose to BCNF Pankaj Joshi answered Feb 1, 2017 Pankaj Joshi comment Share Follow See all 2 Comments See all 2 2 Comments reply Kaushik.P.E commented Feb 1, 2017 reply Follow Share Not a valid logical reason my friend. They need not explicitly specify every condition. your argument is similar to saying that a linear equation can be proven by multiplying by zero on both sides as the quesion does not mention that such techniques cannot be used. 0 votes 0 votes Pankaj Joshi commented Feb 2, 2017 reply Follow Share i think it is true because we don''t always need FD preserving decomposition we care about lossless decomposition and BCNF is always lossless 0 votes 0 votes Please log in or register to add a comment.