Database normalisation
Forum rules
Please do not post any "phpBB" specific topics here unless they do not fit into the category above.
Do not post bug reports, feature or support requests! No really... Do not post bug reports, feature or support requests! Doing so will make Bertie a very sad bear indeed. :(
Please do not post any "phpBB" specific topics here unless they do not fit into the category above.
Do not post bug reports, feature or support requests! No really... Do not post bug reports, feature or support requests! Doing so will make Bertie a very sad bear indeed. :(
Database normalisation
There are 5 norms you should follow by making a new database...but in every book, which I read, people write only about 3 first norms. Everyone tells me 3 are enough to make a good database, because the last ones are only for special problems with really big databases...but I'm just curious...anyone could explain what are 4th and 5th norms about?
"An egoist is a someone without good taste. He is interested more in himself than in me" - Ambrose Bierce
-
- Registered User
- Posts: 247
- Joined: Sun Oct 28, 2001 9:47 am
- Location: utrecht, the netherlands
- Contact:
- mitsubishi
- Registered User
- Posts: 47
- Joined: Fri Aug 31, 2001 6:25 am
- Location: UK
- Contact:
maybe it's my english...I'm not sure if you call it norms or rules or whatever. you should follow this rules to not make your database entries redundant, to keep your database simple, logical and easy to mantain
"An egoist is a someone without good taste. He is interested more in himself than in me" - Ambrose Bierce
If your really wanting to punish yourself to know 4th and 5th normal forms...
http://www.gslis.utexas.edu/~l384k11w/normover.html
...gives a decent overview and was all I could find on the web using Google.
http://www.gslis.utexas.edu/~l384k11w/normover.html
...gives a decent overview and was all I could find on the web using Google.