441,912 views
11 votes
11 votes
Give Seven characteristics of a candidate key.

User Qutax
by
2.9k points

1 Answer

25 votes
25 votes

Answer: A candidate key is a key selected from the set of super keys.

Generally, a candidate key does not have null or empty values and consists of one or many attributes.

According to the above-mentioned student table, the id and phone do not have any redundant attributes.

A candidate key does not have null or empty values and consists of one or many attributes.

There can be more than one candidate keys for a table.

A candidate does not have any redundant attributes.

A candidate key is a super key with no redundant attributes.

Explanation:I hope this helps

User Tolik Kukul
by
2.9k points