 |  |  |  |  |  |  |  |
what is the purpose of BCNF and other ones?
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: May 2008
Posts: 65
Reputation: 
Solved Threads: 4
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
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
•
•
Join Date: May 2008
Posts: 65
Reputation:
Solved Threads: 4
Junior Poster in Training
there are three type of normal forms
First normal form ( 1NF)
second normal form (2NF)
third normal form (3NF)
First normal form ( 1NF)
second normal form (2NF)
third normal form (3NF)
•
•
Join Date: Apr 2008
Posts: 296
Reputation: 
Solved Threads: 42
Posting Whiz in Training
•
•
•
•
Originally Posted by mertucci 
what is the purpose of BCNF and other ones?
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
Last edited by tesuji; May 19th, 2008 at 9:02 am.
•
•
Join Date: May 2008
Posts: 65
Reputation:
Solved Threads: 4
Junior Poster in Training
•
•
•
•
Originally Posted by tesuji
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
|
Other Threads in the Database Design Forum
- Previous Thread: Why do we use "Decomposition" an How ?
- Next Thread: What is the diffrence between Key and Superkey how can we understand ? help me
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Database Design Posts
- Today's Posts
- Unanswered Threads
