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

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

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

You want all the users inputing the phone number field of Employee table in the format of (999)999-9999. Which of the following data validation will you use?Group of answer choicesInput MaskFace MaskFormattingDefault Value

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