Information

By accessing an Information webpage, you can easily view Question 6 7 9 14 15 and 16.

Question 6:Details of all the facilities in the system

Name Address City Province Postal Code Phone Number Web Address Type Capacity General Manager Number of Employees

Question 7:Get details of all the employees currently working in a specific facilityInfo

Question 9: Get details of all the doctors who have been infected by COVID-19 in the past two weeks.

First name Last name Date Facility

Question 13:. For every facility, provide the province where the facility is located, the facility name, the capacity of the facility, and the total number of employees in the facility who have been infected by COVID-19 in the past two weeks.

province Facility Capacity Infected number

Question 14:. For every doctor who is currently working in the province of “Québec”, provide the doctor’s first-name, last-name, the city of residence of the doctor, and the total number of facilities the doctor is currently working for.

First_name Last name City facility number

Question 16: Get details of the nurse(s) or the doctor(s) who are currently working and has been infected by COVID-19 at least three times.

First_name Last name First day of work Role Date of birth Email address total number of hours scheduled

Question 17: Get details of the nurse(s) or the doctor(s) who are currently working and has never been infected by COVID-19

First_name Last name First day of work Role Date of birth Email address total number of hours scheduled