Design two equivalent Entity$-$Relationship diagrams, one in Chen$$s notation and one in crow$$s foot notation,

that model a hospital management system and consider the requirements listed below. That means that you

have to identify and determine suitable entity sets, relationship sets, attributes, keys of entity sets $($if not

specified$),$ and so on$.$ Further, add the cardinalities to the relationship sets and write down your assumptions

regarding the cardinalities if there could be a doubt.

The requirements are:

$$ Each patient has a unique ID and is described by name, address, age, phone number, and date of birth.

Age is a derived attribute. A patient$$s address includes street, city, state, and zip code.

$$ At least one medical record is recorded for each patient.

$$ Doctors have their specialties, date of birth, age, and address, and treat multiple patients. Age is a

derived attribute. Their unique identifier is their name. A doctor$$s address includes street, city, state,

and zip code.

$$ Nurses are also identified by their names, have specialties, and share personal details with doctors.

They provide care to various patients.

$$ Medical records, which are distinctively identified by a record ID$,$ contain treatment details.

$$ Appointments have a unique ID$,$ encompass date and time, and involve specific patients and doctors.

$$ A patient can have multiple appointments.

$$ While a doctor can attend multiple appointments, each appointment is managed by only one doctor.

$$ Nurses and doctors belong to a hospital department.

$$ Hospital departments have by a unique ID$,$ names, functions, and a department head.

$$ Each prescription is linked to a specific medical record. Prescriptions are detailed with medication

and dosage and have a unique ID$.$