1
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\}$$
2
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$$
3
GATE CSE 2005
+2
-0.6
The following table has two attributes $$A$$ and $$C$$ where $$A$$ is the primary key and $$C$$ is the foreign key referencing $$A$$ with on-delete cascade. The set of all tuples that must be additionally deleted to preserve referential integrity. When the tuple $$(2,4)$$ is deleted is:

A
$$(3,4)$$ and $$(6,4)$$
B
$$(5,2)$$ and $$(7,2)$$
C
$$(5, 2),$$ $$(7,2)$$ and $$(9,5)$$
D
$$(3, 4),(4,3)$$ and $$(6,4)$$
4
GATE CSE 2004
+2
-0.6
Consider the following entity relationship diagram $$(ERD),$$ where two entities $$E1$$ and $$E2$$ have a relation $$R$$ of cardinality $$1:m.$$ The attributes of $$E1$$ are $$A11, A12$$ and $$A13$$ where $$A11$$ is the key attribute. The attributes of $$E2$$ are $$A21, A22$$ and $$A23$$ where $$A21$$ is the key attribute and $$A23$$ is a multi-valued attribute. Relation $$R$$ does not have any attribute. A relational database containing minimum number of tables with each table satisfying the requirements of the third normal form $$(3NF)$$ is designed form the above $$ERD.$$ The minimum number of tables in the database is

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