Before you get to far down the road it might be best for you to do some reading on database normalization. That will give you a great deal of help in designing your database.
An Introduction to Database Normalization
Also, you may find it easier to design if you use a development tool such as Mysql Workbench
. It's free.