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
Part: Recommended (Non-query) Optimisations This section entitled "Recommended (non-query) optimisations" should be a brief report containing recommended optimisations you would

Type of views :  Simple views and Difficult Views Feature Simple Views Complex Views Number of tables One

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t

UNION If R1 and R2 are two union compatible relations then R3 = R1 ∪ R2 is the relation having tuples that are either in R1 or in R2 or in both. In case, R3 will have tuples

Northwind Pty Ltd sells a variety of food products throughout the world. They want to use the reporting features of SAP''s Business Information Warehouse to better understand thei

What is an ER diagram? Why is it used in Database management system (DBMS)?

What is relational model feature? A relational model feature is much more data independence than some other database models.

Explain the difference between optimistic locking and pessimistic locking. Optimistic locking supposes no transaction conflict will occur and deals with the consequences if it

a publishing company produce scientific books on various subjects. the books are written by authors who specialize in one particular subject. the company employs editors who, not n

Describe Specialsation and generalization? Specialisation /generalization: This is a top down and bottom up approach to the design of database. It displays the IS_A relation