1.

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 TablesFull Participation on one side: 1 Table3. 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»


Discussion

No Comment Found

Related InterviewSolutions