670 views
0 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 1 vote
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.
Position:
Show:

Related questions

0 0 votes
1 1 answer
907
907 views
ace0-0 asked Dec 21, 2025
907 views
What is the minimum number of tables for a BINARY RELATIONSHIP WITH ATTRIBUTES for the follwoing cases:Case 1: One-to-One relationship between two entities and partial pa...
1 1 vote
2 answers 2 answers
2.2k
2.2k views
PEKKA asked Nov 29, 2016
2,152 views
Any Good Resource to study this topic ? Or Could anyone explain this topic to me ?
6 6 votes
2 2 answers
17.3k
17.3k views
Ashish Sharma 3 asked Nov 24, 2017
17,294 views
I am confused whether we need to have 2 tables or a single table when 2 strong entities are in 1:1 relationship with one having complete participation.Ex: How is it possi...
1 1 vote
3 3 answers
613
613 views
JHighlight asked Jul 12, 2025
613 views