Ask a Question

  1. Home
  2. Ask a Question
  3. Question Details
Doubts ?
Post a question
Ask Us

Categories

difference between BCNF & 3NF with example.

on 2011-11-03 22:55:06   by Ayan   on Electronics & Communication  1 answers

Subhamoy

on 2011-11-10 10:30:00  

In 3NF --> a relation schema R is said to be in 3nf if the nontrivial dependancy X->A holds such that either X is a super key of R or A is a prime attribute of R. In BCNF -->a relation schema R is said to be in BCNF if the nontrivial dependancy X->A holds such that X must be a super key of R.