1

GATE CSE 2018

MCQ (Single Correct Answer)

+2

-0.6

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$$?

2

GATE CSE 2008

MCQ (Single Correct Answer)

+2

-0.6

Consider the following $$ER$$ diagram

The minimum number of table needed to represent $$M,$$ $$N,$$ $$P, R1, R2$$ is

3

GATE CSE 2008

MCQ (Single Correct Answer)

+2

-0.6

Consider the following $$ER$$ diagram

Which of the following is a correct attribute set for one of the tables for the correct answer to the above question?

4

GATE CSE 2005

MCQ (Single Correct Answer)

+2

-0.6

Let $${E_1}$$ and $${E_2}$$ be two entities in an

**E-R**diagram with simple single-valued attributes, $${E_1}$$ and $${E_2}$$ are two relationships between $${E_1}$$ and $${E_2}$$, Where $${E_1}$$ is one-to-many and $${E_2}$$ is many-to-many. $${E_1}$$ and $${E_2}$$ do not have any attributes of their own. What is the minimum number of tables required represent this situation in the relation model?Questions Asked from Er Diagrams (Marks 2)

Number in Brackets after Paper Indicates No. of Questions

GATE CSE Subjects

Theory of Computation

Operating Systems

Algorithms

Database Management System

Data Structures

Computer Networks

Software Engineering

Compiler Design

Web Technologies

General Aptitude

Discrete Mathematics

Programming Languages