why not 18?

The Gateway to Computer Science Excellence

First time here? Checkout the FAQ!

x

+18 votes

Given an instance of the STUDENTS relation as shown as below

$$\begin{array}{|c|c|c|c|c|} \hline \textbf {StudentID} & \textbf{StudentName} & \textbf{StudentEmail} & \textbf{StudentAge} & \textbf{CPI} \\\hline \text{2345} & \text{Shankar} & \text{[email protected]} & \text{X} & \text{9.4}\\\hline\text{1287} & \text{Swati} & \text{[email protected]} & \text{19} & \text{9.5}\\\hline\text{7853} & \text{Shankar} & \text{[email protected]} & \text{19} & \text{9.4} \\\hline \text{9876} & \text{Swati} & \text{[email protected]} & \text{18} & \text{9.3} \\\hline \text{8765} & \text{Ganesh} & \text{[email protected]} & \text{19} & \text{8.7} \\\hline \end{array}$$

For $(\text{StudentName, StudentAge})$ to be a key for this instance, the value $X$ should NOT be equal to______.

$$\begin{array}{|c|c|c|c|c|} \hline \textbf {StudentID} & \textbf{StudentName} & \textbf{StudentEmail} & \textbf{StudentAge} & \textbf{CPI} \\\hline \text{2345} & \text{Shankar} & \text{[email protected]} & \text{X} & \text{9.4}\\\hline\text{1287} & \text{Swati} & \text{[email protected]} & \text{19} & \text{9.5}\\\hline\text{7853} & \text{Shankar} & \text{[email protected]} & \text{19} & \text{9.4} \\\hline \text{9876} & \text{Swati} & \text{[email protected]} & \text{18} & \text{9.3} \\\hline \text{8765} & \text{Ganesh} & \text{[email protected]} & \text{19} & \text{8.7} \\\hline \end{array}$$

For $(\text{StudentName, StudentAge})$ to be a key for this instance, the value $X$ should NOT be equal to______.

- All categories
- General Aptitude 1.6k
- Engineering Mathematics 7.3k
- Digital Logic 2.9k
- Programming & DS 4.9k
- Algorithms 4.3k
- Theory of Computation 6k
- Compiler Design 2k
- Databases 4.1k
- CO & Architecture 3.4k
- Computer Networks 4.2k
- Non GATE 1.4k
- Others 1.5k
- Admissions 590
- Exam Queries 575
- Tier 1 Placement Questions 23
- Job Queries 72
- Projects 18

49,397 questions

53,563 answers

185,728 comments

70,838 users