Database Schema (SQL) Allocation of ID and Datatypes

SQL-SCHEMA
Name
Institutional Affiliation
SQL-SCHEMA
The project was to develop a reliable SQL-Based database for a hospital information and management system. The following ER Diagram was established to meet the requirements of operations taking place at a hospital:
Figure 1: SQL Schema.
The diagram given above represents normal operations taking place at a healthcare facility. The Hospital as an organization is a complex environment in which several departments are working simultaneously aimed at providing reliable healthcare to the patients. The main actors in the diagnosis and prognosis procedures are doctors, paramedical staff, and the patient (Billington, 2011). Once the patient enters the premises of the hospital, it is the responsibility of the facility to provide reliable and efficient healthcare facilities. One of the challenges is to reduce the waiting for the patients which can be done that by automatically assigning them a unique identification number. There vital signs and initial diagnosis is performed and then they move on to the second stage of the treatment which is either treatment or later appointments.
The most challenging task in the design of a database is the efficient allocation of the human, pharmaceutical, and diagnostic resources to the patients (Billington, 2011). Moreover, the complexity increased if the same patient requires consultation from multiple medical resources. These challenges can be controlled by using automatic and synchronizing mechanisms in the database systems of the hospital. Once multiple resources are required, the system should be able to effectively communicate with the involved healthcare professionals and associated staff. A schematic including the nature and importance of data in a conventional hospital arrangement is given below:
Figure 2: Allo...