What's the best/proper way to set up my database : <p>I have a database, image below, and I feel that there must be an efficient way to add separate books for each child. For example... there may be 50 clubbers in the database. Each clubber will be in their own book and to make it simple, each book has 10 sections a clubber must complete. I was thinking of making a table for each child with the 10 sections, but that would end up with over 50 tables in my database. I also thought of creating a table called book and just having that table contain the 10 sections, but the problem with that is each child may be in one of 8 different books. So one table called book wouldn't work either. </p>

<p>Does anyone have a good suggestion on how to set this up in the database? My ultimate goal is to have each child linked to one of the 8 books that is available. Then the database will track which section each child is in for their certain book. So... today clubber A could finish section 1 and 2 in book 1, but clubber B might only finish section 1 in book 2. I'm wanting to pull this information from the database to see where each clubber is in their books... but... I first need to set the database up correctly.</p>

<p>Should I create 8 separate tables for each of the books and have the table data be section 1... section 2...? Or should I create one table and list 8 books in it and then link that to another table that has the section info? Or is there an even better way?</p>

<p>Thanks for any help<img src="https://i.stack.imgur.com/oem72.jpg" alt="![mydatabase"> </p>
