Database normalisation

[erk]

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?

[Stefan Koopmanschap]

sorry, they only taught me the first three in school. the teacher only mentioned the other two once, right at the beginning, and told us to forget about it immediately :)

[erk]

Yeah...I hear it also all the time...But someone have to know all 5 norms...or is it like from a novel of Franz Kafka...everyone knows that something exists, but noone has ever seen it :D

[mitsubishi]

Well I don't ave a clue what you're talkin about :oops:

Seem to get on alright without them tho :D

[erk]

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

[BG]

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.

[erk]

thx...I should have done some research first...of course I probably wouldn't find anything :wink: It quite difficoult to search when you aren't sure what for....