- Now create another table for the borrowers
- Then create a third table for loans, this table will link the borrowers to the books
- Your diagram should look something like this
Don't worry if your tables aren't laid out exactly like this, the exact layout isn't important, as long as you can see all of the tables easily. Remember that you can drag the tables around by the colored titlebar if you want to rearrange them.