in Databases
1,927 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:

in Databases
1.9k views

4 Comments

@bhavna that is correct i aam not denying to it what you posted. but seein the question they used single line for cardinality "many" that is my concern. they didn't frame the question properly!
1
1
Oh got it! they should've used the arrow instead for representing one.
0
0
yes
0
0

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