Here is where you really ought to read a good book on database design and normalisation. Not everyone can cope with that so here is a more practical alternative. Normalisation isn't as essential as most academic books say but it is vital to understand it if you want your databases to work. Otherwise how will you understand when it is safe to break the rules?
These linked pages are a practical exercise which uses primary keys, normalisation and cascading.
