ALL GATE QUESTIONS SUBJECTWISE
×

ER Diagrams

1 Mark Questions 2 Marks Questions

Functional Dependencies and Normalization

1 Mark Questions 2 Marks Questions

SQL 

1 Mark Questions 2 Marks Questions

Relational Algebra and Relational Calculus

1 Mark Questions 2 Marks Questions

Transactions and Concurrency Control

1 Mark Questions 2 Marks Questions

File Structures  and Indexing

1 Mark Questions 2 Marks Questions



GATE 2005 1st Question - Marks 2

Let E1 and E2 be two entities in an E-R diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?
(A) 2
(B) 3
(C) 4
(D) 5


Total 5 Questions



Share: