Skip to content
Related Articles

Related Articles

Improve Article
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

Attention reader! Don’t stop learning now. Learn all GATE CS concepts with Free Live Classes on our youtube channel.

My Personal Notes arrow_drop_up
Recommended Articles
Page :