InstructionsThe initial steps, Database Requirements Collection and Requirements Definition, have been completed for you, and you are provided with ten requirements for the Hospital Patients Drug Pharmacy Database. Use these requirements to complete the four development tasks described below.

Database Requirements Defined Hospital Patients Drug Dispense Database will keep track of the following:

Patients:

1.For each patient we keep track of a unique patient identifier, patient date of birth, gender, patient name (first name, middle initial and last name), age, marital status, language.

2.Patient Financial Information: as follow Employment Information, insurance information, and responsible party.

3.Patient contact information. Address (including, zip code and state, cell phone, email)

4.Patient demographic (HW1)Provider information (MD or Nurse)

5.Provider: first name, middle initial and last name, specialist, gender, age, graduation date from med. School, year of practice, language, date of hire, providerId, federalId) Visit (Patient Care)

6.Visit requires an encounter_ID (encounterID,datetime, patientID,providerID)

During the visit the following could be recordVital Sign (weight, height, blood Pressure, temperature, oxygen Level, heartbeats

Treatment (ICD10, medication)Laboratory Testing (date, type, results)Diseases (diseaseName, ICD-10, diseaseType)

Prescription (date, patientId, providerId)A.Create the ER diagram for the patient visit to the primary care facility.

Map the ER diagram (conceptual model)

Create a Relational Schema:

Schema models all entities and relationships present in the E-R model.

Primary keys are underlined, foreign keys are identified, Quality of design decisions made10 pts