Database Management System
Er Diagrams
Marks 1Marks 2
Functional Dependencies and Normalization
Marks 1Marks 2
Structured Query Language
Marks 1Marks 2
Relational Algebra
Marks 1Marks 2
Transactions and Concurrency
Marks 1Marks 2
File Structures and Indexing
Marks 1Marks 2
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$$?

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
MCQ (Single Correct Answer)
+2
-0.6
Consider the following $$ER$$ diagram GATE CSE 2008 Database Management System - Er Diagrams Question 11 English

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
MCQ (Single Correct Answer)
+2
-0.6
Consider the following $$ER$$ diagram GATE CSE 2008 Database Management System - Er Diagrams Question 10 English

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
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?
A
$$2$$
B
$$3$$
C
$$4$$
D
$$5$$
GATE CSE Subjects
Theory of Computation
Operating Systems
Algorithms
Digital Logic
Database Management System
Data Structures
Computer Networks
Software Engineering
Compiler Design
Web Technologies
General Aptitude
Discrete Mathematics
Programming Languages
Computer Organization