1,911 views
3 votes
3 votes

this question is from virtual gate test series. 

what is the minimum number of RDBMS tables needed for the following er diagram:

1 Answer

2 votes
2 votes
Number of tables for this is 5

Because there should be m:n relationship between Doctor and Patient as well as Doctors and Test

So because of m:n relationship 1 extra table for both relation

Total = 1+2+2=5

Related questions

0 votes
0 votes
0 answers
1
smsubham asked Sep 19, 2018
563 views
15 votes
15 votes
13 answers
2
targate2018 asked Aug 12, 2017
8,836 views
How many minimum relations required for given ER diagram ?
11 votes
11 votes
4 answers
3
targate2018 asked Aug 11, 2017
11,655 views
The minimum number of tables to represent ER-Diagram such that the relational database satisfies 1NF.