To design a database to maintain information about hospital staff, including doctors and nurses, and patients at the hospital. the information we need includes:
- Names, addresses, and social security numbers of the staff.
- Information about patients, including names, residences, and the title of their
- Each patient is allocated to a ward (room).
- Nurse staff members are tasked with working on 0–3 wards. There is at least one nurse assigned to each ward.
- The number of patients assigned to staff members who are doctors is zero or more. Patients may have more than one doctor, and they may or may not have one assigned to them. Even while multiple doctors may treat patients on the same ward, they will always have the same nurse (s).
- Create an ER diagram for this use. Name the main characteristics of each entity.
- Types of relationships and their restrictions. Make the proper assumptions for making the specification complete. Transform the ER diagram into an optimal relational model.
- Indicate any appropriate constraints, such as the unique, check, primary, foreign, and not null constraints.
Learn more about database management here:
https://brainly.com/question/14806077?
#SPJ4
