2. Following is the description of the business operations of Oriental Medical Clinic (OMC): The clinic...

 

Transcribed Image Text:

2. Following is the description of the business operations of "Oriental Medical Clinic (OMC)": The clinic has a number of regular patients and new patients come to the clinic regularly. Patients make appointments to see one of the doctors. Several doctors attend the clinic and they each have their own hours when they attend the clinic. Some doctors are general practitioners (GPs) while others are specialists (for example, cardiologists, dermatologists, endocrinologists, etc.). Doctors' hours are defined and fixed by each doctor but can be changed if necessary. Different doctors may charge different fees. Doctors send patients to other clinics for X-Rays, blood tests, etc. These reports are sent from the clinics to doctors electronically. Doctors write medical certificates. Patients have families and the family relationships are important. Medical records of each patient need to be maintained. Information on prescriptions, insurance, allergies, etc. needs to be maintained. Design the database for OMC with the help of suitable E-R diagram. Give suitable assumptions and discuss the strengths and weakness of the model. 2. Following is the description of the business operations of "Oriental Medical Clinic (OMC)": The clinic has a number of regular patients and new patients come to the clinic regularly. Patients make appointments to see one of the doctors. Several doctors attend the clinic and they each have their own hours when they attend the clinic. Some doctors are general practitioners (GPs) while others are specialists (for example, cardiologists, dermatologists, endocrinologists, etc.). Doctors' hours are defined and fixed by each doctor but can be changed if necessary. Different doctors may charge different fees. Doctors send patients to other clinics for X-Rays, blood tests, etc. These reports are sent from the clinics to doctors electronically. Doctors write medical certificates. Patients have families and the family relationships are important. Medical records of each patient need to be maintained. Information on prescriptions, insurance, allergies, etc. needs to be maintained. Design the database for OMC with the help of suitable E-R diagram. Give suitable assumptions and discuss the strengths and weakness of the model.