Question

What do you understand by Candidate Keys in a table? Give a suitable example of Candidate Key from a table containing some meaningful data? ​

Answer 1

Answer:

Candidate Key - is a set of attributes that uniquely identify tuples in a table. Candidate Key is a super key with no repeated attributes. Alternate Key - is a column or group of columns in a table that uniquely identify every row in that table. Foreign Key - is a column that creates a relationship between two tables.

Give a suitable example of Candidate Key from a table containing some meaningful data?

• Cardinality = 4 Degree = 5.
• Cardinality = 7.
• Degree = 6.

❥Hope it helps you....