Machine-translated by Google. Questions are authored in English.
Top

Discussion

In a 1:N relationship, the foreign key is placed in:

  • A.either table without specifying parent and child tables.
  • B.the parent table.
  • C.the child table.
  • D.either the parent table or the child table.

Answer: C

Correct answer: the child table.

The foreign key always goes on the many side. Each child row points to one parent, so a single foreign key column suffices; putting it in the parent would require room for an unknown number of child references in one row, which a relation cannot provide. That asymmetry is what makes parent and child meaningful in a 1:N relationship.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.