Due Wednesday, 10:00 AM Workshop 1 10 points Add class comment Submit the second draft of the hospital ERD (the .mwb file). 1. Make sure you show all the specialisation hierarchies and the attributes for the Staff supertype and all its subtypes (the work you did in class) 2. Create subtypes for the test entity to show Covid Test, MalariaTest, and FullBloodCount 3. Make sure you have changed the relationship between Visit and Test to many-to-many relationship 4. Create a relationship between one of the subtypes of staff and the bridge entity generated from step 3 above to show which of the staff carried out a test. STAFF Sat_ID VARCHAR(45) First Name VARCHAR(45) Last Name VARCHAR(45) Address VARCHAR(100) Phone VARCHAR(45) Indians NON-MEDICAL STAFF Staf ID VARCHAR(45) PATIENT Visit Patient ID VARCHAR(10) PATIENT Patient ID VARCHAR(10) Patient Nam VARCHAR(48) DOCTOR Doctor_ID VARCHAR(10) Patient LastName VARCHAR(45) Dale DATETIME Patient DOG DATETIME Complain VARCHAR(256) Patient Phone VARCHAR45) Test VARCHAR(45) Patient Prescription VARCHAR(45) Diagnosis VARCHAR(225) Address_ine VARCHAR(45) Indexes Adresse? VARCHAR(45) O VARCHAR(45) State VARCHAR(46) Prescription Prescription ID INT Drug. Name VARCHAR(45) Dosage VARCHAR(45) Duration VARCHAR(45) Instructions VARCHAR(100) Prescriptioncol VARCHAR(45) Vist. PATIENT Patient ID VARCHAR(10) Test DOCTOR_Doctor JD VARCHAR(101 TestID INT ML Dale DATETIME TIN VARCHAR(45) PATIENT.PL VARCHAR(101 Vat DOCTOR Doctor D VARCHAR(10) Vist De DATETIME LAB SCIENTIST STAFFJD VARCHAR(46) DOCTOR Doctor IO VARCHAR(10) DOCTOR Specialty VARCHA FFT Y Yo NURSES PHARMACISTS STAFF Stal ID VARCHAR(45) STAFF SAID VARCHAR(45) Indexes LAB SCIENTIST STAFF Stal IO VARCHAR(45) Test.hes Valt. Test Test.ID INT Testha Val. Tout VSL PATIENT Patient ID VARCHIO Test.hu Var, Test, VILDOCTOR Doctor JD VARCHAR(10) Touth Vol_Test_Vit Date DATETIME Tests Vist Test LAD SCIENTIST STAFF BO VARCHAR(45) Test.has Vist Vis PATIENT Patient ID VARCHAR(10) Test has at Via DOCTOR Doctor ID VARCHAR(10) Tous Vol. VolDate DATETIME Indus COVIDTEST Test Test ID INT Test PATIENTPJD VARCHAR(10) Tout Viet OCTOR Doctor JO VARCHAR(10) Test DATETIME Tout LA SCIENTIST STAFF SID VARCHAR(45) E FULLBLOODCOUNT Test. TestID INT Test.Vt PATIENT Patien LO VARCHAR(10) Test, VILDOCTOR Doctor JO VARCHAR(10) Tesl v Date DATETIME Test LAR SCIENTIST STAFF SIO VARCHAR(45) MALARIATEST TesLTOSUO INT Test Visit PATIENTPJD VARCHAR(10) Test Visit DOCTOR Doctor_IO VARCHAR(10) Test Visit Dale DATETIME Tout LAB SCIENTIST STAPT Ball 10 VARCHAR(45) Test has Visit Tesl Tost_ID INT Test V PATIENT Patient ID VARCHAR(10) Text Vit DOCTOR Doctor O VARCHAR(10) Test Vis Data DATETIME Test AB SCIENTIST_STAFF_StatUD VARCHAR(45) Vt PATIENT_PaintJD VARCHAR(10) V DOCTOR Doctor ID VARCHAR(10) Vist Dale DATETIME