Database Fundamentals — Question 159

What is the relationship between the foreign key and primary key? Each correct answer represents a complete solution. (Choose all that apply.)

Answer options

• A. A foreign key constraint works in conjunction with a primary key constraint to enforce referential integrity among related entities.
• B. A foreign key ties attribute(s) of an entity to the primary key of another entity, for the purpose of creating a dependency.
• C. There is no relationship between a primary key and a foreign key.
• D. A foreign key and a primary key create a link between two entities.

Correct answer: A, B

Explanation

Options A and B are correct because they accurately describe how foreign keys and primary keys function together to maintain data integrity and establish dependencies between entities. Option C is incorrect as it denies any relationship, and option D, while partially true, does not fully encompass the nature of their relationship in terms of integrity and dependency.