Consider the following statements S1 and S2 about the relational data model: S1: A relation scheme can have at most one foreign key. S2: A foreign key in a relation scheme R cannot be used to refer to tuples of R. Which one of the following choices is correct?

Single correct

Answer key coming soon

Source: GATE CSE 2021 Set 2 (CS2), IIT Bombay. Official question paper.

GATE CSE 2017 | Set 2 | Question 17

ER Model

MCQ1 mark

An ER model of a database consists of entity types A and B. These are connected by a relationship R which does not have its own attribute. Under which one of the following conditions, can the relational table for R be merged with that of A?

Single correct

Answer key coming soon

Source: GATE CSE 2017 Set 2, IIT Roorkee. Official question paper.

GATE CSE 2014 | Set 2 | Question 22

ER Model

NAT1 mark

Given an instance of the STUDENTS relation as shown below:

\begin{array}{|l|l|l|c|c|} \hline \textbf{StudentID} & \textbf{StudentName} & \textbf{StudentEmail} & \textbf{StudentAge} & \textbf{CPI} \\ \hline 2345 & \text{Shankar} & \text{shankar@math} & X & 9.4 \\ 1287 & \text{Swati} & \text{swati@ee} & 19 & 9.5 \\ 7853 & \text{Shankar} & \text{shankar@cse} & 19 & 9.4 \\ 9876 & \text{Swati} & \text{swati@mech} & 18 & 9.3 \\ 8765 & \text{Ganesh} & \text{ganesh@civil} & 19 & 8.7 \\ \hline \end{array}

For (StudentName, StudentAge) to be a key for this instance, the value X should NOT be equal to _____.

Numerical answer

Your answer

Source: GATE CSE 2014 Set 2, IIT Kharagpur. Official question paper and answer key.

Use ← → to move

Questions

4 total

Correct Wrong Answer seen

Sort

FiltersClear all

Year

Set

Marks

Marks

Question type

Question type