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?
Answer: A. In the "books" table — 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…
- A.
In the "books" table
- B.
In the "authors" table
- C.
In both the tables
- D.
In a separate linking table
Attempted by 837 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.
Explore the full course: Iocl Engineers Officers Grade A Paper 2