# 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.

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