Lance needs to setup a relationship between two tables in the relational database he is working in. Which of the following best describes what does Lance need to create?
A.
Primary key
B.
Relation key
C.
Foreign key
D.
SQL key
Explanation:
If an attribute in one table has a value matching the primary key inanother table and there is a relationship set up between the two of them, thisattribute is considered a foreign key. This foreign key is not necessarily the primary key in its current table. It only has to contain the same information thatis held in another table’s primary key and be mapped to the primary key in this other table.