Skip to content
Related Articles

Related Articles

GATE | Quiz for Sudo GATE 2021 | Question 4
  • Last Updated : 14 Dec, 2020

Consider the following statements regarding minimum number of table required in relational algebra for converting ER diagram with cardinality and participation.

1. If there are only Partial participations:

  • One-One: 2 Tables, Merge Relation to any of the side.
  • Many-One or One-Many: 2 Tables, Merge Relation to Many side.
  • Many-Many: 3 tables (separate table for relation)

2. Any one of the side has full participation:

  • Full participation on Many Side: 2 Tables
  • Full Participation on one side: 1 Table

3. Both Side full participations:

  • Always one table irrespective of Cardinality.

Note – This question is multiple select questions (MSQ).
(A) Statement 1 is correct
(B) Statement 2 is correct
(C) Statement 3 is correct
(D) All 1, 2, and 3 are false.


Answer: (A) (B) (C)

Explanation: According to minimization of ER diagram, and participation and cardinalities of given relations.



1. If there are only Partial participations:

  • One-One: 2 Tables, Merge Relation to any of the side.
  • Many-One or One-Many: 2 Tables, Merge Relation to Many side.
  • Many-Many: 3 tables (separate table for relation)

2. Any one of the side has full participation:

  • Full participation on Many Side: 2 Tables
  • Full Participation on one side: 1 Table

3. Both Side full participations:

  • Always one table irrespective of Cardinality.

So, all statements 1, 2, and 3 are correct.

Quiz of this Question
Please comment below if you find anything wrong in the above post

My Personal Notes arrow_drop_up
Recommended Articles
Page :