DaniWeb IT Discussion Community - what is the purpose of BCNF and other ones?

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- Database Design (http://www.daniweb.com/forums/forum142.html)

- - what is the purpose of BCNF and other ones? (http://www.daniweb.com/forums/thread124832.html)

mertucci

May 18th, 2008 4:57 pm

what is the purpose of BCNF and other ones?

what is the purpose of BCNF and other ones?

lich	May 19th, 2008 2:53 am

Re: what is the purpose of BCNF and other ones?

this comes in normalisation

nomalisation theory is based on the observation that relations with certain properties are more effective in inserting, updating and deleting data than other sets of relations containing the same data.

normalisation is a multi step process begining with an un normalized relation

lich	May 19th, 2008 2:54 am

Re: what is the purpose of BCNF and other ones?

there are three type of normal forms

First normal form ( 1NF)
second normal form (2NF)
third normal form (3NF)

tesuji

May 19th, 2008 8:01 am

Re: what is the purpose of BCNF and other ones?

Quote:

Originally Posted by mertucci (Post 609511)

what is the purpose of BCNF and other ones?

To defeat the anomalies!

btw lich, there is more: BCNF, 4NF, 5NF, and 6NF (in concordance with C.J. Date).

Happy normalizations (as Nixon and Codd didn't say)!

krs,
tesu

lich	May 20th, 2008 2:14 am

Re: what is the purpose of BCNF and other ones?

Quote:

Originally Posted by tesuji (Post 609874)

To defeat the anomalies!

btw lich, there is more: BCNF, 4NF, 5NF, and 6NF (in concordance with C.J. Date).

Happy normalizations (as Nixon and Codd didn't say)!

krs,
tesu

oh is it. thanks for the information. i only learned up to 4NF. so thats y. anyway thanks.

All times are GMT -4. The time now is 8:50 pm.