What is Boyce Codd Normal form?

Q

What is Boyce Codd Normal form?

✍: .fyicenter.com

A

A relation schema R is in BCNF with respect to a set F of functional dependencies if for all functional dependencies in F+ of the form a-> , where a and b is a subset of R, at least one of the following holds:
* a- > b is a trivial functional dependency (b is a subset of a)
* a is a superkey for schema R

2012-02-15, 2663👍, 0💬