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

Ask an Expert

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

Write your message here..

Related Questions

What is candidate key, What is candidate key? Candidate Key - A candi... 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, What disadvantage of ODBC d... 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 described testing for null in sql?, What is NULL? Give an exa... 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, When is a transaction rolled back? A... 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

What is database files , The database files accept the actual data and ... 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, What are the properties in a relatio... What are the properties in a relation ? In a relation Ordering of rows is immaterial and No two rows are identical.

State the objectives of object design, Determine the OBJECTIVES of  object ... 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, Self-Join:   In a self join a table is joined with itself.  Let ... 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, What is a Name? A user-supplied name is used for identi... 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, Explain data abstraction? Data abstraction Da... 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