Normalisation

Hi i am trying to normalise a report. I am have trouble converting from 1NF
to 2NF. All the fields in UNF are repeated data, therefore all go to 1NF,
but they are all under 1 Primary Key. So they should go straight to 2NF
because there is no compound key?

Would i have to seperate them when going to 3NF? if so, i know that i would
need more table than the ones produced if i go through the above route.

How do you go about this?

Also, in UNF do i list all the fields on the report or can i list all the
fields plus more which is either required but not stated on the report or add
a few fields to make it understabdable, e.g.
Subject ID, Topic ID...
If this was the case, i could create a partial key?

Any help would be most greatful!

I don't work with people's interpretations of 1NF or whatever. If you
provide some table structures, primary and foreign keys, and sample data, I
might be able to help.

--
Duane Hookom
MS Access MVP


"kmistry" wrote in message
...
Hi i am trying to normalise a report. I am have trouble converting from
1NF
to 2NF. All the fields in UNF are repeated data, therefore all go to 1NF,
but they are all under 1 Primary Key. So they should go straight to 2NF
because there is no compound key?

Would i have to seperate them when going to 3NF? if so, i know that i
would
need more table than the ones produced if i go through the above route.

How do you go about this?

Also, in UNF do i list all the fields on the report or can i list all the
fields plus more which is either required but not stated on the report or
add
a few fields to make it understabdable, e.g.
Subject ID, Topic ID...
If this was the case, i could create a partial key?

Any help would be most greatful!