444 views
0 votes
0 votes
Suppose i have Two strong entity E1 and E2 connected by a 1 to many relationship R.

E1 <--------- R ---------- E2

How many table will be created when i will convert the above ER diagram into database ?

I know that when E2 will be in total participation answer will be 2. Since, E2's primary key will merge perfectly. I am not sure about above. I have seen multiple places and found different answer. I am looking for some solid argument with answer.

Answer can be 2 or 3.

1 Answer

1 votes
1 votes
the no of table depends on the type of relationship -
Procedure is as follows -

Make a table for all entities;

if relationship involves > = 3 tables make new table fo relationship:
If it has two tables then the participation is like 1: N or N:1 or 1:1 no new table need.

if it's M: N new table will be needed.

Related questions

1 votes
1 votes
2 answers
1
PEKKA asked Nov 29, 2016
1,432 views
Any Good Resource to study this topic ? Or Could anyone explain this topic to me ?
0 votes
0 votes
0 answers
3
Shamim Ahmed asked Dec 18, 2018
305 views
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ?1:1 with partial participation of both entities needs min no of tables = 2?
3 votes
3 votes
2 answers
4