Need to create an Access database using the information from the ERD diagram.

PatientLocation PK, FK PatientID Varchar(5) RoomNumber Varchar(3) PK RoomEntryDateDate RoomExitDate Date BedNum Vrchar(1) ContactAddress PK ContactiD Varchar(5) PK, FK ContactD Varchar(5) ConFirstName Varchar(15) Street Varchar(20) ZipCode FK ZipCode Varchar(5)OHPKZipCodeVarchar(5) Patient PKContactType |Varchar(15) Phone Varchar(10) City Varchar(5) PK PatientiD HPatFirstName Varchar(15) PatLastName Varrchar(25) DateofBirthDate PK.FKPatientID varchar(5) PK ConditionID Varchar(5) PK ConditionlD Varchar(5) PK DateStarted Date sc Varchar ateEndedDte Notes Varchar PatientMedication PK.FK PatienuD Varchar(5)PK.FK PatientiDVarchar(5) PK MedID Varchar(5) PK,FK MedID MedName VarChar(25) PKFKNurselD achar(5) PK, FK NurselD Varchar(5) PK StartDate Time Date PK DatePrescribedDate PK DateAdmin Date DosageFreq Varchar(15) DosageAmt Varchar(15) DoctorlD Varchar(5) NumRefills Number(2) LastRefill PK TimeAdmin Time EndDateTime Date Varchar(15) Dosage Notes Nurselnformation Date NurseFirstName Varchar(15) NurseLastName Varrchar(25) DateofBirth Date PatientAssignment Varch(1) Varchar(15) Gender EdStatus PK,FKPatientiD Varchar(5 PK Date Date NurseAddress PK, FK NurselDVarchar(5) PK Street Varchar(20) FK ZipCode Varchar() O