well, first off, you should become familiar with the concept of nested recordsets. for more details on the nested recordset concept see the following tutorial:
for creating the tables,, you will need to use PHPMyAdmin or another MySQL GUI. through google i found a few youtube videos that go over creating tables like this one:
there are many others.