•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 428,063 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,466 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 837 | Replies: 4
 |
•
•
Join Date: May 2008
Posts: 16
Reputation: 
Rep Power: 1
Solved Threads: 0
Newbie Poster
what is the purpose of BCNF and other ones?
•
•
Join Date: May 2008
Posts: 53
Reputation: 
Rep Power: 0
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: 53
Reputation:
Rep Power: 0
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: 295
Reputation:
Rep Power: 1
Solved Threads: 41
Posting Whiz in Training
•
•
•
•
Originally Posted by mertucci 
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
Last edited by tesuji : May 19th, 2008 at 8:02 am.
•
•
Join Date: May 2008
Posts: 53
Reputation:
Rep Power: 0
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
|
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
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
