Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DATA MODELLING - 3rd Normal Form
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