Question

Explain the concept of “Alternate Key” in a Relational Database Management System with an appropriate example.

Answer 1

Alternate keys refer to all candidate keys that are not primary keys.

Example: Consider the table student as per the following structure:

Table: Student
Roll	Name	Phone	Aadhar	Marks

In the student table:
Candidate keys: Roll, Phone, Aadhar
If the Primary key is: Roll
Alternate keys: Aadhar, Phone