First, you need to list each of the different types of data you need to store in the database. That will determine the required fields. Then you need to normalize that to work out how many tables you need and their relationships.
Do a google search for "database normalization tutorial". Here are a couple links for tutorials.