What is a candidate key?Group of answer choicesA super key with no redundant attributes.A key that can have duplicate values.A key that is always used as a primary key.A key that contains a composite of two or more foreign keys.

Which is the best definition of a candidate key?Group of answer choicesA set of attributes for which no two tuples share all the same valuesA minimal set of attributes that uniquely identifies each tupleAn attribute that uniquely identifies each tuple

Which of the following statements is true?Group of answer choicesEvery super key is a candidate key.An alternate key is a super key with redundant attributes.A composite key cannot be a primary keyEvery candidate key is a super key.

What is a composite key?Group of answer choicesA key that consists of two or more attributes.A key that is used to enforce foreign key constraints.A key that can have NULL values.A key consisting of a single attribute.

What is the term for the candidate key other than the primary key in a relational database table

A set of one or more fields taken collectively to uniquely identify a record is called __________a.Candidate keyb.None of the answers are correctc.Super keyd.Primary Keye.Foreign keyClear my choice