this is the scenario for the assignment and we have three tasks and plz solve these all tasks...MediCare Health Systems, situated in the vibrant city of Amman, Jordan, stands as a prominent hospital that has progressively broadened its services and clientele. The evolution necessitated the adoption of a sophisticated automated database system. To realize this goal, the hospital forged a partnership with HealthData Solutions, a distinguished database company based in Amman, Jordan.

As a Database Developer at HealthData Solutions, you and your team are entrusted with the design and implementation of the Hospital Database System tailored for MediCare Health Systems. The primary objective is to adeptly oversee day$-$to$-$day hospital operations, ensuring seamless coordination in patient care, staff collaboration, and administrative functions. Emphasis is placed on upholding data security, regular backups, authorization protocols, and ensuring a resilient network connectivity infrastructure.

The comprehensive Hospital Database System encompasses diverse entities, commencing with Patient Information. This encompasses unique identifiers such as patient ID$,$ name, contact details, gender, date of birth, address, and nationality. Patients may have multiple appointments with various doctors. Details for doctors include doctor ID$,$ full name, specialization, contact number, and address. Similar information is maintained for nurses and support staff, customized to their respective roles.

In a bid to enhance operational efficiency, the database system meticulously manages information concerning Hospital Facilities and Equipment. This involves facility ID$,$ name, location, and specifics regarding the medical equipment available in each facility. Equipment data incorporates equipment ID$,$ name, model, and maintenance history.

The system is designed to facilitate the reservation of a facility by a patient, with each patient being able to reserve one facility. Meanwhile, equipment is shared among multiple patients, with each patient being able to use only one specific equipment. This nuanced approach contributes to optimizing the utilization of hospital resources.

In conclusion, the collaborative effort between HealthData Solutions and MediCare Health Systems aims to establish an exemplary benchmark in healthcare database systems, ensuring efficiency, security, and seamless functionality for the benefit of patients and healthcare practitioners alike.

With all of this information, you can build the required database system with its full functionalities and requirements.

There are some rules and restrictions that should be taken in concern when building the MediCare Health Systems which are the following:

$$ It Requires a Backup.

$$ It Requires a Password for Security.

$$ Do not register any two customers with the same email.

$$ If the member did not fill the nationality, fill it with $$Jordanian$$ by default.

$$ Do not keep a Doctor or Patient name empty.