The two tables remain unrelated because their key columns have different names.

Many book rows may reference the same author row, while each stored author_id identifies one author.

The authors table stores a foreign key to every book_id.

Each book row automatically references every author row.