Q12

MCQ1 mark, −0.33

Consider a relational table with a single record for each registered student with the following attributes: Which of the following options is INCORRECT? $\text {BankAccount_Num}$ is a candidate key $\text {Registration_Num}$ can be a primary key $\text {UID}$ is a candidate key if all students are from the same country If $S$ is a super key such that $S \cap \text{UID}$ is $\text{NULL}$ then $S \cup \text{UID}$ is also a superkey

(A)

$\text {Registration_Num:}$ Unique registration number for each registered student

(B)

$\text {UID:}$ Unique identity number, unique at the national level for each citizen

(C)

$\text {BankAccount_Num:}$ Unique account number at the bank. A student can have multiple accounts or joint accounts. This attribute stores the primary account number.

(D)

$\text {Name:}$ Name of the student

(E)

$\text {Hostel_Room:}$ Room number of the hostel

Loading…