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. Bank Account_Num: Unique account number at the bank. A student can have multiple accounts or joint accounts. This attribute stores the primary account number.
4. Name: Name of the student
5. Hostel_Room: Room number of the hostel
Which of the following options is INCORRECT?
1. Bank Account_Num is a candidate key
2. Registration_Num can be a primary key
3. UID is a candidate key if all students are from the same country
4. If S is a superkey such that S∩UID is NULL then S∪UID is also a superkey
WebSite: www.EasyExamNotes.com
Our FB page: / easyexamnotesdotcom
Lectures Library:
1) Analysis & Design of Algorithm: • Video
2) Data Structure Lectures: • Video
3) Computer Organization Architecture: • Computer Organization ...
4) Operating System Lectures: • Fragmentation (Hindi) ...
5) Theory Of Computation Lectures: • Lec-4 Draw a DFA acce...
6) DBMS Lectures: • RDBMS (Hindi) | Jayesh...
7) Principles Of Programming Languages: • Language Evaluation Cr...
8) Internet Of Things: • IOT Conceptual Framewo...
9) Discrete Structures: • Prove set G= {1, 2, 3,...
10) Cloud Computing Lectures: • RAID-Redundant Array o...
11) Software Engineering: • RAD model | SDLC | Jay...
12) Digital Circuits: • Half Adder | Jayesh Umre
13) Number System: • 10's Complement | Jaye...
14) GATE Mathematics: • GATE | Adjoint of a Ma...
15) Management Information System: • MIS in Hindi
16) Computer Network: • Computer Networks in H...
====================================================
18 сен 2024
