A relation STUDENT has attributes $SID$, $Name$, $Email$ and $Phone$. The following uniqueness constraints are given: each $SID$ is unique and each $Email$ is unique. Identify all candidate keys and state which attribute is normally chosen as the primary key.

Question

Accepted Answer

SID (candidate keys: SID, Email)

Neco 2019 Data Processing Question 13

A relation STUDENT has attributes \(SID\), \(Name\), \(Email\) and \(Phone\). The following uniqueness constraints are given: each \(SID\) is unique and each \(Email\) is unique. Identify all candidate keys and state which attribute is normally chosen as the primary key.

Answer Options

About This Question

Master the Exam!