If StudentID and Email are candidate keys for the Student table, and StudentID is chosen as the primary key, what is Email considered?Group of answer choicesComposite KeyPrimary KeyForeign KeyAlternate Key

In a table Employee with columns EmployeeID, Email, and PhoneNumber, which of the following could be considered a candidate key?Group of answer choicesEmployeeIDPhoneNumberAll of the aboveEmail

In a Students table with columns StudentID, FirstName, LastName, and Email, which combination of columns can be considered a super key?Group of answer choicesEmailStudentIDStudentID, FirstNameAll of the above

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.

In a Books table with columns BookID, ISBN, and Title, which of the following sets of columns can be considered a candidate key?Group of answer choicesTitleISBNBookIDBookID and ISBN

When a foreign key in one table is referenced in another table, then in the secondary table, that column is referred to as a primary key.Group of answer choicesTrueFalse