Care And Respect Enterprises Staff Vaccination Leave Record Name Ever Hong Department Sales Staff No. 7021 Dose Date of vaccination Date of vaccination leave taken |19 August 2021 15 September 2021...

Extracted text: Care And Respect Enterprises Staff Vaccination Leave Record Name Ever Hong Department Sales Staff No. 7021 Dose Date of vaccination Date of vaccination leave taken |19 August 2021 15 September 2021 Entitled 20 August 2021 |24 September 2021 Yes 2. No 3 06 March 2022 Total Entitled Days taken Outstanding leaves entitled Vaccination leave entitlement 1. Each staff member entitles 1 day of vaccination leave for each dose. 2. Vaccination leave should be faken within 7 days from the date of vaccination, otherwise counted as sick leave. sample data for illustration only Assumptions: • The company encourages staff members to take vaccines by granting one day leave for each dose. The company does not want staff members taking leave not related to the vaccinations. Therefore, the leave should be taken within 7 days from the date of vaccination. The company wants to monitor the days of leave taken and outstanding. There are no differences in vaccination leave entitlement for staff members of different job positions. Q1. Draw a Crow's Foot ER diagram to represent the data model for the Staff Vaccination Leave Record, including all attributes, relationships, primary keys and foreign keys that can be identified on the record. Add new attributes and include any assumptions where necessary.