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

North indian plains, i am not clear with the climetic condition of the nort... i am not clear with the climetic condition of the north indian plain. can u plz explain it for me

How many levels can be viewed architecture of the database, How many levels... How many levels can be viewed in Architecture of the database ? Architecture of the database can be viewed as three levels.

What is called as recursive partitioning, What is called as recursive parti... What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

Domains, A domain is a set of permissible values that can be given to an at... A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside

Write a short note on temporary tables, Write A short note on temporary tab... Write A short note on temporary tables? Temporary Tables - Temporary tables exists solely for a particular session, or whose data persists for the duration of the transaction

Define the terms entity, Define the terms entity, attribute, role and relat... Define the terms entity, attribute, role and relationship between the entities, giving examples for each of them.         Ans: Entity:   An entity is a "thing" or "object" in th

How to rearrange the execution order for efficiency, Rearrange the Executio... Rearrange the Execution Order for Efficiency  Rearranging execution order for efficiency means executing such job that requires less execution time. By rearranging the object

State in detail about data flow diagram, What is a Data Flow Diagram?  ... What is a Data Flow Diagram?  Data Flow Diagram: A data flow diagram is the graph that shows flow of data values from their sources in objects in the course of processes whic

Nested relational model, what is Nested relational model? Explain with exam... what is Nested relational model? Explain with examples.

What are called index-sequential files, What are called index-sequential fi... What are called index-sequential files? The files that are ordered sequentially with a primary index on the search key are known as index-sequential files