edited by
1,089 views
1 votes
1 votes

Minimum no of table for this ER diagram

 

edited by

4 Answers

3 votes
3 votes

Ans : 3 

As no multivalued attributes are there .

 

 

0 votes
0 votes
Can we do so using only one table coz no entry left with null and 1 will be the minimum table..?
0 votes
0 votes

Answer should be 3.

relation 1 is for  (E1,E2)

relation 2 is for (E2,E3)

relation 3 is for E2 only as above both relation 1 and 2 have explicitly mentioned E1 and E3 and now to mention E2 we make relation 3

Related questions

1 votes
1 votes
1 answer
1
0 votes
0 votes
0 answers
2
1 votes
1 votes
0 answers
3
1 votes
1 votes
1 answer
4