Database Normalisation (Again)

[Gazza2]

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

 

[John Big Booty]

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

You might also find the sample here of interest when you are setting up your addresses.

 

[Gazza2]

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.

 

[Gazza2]

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