[Answered]: Create an ERD using the data elements below

Create an ERD using the data elements below. Include the following Data Elements in the ERD: 1. Patient Table: · Patient ID (Primary Key) (4 numbers) · Last Name · Date of Birth · Gender · Race/Ethnicity · Socioeconomic Status (Income Level, Education Level) · Insurance Status (Insured/Uninsured) · Geographic Location (ZIP Code, Urban/Rural) 2. Prenatal Care Table: · Care Episode ID (Primary Key) (first, second, etc. care visit) · Patient ID (Foreign Key) (4 numbers) · Date of First Prenatal Visit · Number of Prenatal Visits (8,10, 14,16.20) · Gestational Age at First Visit · Healthcare Provider (Name) · Type (MFM (maternal fetal medicine), obstetrics, infertility, midwife) · Facility Name · Type of Facility (Public/Private, Hospital/Clinic) 3. Healthcare Provider Table: · Provider ID (Primary Key) · Name · Specialty (MFM (maternal fetal medicine), obstetrics, infertility) · Years of Experience · Facility ID (Primary Key) (5 numbers) · Facility Name · Location (Address, ZIP Code) · Type of Facility (Public/Private, Hospital/Clinic) 4. Outcomes Table: · Outcome ID (Primary Key) (3 numbers) · Care Episode ID (Foreign Key) (first, second, etc. care visit) · Birth Outcome (Full-term, Preterm, Low Birth Weight, Stillbirth) · Complications (Yes/No) · Postnatal Follow-up (Yes/No) · Infant Health Status at Birth (preterm or full term) 5. Disparity Indicator Table: · Patient ID (Foreign Key) · Access to Care (Distance to Facility) · Language Barrier (Yes/No) · Cultural Competency of Provider (Assessed by Patient Feedback) Yes, No · Socioeconomic Barriers (Transportation, Childcare, Work Leave) · Facility Table (Facility ID, Facility Name, Type of Facility)