Draw an ER diagram for the below given scenario. State any assumptions you make. The CeyChin Hospital database stores details about Doctors, Patients, Appointments, Payments, Diagnosis, and Admitted Patient records like in a typical hospital. The data stored in this centralized database helps in recording the details of entities and answering queries useful in such an environment. You need to consider the following basic requirements: • Each doctor has a doctor ID. All the personal details of the doctor are recorded. A doctor may see many patients. • A patient is identified by a patient ID, and other personal details. A patient may make an appointment with many doctors. • Appointments to see a doctor are recorded by the secretary, which includes the appointment number, patient ID, patient name, doctor, location, time/date, and a contact number. • Payments are recorded for all completed appointments and include the mode of payments as cash or credit-card. • The doctors may record a Diagnosis after seeing the patients. The diagnosis record includes the diagnosis ID, patient details, id of the last appointment, and diagnosis determined by the doctor. • Admitted Patients are assigned to a ward and a room number. Each admitted patient is also assigned a Nurse who looks after the patient. • There are many nurses working in the hospital, but a nurse is assigned to look after only 1 patient. Nurses work only on the ward they are allocated. • There are 4 wards in the hospital, indicated by ward number, name and floor. Each ward is managed by a Head Nurse working in hospital.
GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class
TO BE RE-WRITTEN FROM THE SCRATCH
GET SOLUTION FOR THIS ASSIGNMENT
TO BE RE-WRITTEN FROM THE SCRATCH
- Original and non-plagiarized custom papers- Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
- Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
- Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
- Confidential- It’s secure to place an order at primewritersbay.com We won’t reveal your private information to anyone else.
- Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
- Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals The CeyChin Hospital database stores details about Doctors
Get Professionally Written Papers From The Writing Experts