Re: one table? five tables?

I didn't give it a VERY good going over, it was a bookmark from a while ago. Normalization also depends on the desired END result that you are trying to accomplish, and isn't an exact science in my opinion since there are so many examples/explanations out there with no consensus, too many variations of "Database" and "Design" and Normalization is good when just starting a new database, what happens when there are over 30M records (My company(Retail)) and over 750 programs hitting a database for just about any reason.

David Cressey wrote:

> It's useful to note that Fourth normal form in the Puppy example
> is a hurting pup.
>
> If the Puppy-Trick table has the primary key Puppy_id, Trick_id, then the
> example given
> violates Second normal form, forget about fourth normal form.
>
> Jeffrey Flaker wrote in message <39986531.A4E3A005_at_nac.net>...
> >Take a look at: http://www.state.sd.us/people/colink/datanorm.htm
  Received on Wed Aug 16 2000 - 16:33:09 CDT