تم الحل ✓
categoryهندسة الحاسبات
schoolبكالوريوس
event_available2026-07-14
السؤال
Transcribed Image Text:
Draw ER Diagrams for the following narratives.
1. The Human League Surgery has doctors, nurses, midwives and patients. The patient has to
telephone for appointments with the doctors or nurses and these appointments are
allocated by the receptionist. An appointment can only be made with one doctor, midwife or
nurse at a time. A patient may also only be registered with one doctor.
2. "Authors are responsible for writing plays that are performed in theatres. Every time a play
is performed, the author will be paid a royalty (a sum of money for each performance). Plays
are performed in a number of theatres; each theatre has maximum auditorium size, and
many people attend each performance of a play. Many of the theatres have afternoon and
evening performances. Actors are booked to perform roles in the plays; agents make these
bookings and take a percentage of the fee paid to the actor as commission. The roles in the
plays can be classified as leading or minor roles, speaking or non-speaking, and male or
female."
3. "A database will be made to store information about patients in a hospital. On arrival, each
patient's personal details (name, address, and telephone number) are recorded where
possible, and they are given an admission number. They are then assigned to a particular
ward (Accident and Emergency, Cardiology, Oncology, etc.). In each ward there are a
number of doctors and nurses. A patient will be treated by one doctor and several nurses
over the course of their stay, and each doctor and nurse may be involved with several
patients at any given time."
check_circle الجواب — حل مفصل خطوة بخطوة
hourglass_top
🔒
الحل الكامل متاح للمشتركين
اشترك في أرشيف الأسئلة لعرض هذا الحل وآلاف الحلول المفصلة خطوة بخطوة من معلمين معتمدين.