Question

Define Alternate key

​

Answer 1

Explanation:

Alternate Key or Secondary Key is the key that has not been selected to be the primary key, but are candidate keys. ... A candidate key not selected as a primary key is called alternate or secondary key. Candidate key is an attribute or set of attributes that you can consider as a Primary key.

Answer 2

Answer :-

Alternate Key :-

• Alternate key is a secondary key it can be simple to understand by an example:-

• Let's take an example of student it can contain NAME, ROLL NO., ID and CLASS.

• Here ROLL NO. is primary key and rest of all columns like NAME, ID and CLASS are alternate keys.

• An alternate key is a key associated with one or more columns whose values uniquely identify every row in the table, but which is not the primary key. For example, where the primary key for a table may be the employee id, the alternate key might combine the first, middle, and last names of the employee .

✌️✌️✌️✌️