Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. Following is the description of the business operations of Oriental Medical Clinic (OMC): The clinic has a number of regular patients and new
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.
Step by Step Solution
★★★★★
3.50 Rating (153 Votes )
There are 3 Steps involved in it
Step: 1
Assumptions 1 Each patient has a unique patient ID 2 Each doctor has a unique doctor ID 3 Each appointment is associated with one patient and one doctor 4 Each doctor can have multiple appointments 5 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started