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 P

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.

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

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.

Money-back guarantee

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

Zero-plagiarism guarantee

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

Free-revision policy

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

Privacy policy

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

Fair-cooperation guarantee

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