Simple Entity Relationship Diagram Assignment

Instructions Using the Crow’s Foot methodology, 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. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, a treatment. c. With each visit, the patient’s records are updated to provide a medical history d. Each patient visit creates a bill. e. Each bill must be paid. A patient can make many payment transactions to cover the bill total through an installment plan. A Payment is processed for one bill at a time, and a bill can be covered though many payment transactions. (hint: create a payment entity)