Question 4Tips1 ptsIn 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 table Employee with columns EmployeeID, Email, and PhoneNumber, which of the following could be considered a candidate key?

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

Question 8In the following student table, which attribute could be used as a primary key?Student first nameStudent last nameMobile numberCarl Merlo07445532123MarkNero074565323271 pointStudent last nameMobile numberStudent first name

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

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.