Question

We would like to design a database to maintain information about hospital staff,
including doctors, nurses and patients at the hospital. The information we need includes: (5)
o Staff, including their names, addresses and CNIC numbers.
o Patients, including their names, addresses, CNIC and the name of their health
insurance company.
o Patients are assigned to a ward (room).
o Those staff who are nurses are assigned to zero or more wards. Each ward has
at least one nurse assigned.
o Those staff who are doctors are assigned to zero or more patients. Patients
may or may not have a doctor assigned, and they may have more than one
doctor. Patients in the same ward may have different doctors but will always
have the same nurse(s).

Answer 1

Answer:

2

Explanation:

yes. 2nd is the answer of thus yes 2nd is the answer of thus