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

there are three type of normal forms

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

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

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.