GATE | CS | 2011 | DBMS | Key concepts | Question 12

Last Updated :
Discuss
Comments

Consider a relational table with a single record for each registered student with the following attributes. 

1. Registration_Num: Unique registration number
   of each registered student
2. UID: Unique identity number, unique at the 
   national level for each citizen
3. BankAccount_Num: Unique account number at
   the bank. A student can have multiple accounts
   or join accounts. This attribute stores the 
   primary account number.
4. Name: Name of the student
5. Hostel_Room: Room number of the hostel

Which one of the following option is INCORRECT?

BankAccount_Num is candidate key

Registration_Num can be a primary key

UID is candidate key if all students are from the same country

If S is a superkey such that S∩UID is NULL then S∪UID is also a superkey

This question is part of this quiz :

GATE CS 2011,Database Design(Normal Forms)
Tags:
GATE
DBMS Quiz
Share your thoughts in the comments
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy