2. Use the attached table and add subtypes using SQL to create:

a) For patient treatment add outpatient, admitted patient, emergency room patient

b) For Doctors add affiliated or guest doctor

c) Do the same for nurses

1. hhospital wants to have a database to keep track of it. patients, doctors, and wards. Constmct an ER diagram to model the business. Indicate the key fur each entity type. A Type Allocated to Admitted to Patient ID Personal Info Treatment Insurance