Question

11. medical clinic Using the Crow's Foot notation, create an ERD that can be implemented for a medical clinic, using at least the following business rules: a. A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. b. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” c. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. d. With each visit, the patient's records are updated to provide a medical history. e. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. f. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. g. A patient may pay the bill directly, or the bill may be the basis for a claim submitted to an insurance company. h. If the bill is paid by an insurance company, the deductible is submitted to the patient for payment.

Answer 1

Answer:- E-R diagram : This er diogram/model has 6 main entities : Patient Doctor Appointment Medica History BiU Payment Method This Er model has been converted in to 3NF Here Each Entity and its attributes are in tabular form. Data types of each attribute has been mentioned with it. The primary key as Pk and foriegn key as FK has been mentioned there.

Patient PK Patients Number Doctor First name Number PK DoctorID Text Text First name Text Last name Gender Text Text Appointment PK AppointmentID Number Date Time Date Time FK Patienti Number FK DoctorID Number type of appointment Text issue Text PK BillID Number Last name Gender Contact Number Text Number Email Text Contact date of birth Email date Text address Text date date of birth Number address Text FK Medical HistoryID InsuranceCo. Text Specialization Text Bill PK Bill Number Medical History Date Time Date Time Number payment Method PK payment Method ID Number Number TotalAmount FK payment Method ID Date Time Number Description Text PK Medical HistoryID Last appointment Date Time issue Medical history description Text Payment Made Text Text due amount Number Date Time Date Time Insurance co flag Text Deductable Number