what is the purpose of BCNF and other ones?
mertucci
0
Newbie Poster
Recommended Answers
Jump to Postwhat 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
All 4 Replies
lich
-11
Junior Poster in Training
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
-11
Junior Poster in Training
there are three type of normal forms
First normal form ( 1NF)
second normal form (2NF)
third normal form (3NF)
tesuji
135
Master Poster
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
-11
Junior Poster in Training
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.