Question:
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?
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
In a relational database, a primary key must always be unique and cannot be NULL. A foreign key is used to establish a link between two tables but may not be unique in the table that contains it.
Updated On: Feb 3, 2026
- 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
Hide Solution
Verified By Collegedunia
The Correct Option is B, C
Solution and Explanation
Let's go through each of the statements:
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).
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).
Was this answer helpful?
0
0
Top Questions on Database Management Systems
- In SQL, which clause is used to filter the results of an aggregate function?
- CUET (PG) - 2026
- Data Science
- Database Management Systems
- Define the term data independence. What are the different levels of data independence?
- Kerala Plus Two(Class 12) - 2026
- Computer Science
- Database Management Systems
- Describe the use of built-in MySQL functions like COUNT(), SUM(), and MAX().
- PSEB XII - 2026
- Computer Applications
- Database Management Systems
- Explain the concepts of Primary Key, Foreign Key, and Candidate Key.
- PSEB XII - 2026
- Computer Applications
- Database Management Systems
- Write the syntax and use of SQL DDL commands (CREATE, ALTER, DROP) and DML commands (INSERT, UPDATE, DELETE).
- PSEB XII - 2026
- Computer Applications
- Database Management Systems
View More Questions
Questions Asked in GATE DA exam
- Rishi and Swathi are students of Class 5. Pavan and Tanvi are students of Class 4. Rishi and Pavan are boys. Swathi and Tanvi are girls. These four students played a total of three games of chess. The games were played one after another. A player who lost a game did not participate in any more games. It was observed that:
1. The first game was the only game where two students of the same class played against each other.
2. The students of Class 5 won more games than the students of Class 4.
3. The boys won 2 games and the girl won 1 game.
The student who did not lose any game is:- GATE DA - 2026
- Logical Reasoning
Consider two distinct positive numbers \( m, n \) with \( m > n \). Let \[ x = n^{\log_n m}, \quad y = m^{\log_m n}. \] The relation between \( x \) and \( y \) is -
- GATE DA - 2026
- Logarithms
- Consider the supervised learning task. The objective function being minimized is \( f(w) = w \cdot x \), where \( w \in \mathbb{R} \) is the parameter. Stochastic Gradient Descent with learning rate of 0.10. Let \( w = 10.00 \) be the \( i^{\text{th}} \) iteration (\( w_i \)). The value of \( w \) at the end of iteration \( (i+1) \) is if \( x = 10 \) ________. Round off 2 decimal.
- GATE DA - 2026
- Machine Learning
- The value of \[ \sum_{j=0}^{\infty} \sum_{i=1}^{\infty} 2^{-j} 3^{-i} \] is ________.
- GATE DA - 2026
- Sequences and Series
- Consider the Ridge LRR is being used to learn prediction function \( y_{\text{pred}} = w^T x \) where \( w, x \in \mathbb{R}^2 \) & mean absolute error (MAE) is used to measure the prediction error. A weight of 0.20 is associated with the regularizer. At an intermediate step of training process assume that the parameter \( w = [-3.00, 4.00]^T \). In the next step for the I/P \( x = [1.00, 2.00]^T \), the predicted value of \( y \) is noted. Let the relation b/w \( x = [x_1, x_2]^T \) & the true value of \( y \) be \( y_{\text{true}} = x_1 + x_2 \). The value of the overall regularized loss for instance is __________ (upto 2 decimal).
- GATE DA - 2026
- Machine Learning
View More Questions