The hospital database aims to maintain information about hospital staff, including doctors and nurses, and patients at the hospital. The information needed includes: Doctors, including their names. ID room number, and specialty Each doctor has a unique ID Nurses, including their names and ID. Each nurse has a unique ID Patients, including their names, addresses, and the name of their insurance company Patients are each assigned to a ward (room). The dates that a patient was admitted to and discharged from a ward need to be recorded. A ward is described by the ward number, and building number Each nurse assigned to zero or more wards. Each ward has at least one nurse assigned Each doctor 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 nurses octor Patients in the same ward may merent doctors but will always have the same nurse(s) Design the ER diagram for the hospital DB. Specify key attributes of each entity type structural constraints (participation constraints and cardinality ratio, or (min, maxl) on each relationship type, and your assumption You can either handdo