Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: one table? five tables?

Re: one table? five tables?

From: Jeffrey Flaker <jeffreyf_at_nac.net>
Date: Wed, 16 Aug 2000 17:33:09 -0400
Message-ID: <399B0894.E5A30167@nac.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US