explain the concept of foreign key. Hoe is it different from candidate key?
Answers
Answered by
11
- Candidate Key - The candidate keys in a table are defined as the set of keys that is minimal and can uniquely identify any data row in the table. Foreign Key - A foreign key is an attribute value in a table that acts as the primary key in another table. Hence, the foreign key is useful in linking together two tables.
Answered by
0
Answer:
The candidate keys in a table are defined as the set of keys that is minimal and can uniquely identify any data row in the table. ... Foreign Key - A foreign key is an attribute value in a table that acts as the primary key in another table. Hence, the foreign key is useful in linking together two tables
Similar questions