A key is a unique identifier that is used to establish and identify relationships between tables and also to uniquely identify any record or row of data in a table.
Why do we need a Key?
Types of keys:
There are different types of keys which are listed below:
- Super key
- Candidate key
- Primary key
- Composite key
- Foreign key
- Alternate key
- Compound key
- Surrogate key
