2,582 views

4 Answers

Best answer
9 votes
9 votes
No of table will be 3

E1, E2,E3 we need 3 tables

but as it gives 1:n relationship , so no more tables are needed
selected by
2 votes
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.
0 votes
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)
0 votes
0 votes
Answere will be 3 tables as in 1:n case primary key of 1 side is taken as foreign key in N side which is used to reference 1 side table thus ER diagram is simplified to 2 tables ...same approach can be used for other side ...hence ER diagram is reduced to tables E3(E,F) , E1(C,D,E,G) , E3(E,F)

Related questions

1 votes
1 votes
3 answers
1
ayushigupta asked Nov 21, 2015
2,674 views
1 votes
1 votes
1 answer
2
shikharV asked Dec 8, 2015
2,740 views
Given answer is 2, but I think that for each multivalue attribute we need a relation and one for the main entity, therefore 3 should be the answer. Please correct me if I...
3 votes
3 votes
1 answer
4
Manu Thakur asked Sep 17, 2017
1,866 views
this question is from virtual gate test series. what is the minimum number of RDBMS tables needed for the following er diagram: