Normalization...

[dhtmlgod]

...so do you?

Doh, I was supposed to add a poll to this, but I forgot.

Well, anyway.

Do you take it to the standard 3rd Boyce-Cobb Normal Form? Or go all the way?!

Personally, I try and take it all the way to Domain-Key if I can during the logical design phase, but generally it denormalizes to the 3rd Normal Form when it actually comes down to planning and building the actual schema.

It does take a little longer, but I like doing it, and it help me keep on top of everything as I go into developing the ASP. Also helps keep on top of those rules!!!

[DevilBear]

You are crazy.



I don't know that many people are familiar with normalization, especially formally. I do it the best I can, but not very rigorously.

[Nicky]

D is right, you should normalise all your data to the third form. It is difficult at first but gets easier with practice. Not only is it professional to normalise, but it really saves a lot of hassle later as a lot of problems can arise it the normalisation stages are not followed. If you don't know anything about it read a book. I reccomend
Database Systems by John Jones

[siphilp]

Hey Nicky just noticed your new avatar.
NICE



Si

[Nicky]

Thanks, it's not new though, it is old!

[siphilp]

Who says that I am actually talking about the avatar itself and not the lady on it


Si

[dhtmlgod]

Strange... Si's post has been edited

[siphilp]

Yeah saw a mistake in my posting (honestly)


Si