Let S be the specification: "Instructors teach courses. Students register for courses. Courses are allocated classrooms. Instructors guide students." Which one of the following ER diagrams (see figure) CORRECTLY represents S?

Figure for GATE CSE 2024 | Set 1 | Question 20

Single correct

Source: GATE CSE 2024 Set 1 (CS1), IISc Bengaluru. Official question paper.

GATE CSE 2024 | Set 2 | Question 20

ER Model

MCQ1 mark

In the context of owner and weak entity sets in the ER (Entity-Relationship) data model, which one of the following statements is TRUE?

Single correct

Source: GATE CSE 2024 Set 2 (CS2), IISc Bengaluru. Official question paper.

GATE CSE 2021 | Set 2 | Question 6

ER Model

MCQ1 mark

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 2020 | Question 14

ER Model

MCQ1 mark

Which one of the following is used to represent the supporting many-one relationships of a weak entity set in an entity-relationship diagram?

Single correct

Answer key coming soon

Source: GATE CSE 2020, IIT Delhi. Official question paper.

GATE CSE 2018 | Question 11

ER Model

MCQ1 mark

In an Entity-Relationship (ER) model, suppose

R

is a many-to-one relationship from entity set E1 to entity set E2. Assume that E1 and E2 participate totally in

R

and that the cardinality of E1 is greater than the cardinality of E2. Which one of the following is true about

R

Single correct

Source: GATE CSE 2018, IIT Guwahati. Official question paper and answer key.

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 2015 | Set 1 | Question 48

ER Model

NAT2 marks

Consider an Entity-Relationship (ER) model in which entity sets

E_1

and

E_2

are connected by an

m:n

relationship

R_{12}

E_1

and

E_3

are connected by a

1:n

(1 on the side of

E_1

and

n

on the side of

E_3

) relationship

R_{13}

E_1

has two single-valued attributes

a_{11}

and

a_{12}

of which

a_{11}

is the key attribute.

E_2

has two single-valued attributes

a_{21}

and

a_{22}

of which

a_{21}

is the key attribute.

E_3

has two single-valued attributes

a_{31}

and

a_{32}

of which

a_{31}

is the key attribute. The relationships do not have any attributes. If a relational model is derived from the above ER model, then the minimum number of relations that would be generated if all the relations are in 3NF is _____.

Numerical answer

Your answer

Source: GATE CSE 2015 Set 1, IIT Kanpur. Official question paper and answer key.

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.

GATE CSE 2012 | Question 14

ER Model

MCQ1 mark

Given the basic ER and relational models, which of the following is INCORRECT?

Single correct

Answer key coming soon

Source: GATE CSE 2012. Official question paper (booklet code A).

Use ← → to move

Questions

9 total

Correct Wrong Answer seen

Sort

Filters

Year

Set

Marks

Marks

Question type

Question type