hospital stores data about patients, their admission and discharge from departments and their treatments. For each patient, we know the name, address, sex, social security number, and insurance code if existing$).$ For each department, we know the departments name, its location, the name of the doctor who heads it$,$ the number of beds available, and the number of beds occupied. Each patient gets admitted at a given date and discharged at a given date. Each patient goes through multiple treatments during hospitalization; for each treatment, we store its name, duration, and the possible reactions to it that the patient may have