A foreign key is a column or columns of data in one table that refers to the unique data values -- often the primary key data -- in another table.
Explanation:
In simpler words, a foreign key is a set of attributes that references a candidate key. For example, a table called TEAM may have an attribute, MEMBER_NAME, which is a foreign key referencing a candidate key, PERSON_NAME, in the PERSON table...
Answers & Comments
Answer:
A foreign key is a column or columns of data in one table that refers to the unique data values -- often the primary key data -- in another table.
Explanation:
In simpler words, a foreign key is a set of attributes that references a candidate key. For example, a table called TEAM may have an attribute, MEMBER_NAME, which is a foreign key referencing a candidate key, PERSON_NAME, in the PERSON table...
Take care