The next step is to link the tables together with foreign key relationships.
- Look for the tables books and loans. Move them until they are both visible and do not overlap.
- Using the mouse drag from the book_id field in the loans table to the book_id in the books table. As soon as you start dragging a line will appear.
- When you reach the books table release the mouse. The line should remain visible between the two fields
- If the line disappears when you release the mouse, try again and make sure you don't release the mouse until you pointer is directly over the target field
- 5 You should see a icon F appear on the loans(book_id) field. This indicates that it is a foreign key and references another field elsewhere.
- Next make a foreign key relationship between loans(borrow_id) and
borrower(borrower_id)
Your diagram should now look like this: