What is bcnf boyce-codd normal form, Database Management System

BCNF Boyce-Codd Normal Form

A relation schema R is in BCNF if it is in 3NF and accepts an additional constraint that for every FD X A, X has to be a candidate key. If a relational process is in BCNF then all redundancy based on functional dependency has been replaced, although other kinds of redundancy can still exist. A relational schema R is in Boyce-Codd normal form if and only if for each one of its dependencies X → Y.

 

2290_BCNF Boyce-Codd Normal Form.png

Posted Date: 7/30/2012 2:24:59 AM | Location : United States







Related Discussions:- What is bcnf boyce-codd normal form, Assignment Help, Ask Question on What is bcnf boyce-codd normal form, Get Answer, Expert's Help, What is bcnf boyce-codd normal form Discussions

Write discussion on What is bcnf boyce-codd normal form
Your posts are moderated
Related Questions

Provide Examples of different types of Time and Date formats.  It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Question 1 Suppose the employee employee id, name, designation, salary, attendance and address of any employee has to be stored in a database. You can store these data in a sequen

Preliminary entities and attributes of human resourse management database management system

Views A view is like a window by which data from tables can be changed or viewed. The table on which a view is based is known as Base table. The view is stored as a SELECT stat

1. Determine that the Checkpoints are a part of  Ans: Checkpoints are a part of Recovery measures

Need For Distributed Database Systems A distributed database is a set of database kept on multiple computers that appears to applications as a one database. As a result, an app

To do the division operation R1 ÷ R2, R2 should be a correct subset of R1. In the following example R1 have attributes A and B and R2 have only attribute B so R2 is a correct subse

If the deletion violates referential integrity constraint, then three alternatives are available: Default option: - refuse the deletion. It is the job of the DBMS to describ

What are the two types of errors? The two types of errors are: a) Logical error b) System error