The FOREIGN KEY constraint should be added to which table?

Question

BlackTom AI · Accepted Answer

The question asks where a FOREIGN KEY constraint should be added in a typical parent–child relationship.
Option A claims the constraint belongs to the parent table. In relational design, the parent table is the one referenced by the foreign key, not the table containing the foreign key itself, so this is incorrect.
Option B suggests adding a foreign key to a table without a primary key. A primary key is typically required (or a candidate key) to uniquely identify rows that can be referenced, and this option describes an illogical scenario, making it incorrect.
Option C states the constraint should be added to the child table in a parent–child relationship. This aligns with the standard design: the child table holds the foreign key that references the parent table’s primary key, establishing the link between the two tables. This is the correct reasoning for where the foreign key resides.
Option D says the constraint goes to the table representing the "one" side of a one-to-many relationship. While the "one" side participates in the relationship, the foreign key actually resides on the many side (the child table) to reference the one side; thus this option is imprecise and misleading, making it incorrect.

BU.330.770.T2.FA25 Quiz 2- Requires Respondus LockDown Browser

The FOREIGN KEY constraint should be added to which table?

查看解析

登录即可查看完整答案

类似问题

If a 1:M relationship is mandatory on both sides, which of the following is true?

Why is a foreign key important in relational databases?

Referential integrity is enforced using:

Which of the following is a characteristic of a foreign key?

A foreign key in one table must refer to:

Which of the following is NOT true about a foreign key that connects two tables in a database?

Which of the following is not a feature of a Foreign Key?

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单