pls help me : Draw an ER diagram according to the following requirements: Database to manage daily medical examination and treatment in the hospital (not interested in treating inpatients): - The hospital has many doctors and nurses from different departments. Each doctor and nurse belongs to only one department - The patient when he comes to the doctor will be created a patient record if it is the first visit - Each visit will be made a medical record and assigned an initial clinic. Each visit is attended by a doctor and an assistant nurse. - The doctor may ask the patient to perform tests, x-rays, endoscopy, .... - After the results are available, the patient returns to the original clinic for the doctor to read the results and prescribe medicine if any - Patients can buy medicine in the hospital pharmacy or buy it outside

A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 3TD
icon
Related questions
Question

pls help me : Draw an ER diagram according to the following requirements:
Database to manage daily medical examination and treatment in the hospital (not interested in treating inpatients):
- The hospital has many doctors and nurses from different departments. Each doctor and nurse belongs to only one department
- The patient when he comes to the doctor will be created a patient record if it is the first visit
- Each visit will be made a medical record and assigned an initial clinic. Each visit is attended by a doctor and an assistant nurse.
- The doctor may ask the patient to perform tests, x-rays, endoscopy, ....
- After the results are available, the patient returns to the original clinic for the doctor to read the results and prescribe medicine if any
- Patients can buy medicine in the hospital pharmacy or buy it outside

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Dataset
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning