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
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 in Architecture of the database ? Architecture of the database can be viewed as three levels.

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

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? Temporary Tables - Temporary tables exists solely for a particular session, or whose data persists for the duration of the transaction

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

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

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

what is Nested relational model? Explain with examples.

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