What is boyce-code normal form, Database Management System

Boyce-Code Normal Form (BCNF)

A relationship is said to be in BCNF if it is already in 3NF and the left hand side of each dependency is a candidate key. A relation who is in 3NF is almost always in BCNF. These could be similar situation when a 3NF relation might not be in BCNF the following conditions are found true.

The candidate keys are composite.

There are more than one candidate keys in the relation.

There are some common attributes in the relation.

 

Posted Date: 7/26/2013 6:38:34 AM | Location : United States







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

Write discussion on What is boyce-code normal form
Your posts are moderated
Related Questions
What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

What disadvantage of ODBC does OLE DB overcome? By breaking the features and the methods of a DBMS into COM objects, OLE DB characteristic overcomes a main disadvantage of ODBC

What is NULL? Give an example to described testing for NULL in SQL? The NULL SQL keyword is used to represent either a missing value or a value which is not applicable in a re

When is a transaction rolled back? Any changes that the aborted transaction made to the database must be uncompleted. While the changes caused by an aborted transaction have be

The database files accept the actual data and are typically the biggest in size. Depending on their shape, the tables for all the user operation can go in one database file-but

What are the properties in a relation ? In a relation Ordering of rows is immaterial and No two rows are identical.

Determine the OBJECTIVES of  object design After passing through this unit, you should be able to: describe and apply concept of generalisation; understand and appl

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

What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it

Explain data abstraction? Data abstraction Data abstraction is a methodology in which enables us to isolate how a compound data object is utilized from the details of how it is