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

Home -> Community -> Usenet -> c.d.o.server -> Re: DATA MODELLING - 3rd Normal Form

Re: DATA MODELLING - 3rd Normal Form

From: Parvora <parora_at_questone.com>
Date: Fri, 26 Nov 1999 11:01:59 GMT
Message-ID: <383E690D.53253655@questone.com>


exactly i too agree with that if u go for 3rd normal form(NF) then at times u come up with lot of tables and then at times the execution of complicated querries becomes very difficult which would involve a lot of tables and joins which would affect the performance

Regards
Parvinder

parkstate_at_my-deja.com wrote:

> A database is said to be relational only if it is *at least* in third
> normal form as per relational theory.
>
> As far as advantages/disadvantages are concerned, everything depends on
> the design requirements, user requirements, the type of queries that
> will be made, etc. Unless you know what you need, you cannot say
> whether a particular design has certain advantages or disadvantages.
>
> My two cents.
> PS.
>
> In article <80c1f8$u7d$1_at_nnrp1.deja.com>,
> burkeblackman_at_my-deja.com wrote:
> > Hello, I'm curious to know what the disadvantages of modelling in 3rd
> > normal form are.
> >
> > Thanks,
> > Burke
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Nov 26 1999 - 05:01:59 CST

Original text of this message

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