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
what are the main characteristics of database

What are the disadvantages of file-processing system?  Ans: The Disadvantages of File-Processing System a. Data redundancy and inconsistency - Data redundancy means not nece

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

what is RDBMS? how it works? good example.

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

What are the various forms of data transparency? a) fragmentation transparency b) replication transparency c) location transparency

Q.   Explain  data aggregatio n and discuss different design constraints. Sol. Aggregation   One limitation of the E-R model is that it cannot express relationships amon

Define Catalog and meta data ? A catalog is a compilation of records elaborating the contents of a particular collection or group of collections. Metadata (Meta data, or someti

You are managing the following database system: • DBMS: Oracle 11g • OS: Sun Solaris • System architecture: Web-based application using ASP.Net • Purpose of Server: HR manage

What are aggregate functions? And list the aggregate functions supported by SQL? Aggregate functions are functions that take a collection of values as input and return a one va