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.

In the given scenario, you serve as a Database Developer leading the creation of the MediCare Health Systems. To successfully achieve this, a series of tasks must be addressed:

Task

$1$

: Database Design and User Interface Development

Define at least

$4$

$$system requirements and

$5$

$$user requirements based on the MediCare Health Systems.

$$

$$Identify entities, attributes, and relationships in the Swift Transport Database System using an Entity Relationship Diagram

$($

ERD

$)$

$.$

$$

$$Convert the ERD into a logical database design with a Relational Schema, incorporating primary keys, foreign keys, data types, and constraints.

$$

$$Develop an attractive and interactive user input output interfaces design using tools such as Figma or wireframes.

I want to clarify the solution to each question within the task separately.

$($

I want the user interface to be drawn in a picture.

$)$

$$I do not want it in writing.