1 1 vote Consider the following statements:1. The redundancy in the set of relation that have been arised after decomposing a relation R into BCNF is zero irrespective of the type of dependencies.2. BCNF decompositions are always lossless as well as dependency preserving.3. A prime attribute of a relation schema R is an attribute that appears in all candidate key of R.4. A relation R is in 3NF, if every non-prime attribute of R, is fully functionally dependent on some key of R.The number of statements are correct _______.WHAT IS DIFFERENCE BETWEEN TRANSITIVE DEOENDENCY AND FULLY FUNCTIONAL DEPENDENCY?? Databases databases database-normalization normal-forms bcnf + – Jaspreet Kaur Bains 850 views answer comment Share Follow Print See 1 comment 1 1 comment reply irfan_ commented Dec 13, 2017 reply Follow flag Transitive dependency is expressing the dependency of A on C when A depends on B and B depends on C. A functional dependency is an association between two attributes of the same relational database table. One of the attributes is called the determinant and the other attribute is called the determined. For each value of the determinant there is associated one and only one value of the determined. 0 0 replyShare Please log in or register to add a comment.
1 1 vote Answer 1: False.BCNF is 100% FREE from Redundancies caused by functional dependencies, But may have redundancies due to MVDs.Detailed Explanation: https://youtu.be/zypcOTF-Lxw Answer 2: False.It is always possible to decompose a relation into a set of relations that are in BCNF such that the decomposition is lossless But it may not be possible to preserve dependencies.Answer 3: False.A prime attribute of a relation schema R is an attribute that appears in at least one candidate key of R.Explained Here: https://www.youtube.com/watch?v=SN1Fa1c5Kg8&t=638sAnswer 4: FalseA relation R is in 3NF, if No non-prime attribute of R, is transitively dependent on any key of R.Explained Here: https://youtu.be/Ai-zpaUbXzs?t=1540&feature=sharedAnswer 5:WHAT IS DIFFERENCE BETWEEN TRANSITIVE DEOENDENCY AND FULLY FUNCTIONAL DEPENDENCY??Understand Clearly Here: https://youtu.be/SN1Fa1c5Kg8?feature=shared Deepak Poonia answered Jul 17, 2024 Deepak Poonia comment Share Follow See 1 comment 1 1 comment reply saurabh0709 commented Sep 14, 2024 reply Follow flag Excellent answer 0 0 replyShare Please log in or register to add a comment.
