Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 36 of 41

Relational Database and SQL — Question 36

Back to all questions
36
Question

Question 29(a)

What is the difference between Candidate key and Alternate key?

Answer
Alternate KeyCandidate Key
A candidate key refers to all the attributes in a relation that are candidates or are capable of becoming a primary key.Any attribute which is capable of becoming a primary key but is not a primary key is called an alternate key.
Get the Bright Tutorials app Stuck on a question? Ask Bright Buddy — your AI tutor — for step-by-step help in the app.