Explanation of foreign key relationship

Question

Give a brief explanation of foreign key relationship.

Answer 1

Relationships which can be described between tables and should be explicitly stated at field level foreign keys are employed to make sure the consistency of the data. Data entered must be checked against existing data to make sure that there are now contradictions. While describing foreign key relationship cardinality has to be particular. Cardinality mentions how numerous dependent records or how referenced records are probable.