Before yopu do anything, you need to look at the various bits of information you need to store and decide what tables you need, what the relationships between them are going to be, and then what fields and field types you need.
We can't do that for you - it's your homework after all - so it's best you start reading:
MSDN[
^] is always a good place to start, then Google for "Database planning" and see what you get.