In a relational model,when a primary key for one table appears in another table,it is called a _____ key.
A) secondary
B) foreign
C) surrogate
D) domain

Question

Quizplus · Accepted Answer

When a primary key from one table appears in another table, it is known as a foreign key. The foreign key is used to establish a relationship between the two tables, allowing data to be accessed and modified across the tables based on the primary-foreign relationship. Options A, C, and D are not correct as they do not accurately describe the relationship between tables that is established by a foreign key.

In a Relational Model,when a Primary Key for One Table