Register

er diagram

3,660 views
1 1 vote

1 Answer

Best answer
3 3 votes

There are 4 tables which are mentioned as below :

a)  {Test , Testlog}  :  Test being on "many" side of the testlog relationship can be merged hence..

b)  {Patient , Checks} : Similar reason as above

c)  {Performed_By}

d)  {Doctors}   : Any of test , doctors and performed_by cannot be merged with each other as performed_by is many to many relationship between test and doctors entities..

Hence we have 4 tables in total for the given ER diagram..

• selected by
Voting & Accepting an answer helps improve the community
← Previous · Can someone suggest ...Next → · DS - weighted balanc...
← Previous in category · relational algebraNext in category → · made easy work book
Position:
Show:

Related questions

4 4 votes
0 0 answers
905
905 views
practicalmetal asked Oct 26, 2023
905 views
ER Diagram
Can someone please provide me with the correct explanation for this question
0 0 votes
0 0 answers
556
556 views
Shamim Ahmed asked Dec 18, 2018
556 views
ER Diagram
How 1:1 cardinality with total participation of atleast 1 entity needs min no. of tables = 1 ?1:1 with partial participation of both entities needs min no of tables = 2?
1 1 vote
0 0 answers
808
808 views
Hemanth_13 asked Dec 4, 2018
808 views
Self Doubt on ER diagram
How to solve these type of questions https://gateoverflow.in/201404/er-diagramCopying the image for quick reference:Minimum no of tables.My approach was:First allocate al...
0 0 votes
1 1 answer
3.2k
3.2k views
Na462 asked Oct 12, 2018
3,152 views
ER Diagram to Relation
Consider ER Diagram Identify the Minimum number of relation satisfying 2nf ?A. 1B. 2C. 3D. 4