Hospital System Exercise

A hospital is organized into WARDs. Each ward has a name, number, and a head nurse who manages the ward. We keep track of the start date of the head nurse.

Each ward is responsible for a number of PATIENTs. Each patient has a name, ID$,$ and is assigned to a specific room within the ward.

We store each DOCTOR's license number, office location, specialization, gender, and birthdate. Each doctor is associated with one or more wards but may provide consultation across different wards. We keep track of the number of hours per week that a doctor currently spends on patient care. We also keep track of the primary nurse assigned to each doctor.

Each patient may have a number of MEDICAL RECORDs. For each medical record, we keep track of the diagnosis, treatment plan, and medications prescribed.

Additionally, we track the hospital's INVENTORY. Each item in the inventory has a name, code, quantity, and location within the hospital. Items could include medical supplies, equipment, and pharmaceuticals.

This miniworld scenario reflects the structure of a hospital system, where departments are wards, projects are patient care, employees are doctors and nurses, and dependencies are medical records and inventory items.