8,579 views
15 votes
15 votes

How many minimum relations required for given ER diagram ?

13 Answers

9 votes
9 votes

hope  this helps...

2 votes
2 votes

Total 8 tables are required

Let (EntityName,NumberOf Table)

(E1,1),(E2,3),(E3,1),(E4,1),(E5,2) 

E2 has 3 tables because in suppose we have 

Recursive Relationship -types of relationships in er diagram

So 3 tables required for E2 and E5 is weak entity so 2 tables required

weak entity type(entity and its types)

total = 1+3+1+1+2 = 8 tables 

Reference :-http://www.edugrabs.com/entity-and-its-types/

Related questions

11 votes
11 votes
4 answers
1
targate2018 asked Aug 11, 2017
11,485 views
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.
0 votes
0 votes
2 answers
2
Balaji Jegan asked Nov 4, 2018
2,198 views
How many minimum number of tables needed for this Quaternary Relationship?
1 votes
1 votes
6 answers
3
Abbas2131 asked Jul 30, 2018
2,234 views
What are minimum number of tables required for the following given ER models such that they satisfy 1NF ?
5 votes
5 votes
1 answer
4
Ashish Sharma 3 asked Nov 24, 2017
2,606 views
How many minimum relations required for the above ER diagram?According to me it should be 7. Please let me know the answer according to you.