Database normalisation

Want to chit chat about anything, do it here ... posting here won't increase your post count (or shouldn't!). 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!
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. :(
Post Reply
erk
Registered User
Posts: 78
Joined: Fri Oct 26, 2001 8:16 pm
Location: PL/DE/ES/UK/HU
Contact:

Database normalisation

Post by 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?
"An egoist is a someone without good taste. He is interested more in himself than in me" - Ambrose Bierce

Stefan Koopmanschap
Registered User
Posts: 247
Joined: Sun Oct 28, 2001 9:47 am
Location: utrecht, the netherlands
Contact:

Post by 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
Registered User
Posts: 78
Joined: Fri Oct 26, 2001 8:16 pm
Location: PL/DE/ES/UK/HU
Contact:

Post by 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
"An egoist is a someone without good taste. He is interested more in himself than in me" - Ambrose Bierce

User avatar
mitsubishi
Registered User
Posts: 47
Joined: Fri Aug 31, 2001 6:25 am
Location: UK
Contact:

Post by mitsubishi »

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

Seem to get on alright without them tho :D
A weekend wasted is never a wasted weekend.

erk
Registered User
Posts: 78
Joined: Fri Oct 26, 2001 8:16 pm
Location: PL/DE/ES/UK/HU
Contact:

Post by 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
"An egoist is a someone without good taste. He is interested more in himself than in me" - Ambrose Bierce

BG
Registered User
Posts: 1
Joined: Sat Jan 12, 2002 2:47 am

Post by 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
Registered User
Posts: 78
Joined: Fri Oct 26, 2001 8:16 pm
Location: PL/DE/ES/UK/HU
Contact:

Post by 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....
"An egoist is a someone without good taste. He is interested more in himself than in me" - Ambrose Bierce

Post Reply