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

Fds in relationships and teaches relationship, FDs in Relationships:  E... FDs in Relationships:  Enrols Relationship: None as it is many to many Teaches Relationship : Course code → Instructor Instructor → Course code The next question is:

Concatenation operator-data manipulation language, Concatenation operator ... Concatenation operator Example : Printing name and job as one string as column name employees: SELECT ENAME||JOB "EMPLOYEES" FROM EMP;

Implementing a data mining algorithm, i need to implememnt a treee based mi... i need to implememnt a treee based mining algorithm. do you have an expert that can do that?

Sql, find the name of supplier who supply some red part find the name of supplier who supply some red part

How to deal with the authentication problem, Most computer systems authenti... Most computer systems authenticate users by asking them for the user name and password. However, the user names and passwords often can be guessed by hackers. Suggest an automated,

Prepare entity relationship diagram for models your design, This project re... This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru.

How many block accesses average saved on using primary index, Normal 0 ... Normal 0 false false false EN-US X-NONE X-NONE

List the requirements needed to design a trigger, List the requirements nee... List the requirements needed to design a trigger. The requirements are:- Specifying when a trigger is to be implemented. State the actions to be taken when the trigger im

What is primary index, Primary Index In primary index, there is a one-t... Primary Index In primary index, there is a one-to-one relationship among the entries in the index table and the records in the major table. Primary index can be of two types:

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