DBMS Key

• Used to uniquely identify any row from the table.

• Used to establish relationship between tables.

Types of DBMS Key

Primary Key

• Used to identify a row uniquely in a table.

Foreign Key

• Foreign key is a column of the table which is pointing to the primary key of another table.

Super Key

• Super key is the set of one or more columns which can be used to uniquely identify a row in a table.

Candidate Key

• Candidate key is the minimal super key.

• It is the minimal combination of columns which can be used to identify each row in a table.