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 create when a primary key combined with a foreign key, What will be cr... What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

The natural join is equal to which product, The natural join is equal to wh... The natural join is equal to which product? The natural join is equal to Combination of projection and Cartesian product

What do you mean by atomicity and aggregation, What do you mean by atomicit... What do you mean by atomicity and aggregation? Atomicity : Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete trans

File and system structure, Hierarchical Hierarchical

Define variable-length records arise in database, What are the ways in whic... What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o

A database administrator'', A database administrator''s responsibilities an... A database administrator''s responsibilities and data contents

Define query language, Define query language?   A query is a statement ... Define query language?   A query is a statement requesting the retrieval of information. The portion of DML that includes information retrieval is known as a query language.

Explain the concept of deadlock, Question: In a multi-user database env... Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Wound-wait scheme-deadlock prevention, " Wound-wait" scheme : It is based o... " Wound-wait" scheme : It is based on a preemptive method. It is based on a simple rule:                   If Ti requests a database resource that is held by Tj

Differentiate between various levels of data abstraction, Differentiate bet... Differentiate between various levels of data abstraction? Data Abstraction - Abstraction is the procedure to hide the irrelevant things from the users and represent the rele