A database designer wants to create three tables: Supplier, Product, and Country. The Supplier table has a CountryID column with values that must appear in the Country table's CountryID column. The Product table has a ProductID column. Which table's CREATE TABLE statement(s) must specify a FOREIGN KEY?

Question

BlackTom AI · Accepted Answer

The scenario describes three tables: Supplier, Product, and Country. The constraint given is that the Supplier table has a CountryID column whose values must appear in the Country table's CountryID column, i.e., a referential integrity requirement. This establishes a relationship where Supplier references Country.

Option considerations:
- If a column in one table must match values in another table, the typical way to enforce this is to declare a FOREIGN KEY on the referencing column that points to the referenced table's primary (or candidate) key. In this case, the referring column is Supplier.CountryID and the referenced column is Country.CountryID. Therefore, the FOREIGN KEY constraint belongs on the Supplier table, linking Supplier.CountryID to Country.CountryID. This ensures that any CountryID placed in Supplier must exist in Country, enforcing the stated rule.
- The Product table has a ProductID column, which by itself is not described as referencing any other table. A FOREIGN KEY is only needed here if ProductID were intended to reference another table’s key (which is not indicated). Since the described requirement concerns Supplier.CountryID referencing Country.CountryID, Product does not require a FOREIGN KEY for this constraint.
- In general, FOREIGN KEY declarations are added to the table that contains the column performing the reference (the child or dependent table). Here, that is the Supplier table with its CountryID column referencing Country.

Therefore, the table that must specify a FOREIGN KEY is the one that contains the referencing column (Supplier.CountryID), ensuring the values exist in the Country table.

CSE 3241 SU2025 (7028) Week 3 Quiz

查看解析

登录即可查看完整答案

类似问题

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搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单