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