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
using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

Describe Application programming interface? Application Programming Interface - Commercial SQL implementations take one of the two primary techniques for involving SQL in a p

What are the DBMS languages? Briefly explain? Data Definition language (DDL):A database schema is specified through a set of definitions expressed through a special language

Question 1 Discuss on transmission impairments Question 2 What is framing? Question 3 Write a note on 10Base2 10Base- T Question 4 Explain the rev

How Relational Calculus is different from Relational Algebra? What do understand by TRC queries and DRC queries?  Ans: Relational calculus contain two calculi, the tuple relati

Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin

Explain pipelining.        Ans: In order to describe pipelining in simple terms, think of it as breaking down processor functions into smaller and smaller parts. For instance,

What is trigger?  Triggers are statements that are executed automatically by the system as the side effect of a modification to the database.

What is meant by object identifiers? Object-oriented systems use an object identifier to recognize objects. Object identifiers are unique: that is every object has a single ide

Define Two phase commit Two phase commit: To make sure atomicity, all the sites where a transaction is being executed must agree on the final outcome of the execution. The tran