Normalization to 3NF

[Kurt Nesworthy]

trying to understand how to do Normalization to 3NF. applying for a job, which involves having to do this. i have all the other requirements for the job are covered, just this is very new to me and is getting me confused.

we are to be tested in the interview in 4 weeks, and have been given some practice ones to try and do.

I understand how to get to 1NF, by putting extra lines in, so there are no duplicate entrys and only 1 piece of data in a cell. but how would i get this into 2NF and then 3NF ????



much appricated if somebody could help me

[r035198x]

trying to understand how to do Normalization to 3NF. applying for a job, which involves having to do this. i have all the other requirements for the job are covered, just this is very new to me and is getting me confused.

we are to be tested in the interview in 4 weeks, and have been given some practice ones to try and do.

I understand how to get to 1NF, by putting extra lines in, so there are no duplicate entrys and only 1 piece of data in a cell. but how would i get this into 2NF and then 3NF ????



much appricated if somebody could help me

Have a read at this thread and then give it a try.

[MMcCarthy]

Have a read at this thread and then give it a try.

There is also another thread here that give you comprehensive instructions.

Mary

[micksitup]

if you need any further instructions email me at [email removed]