Assume a one-to-many relationship from table named "authors" to the table…
2025
Assume a one-to-many relationship from table named "authors" to the table named "books". Where should the foreign key reside in an optimal design for this relationship?
- A.
In the "books" table
- B.
In the "authors" table
- C.
In both the tables
- D.
In a separate linking table
Attempted by 481 students.
Show answer & explanation
Correct answer: A
In a one-to-many relationship between two tables, the foreign key must be placed in the table representing the many side of the relationship. Since one author can write multiple books, the books table is on the many side and requires a foreign key referencing the author.