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
In a relational model how relations are termed? In a relational model, relations are termed as tables. (The term ‘relation’ is the technical name of the ‘table’ in RDBMS)

What is the use of a slotted-page structure and what is the information are there in the header? The slotted-page structure is used for organizing records within a one block.

Fifth Normal Form (5NF) These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two ta

Create an entity relationship diagram, Database Management System

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

Explain the difference between using functions along with and without grouping attributes in relational algebra. Give examples. Ans: Group functions are used to group data of

Data Redundancy -A lot of information is being repeated in the relation. For instance, the information that MCS-014 is named SSAD is repetitive, address of Rahul is "D- 27, Main ro

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

Domain Constraints Domain constraints are primarily formed for defining the logically correct values for an attribute of a relation. The relation allows attributes of a relatio

Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock