Gateforum Test

Question

1-In self referential relation we alwasy need 1 table.
2-If there is a total participation of one entity with the relation,we can can merge E1,the relation and E2  into a single table.
Which of the above given statements are true?

Answer 1

In self referential relation we always need 1 table.

False statement , for m:n we need 2 tables.

If there is a total participation of one entity with the relation,we can can merge E1,the relation and E2  into a single table.

yes , True , total participation with 1:1 with one side / both sides of a relation gives 1 table .

Comments

Sir, https://gateoverflow.in/123659/self-doubt,

in @Sachin Mittal 1 answer's:-

1.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 participation-

• Always one table irrespective of Cardinality

 But diff data in Selected answer which one is true sir??

---

• Full participation on Many Side: 2 Tables 

and in best ans it is 3 written that your concern right ?

---

In @Sachin Mittal 1 answer's, for total participation at both side in M:N it is 1 table,

But in the selected answer it is 3 tables either max or min but 3 tables,\.