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.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more