Sounds like you are trying to learn about Database normalization... That is a difficult thing to learn (definitely harder to grasp than actual coding)
Here is a link to a tutorial that can be helpful.
Database Normalization Tutorial
From what I can tell with your data, you don't have too much to normalize, but this will definitely help a bunch...
Good luck with this.