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
Explain the Check Clause The CHECK clause is employed to at the end of a CREATE TABLE statement specify table constraints. This is known as table-based constraint because it ap

Smart Alex Catering Sevice (SACS) is a company offering top class catering staff  for prestigious events.  The company employs approximately 200 hourly paid contact staff - chefs,

Self-Join:   In a self join a table is joined with itself.  Let consider the following sample partial data of EMP table EMPNO ENAME MGRID

Define weak and strong entity sets? Weak entity set: entity set that do not have key attribute of their own are known as weak entity sets. Strong entity set: Entity set that

Explain different categories of failures that occur in Oracle database? Categories of Failures - In Oracle database subsequent types of failures can occurred: Statement Failu

how to submit answers softcopy


explain at least five widly used case tools

Consider the relation schemas as follows. works (person name, company name, salary); lives (person name, street, city); located in(company name, city); managers (person name

Produce a set of relations (equivalent to the Finkelstein entity list) in third normal form (3NF) from the following un-normalised relation. You must use the Finkelstein methodolog