How to apply the bcnf decomposition , Database Management System

Consider the following relational scheme: R (a,b,c,d,e,f) and its corresponding set of FDs {d→a, bec, ace, bf, fd, ac}.

a. Is the following decomposition i) non-loss, ii) dependency preserving, iii) free of interrelational join constraints?

R1 (a,f,d), R2 (b,a,f), R3 (a,c,e)

b. Apply the BCNF decomposition on R

 

Posted Date: 4/6/2013 3:08:01 AM | Location : United States







Related Discussions:- How to apply the bcnf decomposition , Assignment Help, Ask Question on How to apply the bcnf decomposition , Get Answer, Expert's Help, How to apply the bcnf decomposition Discussions

Write discussion on How to apply the bcnf decomposition
Your posts are moderated
Related Questions
Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.  Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relati

What are the function of DBA?

Synonyms It allows short names or alternative names for objects. Example :               CREATE SYNONYM D30               FOR EMPD30;   Now if we give command:

Explain Authorization and Integrity Manager ? Authorization and Integrity Manager: Tests for the satisfaction of integrity constraints and checks the authority of users to acce

The dataset " CFOLYMPICS.XLS " contains the observations used in the above article.  The definitions of the variables are also included in this spreadsheet.  However, for the purpo


Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

What are the drawbacks of File Oriented System in details?

Give Concurrent sub states diagram for the classroom and exam held. In Figure, simultaneous substrates have been taken. After passing Minor 1 test you could give Minor 2 test. T