retagged by
1,044 views
0 votes
0 votes

How many minimum tables are required for this er diagram consisting of a many - many relation and total participation of one of the entities.? 

Can't i merge relation R and entity B? why?  

retagged by

1 Answer

2 votes
2 votes
There will b 3 tables.

Since for M to M relation, there will b seperate table for the relation R.Therefore

One for A, second for B and third for R.

Plse do correct me if i am worng.Thankyou!

Related questions

3 votes
3 votes
1 answer
2
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:
15 votes
15 votes
13 answers
3
targate2018 asked Aug 12, 2017
8,614 views
How many minimum relations required for given ER diagram ?
11 votes
11 votes
4 answers
4
targate2018 asked Aug 11, 2017
11,493 views
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.