I think Answer should be 3, but given is 4..

The Gateway to Computer Science Excellence

+7 votes

Best answer

+2 votes

While converting ER Diagram to Relation Table, We create a separate table for:

1. WEAK Entity.

2. STRONG Entity.

3. M:N Relationship.

4. Composite Attribute.

5. Multivalued Attribute.

So, answer = 3.

1. WEAK Entity.

2. STRONG Entity.

3. M:N Relationship.

4. Composite Attribute.

5. Multivalued Attribute.

So, answer = 3.

0 votes

I think the answer must be 4.

For E1,E2,E3 we will defiantly need one table each.

By putting primary key of E2 i,e G in E1's table we can specify the indentifing relationship R between them. Hence no need of table for R.

But For P we will need a different table in which we will put primary key of E3 i,e E and Primary key of E1 i,e C as foreign keys and the primary key of the table for P will be the combination of E and C i,e EC

Hence we need total 4 tables( for E1, E2 ,E3 and for P)

For E1,E2,E3 we will defiantly need one table each.

By putting primary key of E2 i,e G in E1's table we can specify the indentifing relationship R between them. Hence no need of table for R.

But For P we will need a different table in which we will put primary key of E3 i,e E and Primary key of E1 i,e C as foreign keys and the primary key of the table for P will be the combination of E and C i,e EC

Hence we need total 4 tables( for E1, E2 ,E3 and for P)

- All categories
- General Aptitude 1.9k
- Engineering Mathematics 7.5k
- Digital Logic 2.9k
- Programming and DS 4.9k
- Algorithms 4.4k
- Theory of Computation 6.2k
- Compiler Design 2.1k
- Databases 4.1k
- CO and Architecture 3.4k
- Computer Networks 4.2k
- Non GATE 1.4k
- Others 1.4k
- Admissions 595
- Exam Queries 573
- Tier 1 Placement Questions 23
- Job Queries 72
- Projects 18

50,737 questions

57,258 answers

198,086 comments

104,735 users