Question

Visiting Doctor Scenario

i) Draw an ERD for a scenario in which patients visit doctors. It is possible that a patient is visited by more than one doctor. Create DOCTOR and PATIENT entities and add at least four attributes to them including a primary key. Create an implementation ready ERD with all appropriate connectivities and cardinalities. Justify your choice of cardinalities with real world examples. In case you need to add any new entities, add at least two attributes apart from their primary keys to describe the entity.

ii) Extend your ERD by adding a test entity. During each visit, doctors may ask patients to take a test in the doctor’s office. Write all appropriate connectivities and cardinalities in the ERD.

Answer 1

ERD:

here the relationship is many-to-numerous

A specialist can visit numerous patients or may not vist by any means, we speak to it as zero-or-many04

A patient can be visited by one specialist or numerous specialists. we speak to it as one-or-numerous phprOqDNr.png

Since the relationship is many-to-many, visits relationship additionally goes about as another element with Doctor element essential key(doctor permit number) and Patient element essential key (Patient name) as unfamiliar keys

with extra credits (remedy and visit time)

/*If this helps you, please let me know by giving a positive thumbs up. In case you have any queries, do let me know. I will revert back to you. Thank you!!*/