1
GATE CSE 2018
+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$$?

A
Every entity in $$E1$$ is associated with exactly one entity in $$E2.$$
B
Some entity in $$E1$$ is associated with more than one entity in $$E2.$$
C
Every entity in $$E2$$ is associated with exactly one entity in $$E1.$$
D
Every entity in $$E2$$ is associated with at most one entity in $$E1.$$
2
GATE CSE 2008
+2
-0.6
Consider the following $$ER$$ diagram The minimum number of table needed to represent $$M,$$ $$N,$$ $$P, R1, R2$$ is

A
$$2$$
B
$$3$$
C
$$4$$
D
$$5$$
3
GATE CSE 2008
+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?

A
$$\left\{ {M1,\,M2,\,M3,\,P1} \right\}$$
B
$$\left\{ {M1,\,P1,\,N1,\,N2} \right\}$$
C
$$\left\{ {M1,\,P1,\,N1} \right\}$$
D
$$\left\{ {M1,\,P1} \right\}$$
4
GATE CSE 2005
+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?
A
$$2$$
B
$$3$$
C
$$4$$
D
$$5$$
GATE CSE Subjects
Discrete Mathematics
Programming Languages
Theory of Computation
Operating Systems
Digital Logic
Computer Organization
Database Management System
Data Structures
Computer Networks
Algorithms
Compiler Design
Software Engineering
Web Technologies
General Aptitude
EXAM MAP
Joint Entrance Examination