I have been reading up on database normalisation and just need someone to check my table structure to see if i understood what i read properly.

I have attached an image of my tables which i think is right but would like an expert to see if ive done it right or tell me where i am going wrong

Thanks in advance for your time and help

Gareth

I would probably structure you tables a little differently per the attached.

You might also find the sample here (http://www.access-programmers.co.uk/forums/showthread.php?t=200641) of interest when you are setting up your addresses.

Thanks for the info John.

I have attached an updated pic with the changes(ish) that you have suggested i think. If you dont mind can you take a look and see if it is more normalised than it was before.

Thanks
Gareth


P.S I think i understand normalisation but i struggle to implement it into my own database ideas.

Ok i have typed out all the tables i think i need and think i have normalised them but am a little unsure if they are fully normalised could someone just take a quick look and tell me if they are or not.

I have uploaded the screenshots.

I would also like to know if they are normalised to first,second or third normal form(hopefully third)

Thanks in advance

Gareth