Define the boyce-codd normal form, Database Management System

Assignment Help:

Define the Boyce-Codd Normal Form with instance and also Compare BCNF and 3NF.

 Ans: BCNF: For each functional dependency X->Y in a set F of functional dependencies over relation R, either: 

  • Y is a subset of X or,
  • X is a superkey of R

 While

3NF: For each functional dependency X->Y in a set F of functional dependencies over relation R, either:  

  • Y is a subset of X or,
  • X is a superkey of R, or
  • Y is a subset of K for few key K of R

a.       there is no subset of a key is a key


Related Discussions:- Define the boyce-codd normal form

What are the different approaches for database design, What are the differe...

What are the different approaches for database design? There are two basic approaches for database design which are as follows: Attribute driven: It compiles a list of att

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

Relation instance or relation state, A relation instance indicates as r is ...

A relation instance indicates as r is a collection of tuples for a given relational schema at a exact point of time. A relation state r of the relation schema R (A 1 ,A 2 ,.....

Differentiate oo development from structured development., Differentiate OO...

Differentiate OO development from structured development. Structured approach of problem solving is based upon the idea of decomposition of system into subsystem. In this appro

What is a database graph, What is a database graph? The partial orderin...

What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.

Explain candidate key and super key, Explain Candidate Key and Super Key ...

Explain Candidate Key and Super Key A super key is a set of one or more than attributes that, taken collectively, permits us to identify uniquely a tuple in the relation. Wher

Datamodels, explain thee diffrent types of data models

explain thee diffrent types of data models

Oracle/sql, can you create a database for me in oracle/sql

can you create a database for me in oracle/sql

Write short note on data models, Write short note on Data models? Data...

Write short note on Data models? Data models: A data model is an abstract model which elaborates how data is represented and accessed. The term data model has two commonly ac

What is meant by object identifiers, What is meant by object identifiers? ...

What is meant by object identifiers? Object-oriented systems use an object identifier to recognize objects. Object identifiers are unique: that is every object has a single ide

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd