Answered step by step
Verified Expert Solution
Question
1 Approved Answer
this should be answered with mysql Database. STAFF SAJD VARCHAR(45) First Name VARCHAR(45) Last Name VARCHAR(45) Address VARCHAR(100) Phone VARCHAR(45) Indians NON-MEDICAL STAFF Staf ID
this should be answered with mysql Database.
STAFF SAJD 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 Frame VARCHAR(45) DOCTOR Doctor_ID VARCHAR(10) Patient LastName VARCHAR(45) Dale DATETIME Patient DOB DATETIME Complain VARCHAR(256) Patient Phone VARCHAR(48) Test VARCHAR(45) Patient Prescription VARCHAR(45) Diagnosis VARCHAR(225) Addrew_Ine VARCHAR(43) Adresse VARCHAR(45) City VARCHAR45) State VARCHAR(45) Prescription Prescription ID INT Drug. Name VARCHAR(45) Dosage VARCHAR(45) Duration VARCHAR(45) Instructions VARCHAR(100) Prescriptioncol VARCHAR(45) Visit PATIENT Patient ID VARCHAR(10) Test VUDOCTOR Doctor ID VARCHAR 101 TestID INT Date DATETIME TIN VARCHAR(45) VIPATIENT PU VARCHAR(10) Vat DOCTOR Doctor VARCHAR(10) Vist De DATETIME LAB SCIENTIST STAFFSID VARCHAR(46) DOCTOR Doctor IO VARCHAR(10) DOCTOR Specialty VARCHA Indens NURSES STAFF Sta IO VARCHAR(45) PHARMACISTS STAFF SAID VARCHAR(45) LAB SCIENTIST STAFF Start O VARCHAR(45) Testhes Val Test Test ID INT Test. Val. Tost. V PATIENT Patient ID VARCHIO Testha Val Test VILDOCTOR Doctor JO VARCHAR(10) Test Viol_Test_Visit Date DATETIME Tests Vist Test LAD SCIENTIST STAFF BO VARCHAR(45) Testhes Vist Visit PATIENT Patient ID VARCHAR(10) Test has at Via DOCTOR Doctor ID VARCHAR(10) Touth Vol. VILD DATETIME COVIOTEST Test Test IT Test PATIENT PUD VARCHAR(10) Tout Viet OCTOR Doctor3D VARCHAR(10) Tere DATETIME TLAR SCIENTIST STAFF SUID VARCHAR(45) E FULLBLOODCOUNT Test TestID INT Test.Vt PATIENT Palien JD VARCHAR(10) Test. VLDOCTOR Doctor JD VARCHAR(10) Test ve Date DATETIME Test LAR SCIENTIST STAFF SIO VARCHAR(45) Indexes MALARIATEST TesLTOM. INT Test Visit PATIENT_PatentID VARCHAR(10) Test_VAL DOCTOR Doctor_IO VARCHAR(10) Test Visit Dale DATETIME Test LAB SCIENTIST_STAPT Stal ID VARCHAR(45) Test hos Visit Tesl Tost_ID INT Test PATIENT PJD VARCHAR(10) Test Vit DOCTOR Doctor JO VARCHAR(10) Test Vin Da DATETIME TestLAB SCIENTIST_STAFF_Stall JO VARCHAR(45) V PATIENTPJD VARCHAN101 V DOGTOR Doctor JO VARCHAR(10) Visit Dale DATETIME 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 CovidTest, 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 Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started