Explain super key, candidate key, primary key, composite key, foreign key, surrogate key, and natural key.

Answer preview

A key is a column or set of columns used to identify rows or to link tables. Identification keys form a hierarchy — every primary key is a candidate key, and every candidate key is a super key — while foreign keys exist to connect relations rather than to identify rows.…