Open In App

GATE | Quiz for Sudo GATE 2021 | Question 4

Like Article
Like
Save
Share
Report

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


Last Updated : 14 Dec, 2020
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads