3
Contributors
4
Replies
5
Views
9 Years
Discussion Span
Last Post by lich
0

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

0

there are three type of normal forms

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

0

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

0

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.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.