A relationship which can be defined between tables and
must be explicitly defined at field level. Foreign keys are used to ensure the consistency of data. Data
entered should be checked against existing data to ensure that there are now contradiction. While
defining foreign key relationship cardinality has to be specified. Cardinality mentions how many
dependent records or how referenced records are possible.