Consider the following two relations, named Customer and Person, in a database:
\[
\text{Person} \left(
\begin{array}{l}
\text{aadhaar CHAR(12) PRIMARY KEY,} \\
\text{name VARCHAR (32);}
\end{array}
\right)
\]
\[
\text{Customer} \left(
\begin{array}{l}
\text{name VARCHAR (32),} \\
\text{email VARCHAR(32) PRIMARY KEY,} \\
\text{phone CHAR(10),} \\
\text{aadhaar CHAR(12),} \\
\text{FOREIGN KEY (aadhaar) REFERENCES Person (aadhaar);}
\end{array}
\right)
\]
Which of the following statements is/are correct?
\[ \text{Person} \left( \begin{array}{l} \text{aadhaar CHAR(12) PRIMARY KEY,} \\ \text{name VARCHAR (32);} \end{array} \right) \]
\[ \text{Customer} \left( \begin{array}{l} \text{name VARCHAR (32),} \\ \text{email VARCHAR(32) PRIMARY KEY,} \\ \text{phone CHAR(10),} \\ \text{aadhaar CHAR(12),} \\ \text{FOREIGN KEY (aadhaar) REFERENCES Person (aadhaar);} \end{array} \right) \]
Which of the following statements is/are correct?
Show Hint
- aadhaar is a candidate key in the Customer relation
- phone can be NULL in the Customer relation
- aadhaar is a candidate key in the Person relation
- aadhaar can be NULL in the Person relation
The Correct Option is B, C
Solution and Explanation
Statement (A): Is aadhaar a candidate key in the Customer relation?
The aadhaar field in the Customer relation is a foreign key referencing the Person relation's aadhaar field, and it is not guaranteed to be unique in the Customer relation. Therefore, aadhaar cannot be a candidate key in Customer because a candidate key must be unique for each record in that table.
Thus, Option (A) is incorrect.
Statement (B): Can phone be NULL in the Customer relation?
In the Customer relation, the phone field is not specified as NOT NULL. Therefore, phone can be NULL in the Customer relation, which is allowed as per the given schema.
Thus, Option (B) is correct: phone can be NULL in the Customer relation.
Statement (C): Is aadhaar a candidate key in the Person relation?
In the Person relation, aadhaar is defined as the PRIMARY KEY, which by definition must be unique for each record. Therefore, aadhaar is a candidate key in the Person relation.
Thus, Option (C) is correct: aadhaar is a candidate key in the Person relation.
Statement (D): Can aadhaar be NULL in the Person relation?
The aadhaar field in the Person relation is defined as the PRIMARY KEY, and primary keys cannot be NULL. Therefore, aadhaar cannot be NULL in the Person relation.
Thus, Option (D) is incorrect: aadhaar cannot be NULL in the Person relation.
Conclusion:
The correct answers are Option (B) and Option (C).
Top Questions on Database Management Systems
The first value in the output of a SQL query (given below) when run on a table having name “Table-1” is?
SQL Query: SELECT LastName FROM Table-1 WHERE State = "IN" ORDER BY FirstNameLastName FirstName StreetNumber StreetName City State Squires Edwin 4589 Shamar Rd. Upland IN Rothrock Paul 91657 Carex Ave. Upland IN Ramirez Douglas 123 Fake St. Springfield IN Peterson Chris 4687 Windthrow Way Kane PA Gibson David 354 Bluestem St. Carbondale IL - GATE GE - 2025
- Geographic Information System
- Database Management Systems
The table below is an attribute table about employee records. Which attribute can be used as a primary key?
Employee Name Designation Department (Emp_ID) (Emp_Name) (Emp_Desig) (Emp_Dept) 100260 Prashant Software Developer Information Technology 100265 Dinesh Junior Engineer Embedded System 100252 Somya HR Manager Management 100271 Dinesh Junior Engineer Information Technology - GATE GE - 2025
- Geographic Information System
- Database Management Systems
Consider the following database tables of a sports league. player (\( pid \), \( pname \), \( age \)) coach (\( cid \), \( cname \)) team (\( tid \), \( tname \), \( city \), \( cid \)) members (\( pid \), \( tid \)) An instance of the table and an SQL query are given.
Player table
coach table:
team table:
members table:
SQL query: \[ {SELECT MIN(P.age)} \] \[ {FROM player P} \] \[ {WHERE P.pid IN (} \] \[ { SELECT M.pid} \] \[ { FROM team T, coach C, members M} \] \[ { WHERE C.cname = 'Mark'} \] \[ { AND T.cid = C.cid} \] \[ { AND M.tid = T.tid)} \] The value returned by the given SQL query is _________. (Answer in integer)- GATE CS - 2025
- Computer Science and IT Engineering
- Database Management Systems
- Consider a relational schema team(name, city, owner), with functional dependencies \( \{ {name} \rightarrow {city}, {name} \rightarrow {owner} \} \). The relation team is decomposed into two relations, \( t_1({name}, {city}) \) and \( t_2({name}, {owner}) \). Which of the following statement(s) is/are TRUE?
- GATE CS - 2025
- Computer Science and IT Engineering
- Database Management Systems
A schedule of three database transactions \(T_1\), \(T_2\), and \(T_3\) is shown. \(R_i(A)\) and \(W_i(A)\) denote read and write of data item A by transaction \(T_i\), \(i = 1, 2, 3\). The transaction \(T_1\) aborts at the end. Which other transaction(s) will be required to be rolled back?
- GATE CS - 2025
- Computer Science and IT Engineering
- Database Management Systems
Questions Asked in GATE DA exam
- Given the equation: $$ 3^{x^2} = 27 \times 9^x $$ Find the value of: $$ \frac{2^{x^2}}{(2^x)^2} $$
- GATE DA - 2025
- Algebra
Consider a directed graph \( G = (V,E) \), where \( V = \{0,1,2,\dots,100\} \) and
\[ E = \{(i,j) : 0 < j - i \leq 2, \text{ for all } i,j \in V \}. \] Suppose the adjacency list of each vertex is in decreasing order of vertex number, and depth-first search (DFS) is performed at vertex 0. The number of vertices that will be discovered after vertex 50 is:- GATE DA - 2025
- Data Structures
- Consider the following pseudocode.
Create empty stack S Set x = 0, flag = 0, sum = 0 Push x onto S while (S is not empty){ if (flag equals 0){ Set x = x + 1 Push x onto S } if (x equals 8): Set flag = 1 if (flag equals 1){ x = Pop(S) if (x is odd): Pop(S) Set sum = sum + x } } Output sumThe value of \( sum \) output by a program executing the above pseudocode is:- GATE DA - 2025
- Data Structures
- Consider the following Python code snippet.
def f(a, b): if (a == 0): return b if (a % 2 == 1): return 2 * f((a - 1) / 2, b) return b + f(a - 1, b) print(f(15, 10))The value printed by the code snippet is 160 (Answer in integer).- GATE DA - 2025
- Recursion
Consider the following tables, Loan and Borrower, of a bank.
Query: \[ \pi_{\text{branch\_name}, \text{customer\_name}} (\text{Loan} \bowtie \text{Borrower}) \div \pi_{\text{branch\_name}}(\text{Loan}) \] where \( \bowtie \) denotes natural join. The number of tuples returned by the above relational algebra query is 1 (Answer in integer).- GATE DA - 2025
- Relational Algebra