•
•
•
•
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 361,606 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,080 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:
Views: 590 | 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: 34
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
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: 34
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
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: 243
Reputation:
Rep Power: 1
Solved Threads: 28
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: 34
Reputation:
Rep Power: 1
Solved Threads: 2
Light Poster
•
•
•
•
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
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
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
