196k views
1 vote
Give Seven characteristics of a candidate key.

1 Answer

4 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 Nacorid
by
4.9k points