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
The Database administrator (DBA) uses the data dictionary in each phase of a database life cycle, beginning from the data gathering phase to the design, execution and maintenance p

What are the ways in which signal can be generated A signal might be generated in many ways such as a Signal is result of particular physical condition. Whenever a process writ

What is Data dictionary? A data dictionary is a reserved space in a database that is employed to store information about the database itself. A data dictionary may consist o

Why did SAP introduce the extended star schema? Explain why it is reported to be better than the traditional schema model?

A file manipulation command that extracts some of the records from a file is called ? A file manipulation command that extracts some of the records from a file is called SELECT


When a function module is activated syntax checking is performed automatically. YEs, a function module is activated syntax checking.

Examples:- Hierarchical Model: It tells data as and relationships by hierarchy of data values. Figure illustrates an example of hierarchical model. Now a day's these models are

Describe the algorithm to draw the dependency graph?   Ans: Algorithm to draw Precedence Graph is like this: a.  For every transaction T i participating in schedule S, make

Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)