|
Home > Archive > microsoft.public.cert.mcdba > June 2002 > Normalization ?? anyone from Microsoft ??
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Normalization ?? anyone from Microsoft ??
|
|
| Sanjay Gangwal 2002-06-23, 6:15 am |
| Hi
I'm preparing for 70-029. And I was going thru the
Transcender for this. There is one question in Transcender
exam where it gives the logical design of the database and
asks for the compliance with Normal forms.
According to my understanding the Normal forms are
incremental i.e. if table is in 3NF it has to be in 2NF
and so on.
But according to Transcender answer -- it said that --
database does not satisfies 2NF but it is in 1NF and 3NF.
so I was wondering what exactly is the understanding of
the MICROSOFT about this Normalization definition ??
Can anyone help ?? especially from Microsoft training and
Certification ??
Thanks in advance,
Sanjay
| |
|
| You are correct, 2NF compliance is required for 3NF (for example).
I don't think the MS exam will call for more academic issues like which rule
is associated with which normal form. It's more important, as in real life,
just to know what "normalized" is (up to 3nf, at least) and stick to that
unless you have specific and proven use for denormalization.
"Sanjay Gangwal" <sgangwal@newbreed.com> wrote in message
news:a2f901c20c0e$64bb09d0$2ae
2c90a@hosting.microsoft.com...
> According to my understanding the Normal forms are
> incremental i.e. if table is in 3NF it has to be in 2NF
> and so on.
> But according to Transcender answer -- it said that --
> database does not satisfies 2NF but it is in 1NF and 3NF.
> so I was wondering what exactly is the understanding of
> the MICROSOFT about this Normalization definition ??
|
|
|
|
|