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

Describe the host language, Describe the host language? Host Language:... Describe the host language? Host Language: You could write applications along with SQL statements embedded inside a host language. The SQL statements give the database inter

What is the used of specifying alias, What is the used of specifying alias?... What is the used of specifying alias? Specifying alias: is used to rename column or attribute in a table.

What are domain constraints, What are domain constraints?  A  domain is... What are domain constraints?  A  domain is  a  set  of  values  that  might  be  assigned to an attribute  .all  values that appear in a  column of a relation must be taken fro

Relationships, Let us first describe the term relationships. What Are Re... Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic

In an e-r diagram how attributes are represented, In an E-R diagram how att... In an E-R diagram how attributes are represented ? In an E-R diagram attributes are represented in a ellipse.

What do you mean by an execution plan, What do you mean by an execution pla... What do you mean by an execution plan? Why is it used? How will you view it? a.) An execution plan can be known as a road map which textually or graphically illustrates the dat

Physical datastructure, what is physical data structure what is physical data structure

What are the concurrency issues, Concurrency issues Data integrity... Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

The locking protocol, The Locking Protocol: To manage concurrency related ... The Locking Protocol: To manage concurrency related problems we use locking. A lock is mainly a variable that is associated with a data item in the database. A lock can be located

Function module, When a function module is activated syntax checking is per... When a function module is activated syntax checking is performed automatically. YEs, a function module is activated syntax checking.