that all seems like a load of complicated jargon to me can anyone explain in simple terms

2NF Example:

Table(A, B, C) Primary Key(A, B), B->C.
Solution:
TableA(A, B) Primary Key (A, B)
TableB(B, C) Primary Key (B)

3NF Example:

TableA(A, B, C) Primary Key (A), A->B, B->C
Solution:
TableA(A, B) Primary Key (A)
TableB(B, C) Primary Key (B)

as i have said earlier in my posts i am a absolute begginer and i am doing this as a hobby kind of- i really don't know anything about database design really and just wanted someone to help me normalise my tables. so can people help me with that. i thought that if someone normalised my tables in stages it would make it easier for me to understand. can n e 1 do that for me

Okay, I made an example from one of your tables. It's not perfect. I don't understand vehicle reg.

What I did was apply the rules of Normalization. I did not apply so called "common sense". The normalization will ensure data integrity as each data value is in only one place. Very good for transactions, but having more tables could slow down your reporting.

thanks for that but i don't know where to go from there do i carry on normalising that table until 3rd normal form and then start on the others or do i start doing the other tables to 2nf.

can some one just do it for me and comment the different stages they went through.

by the way the viechel reg is the licence plate number which is a unique identifier for a car

I have just knocked something up quick, i havnt really looked at it in depth but this should be in or close to 3NF, if it isnt i apologise, but it may help you a bit.

Rob