What is bcnf boyce-codd normal form, Database Management System

BCNF Boyce-Codd Normal Form

A relation schema R is in BCNF if it is in 3NF and accepts an additional constraint that for every FD X A, X has to be a candidate key. If a relational process is in BCNF then all redundancy based on functional dependency has been replaced, although other kinds of redundancy can still exist. A relational schema R is in Boyce-Codd normal form if and only if for each one of its dependencies X → Y.


2290_BCNF Boyce-Codd Normal Form.png

Posted Date: 7/30/2012 2:24:59 AM | Location : United States

Related Discussions:- What is bcnf boyce-codd normal form, Assignment Help, Ask Question on What is bcnf boyce-codd normal form, Get Answer, Expert's Help, What is bcnf boyce-codd normal form Discussions

Write discussion on What is bcnf boyce-codd normal form
Your posts are moderated
Related Questions
Replicating Data One approach that may support efficient access to dissimilar applications as above may be to give access to every of the applications from dissimilar replicate

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

What is disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m

Explain trivial dependency? Functional dependency of the form α ->β. is trivial if α C β. Trivial functional dependencies are satisfied by all the relations.

Describe Database state in details? Database state: The actual data within the database at a particular moment in time is known as a database state.

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:

Data Mining 1. What is data mining? Write Data Mining applications. 2. Explain OLAP? Write the benefits of OLAP. 3. What are the key features of a Data Warehouse? 4. W

What are attributes? Give examples. An entity is shown by a set of attributes. Attributes are descriptive properties possessed by every member of an entity set. Example: pos

Examine about the Behavioural Diagrams  The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

What is Trigger? A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are kept in and managed by the DBMS. Triggers a