EventHelpers is a company that specializes in event medical assistance. They can handle any type of medical emergency. The company has a range of employees from first aiders to paramedics with...


Draw an Extended Entity Relationship model using the information provided. You can use any tool of your choice.Instructions


• This solution must be implemented in Microsoft Access.


EventHelpers is a company that specializes in event medical assistance. They can handle any type of<br>medical emergency. The company has a range of employees from first aiders to paramedics with degrees.<br>EventHelpers has contacted you to help them design the database so that they can keep track of which<br>employees went to which events. The company provided you with the following details:<br>A first aider has a certificate, which indicates the expiration date of the certificate. The certificate<br>has to be renewed every three (3) years.<br>A paramedic has a degree that does not expire.<br>The company needs the ID, Name, Surname, Contact details and, the address of each employee.<br>The company sends several medical assistants, a few first aiders and, depending on the size of the<br>events, 1-3 ambulances, to each event.<br>Each medical assistant is paid per hour based on their qualification.<br>To book EventHelpers for an event, the following details are required:<br>The name of the event.<br>The time and date of the event.<br>The address of the event.<br>The number of expected people at the event.<br>Because most events don't have an end time, the company only invoices the events afterward. To invoice<br>an event, they will need to know which medical assistants were at which event and how many hours they<br>have worked.<br>

Extracted text: EventHelpers is a company that specializes in event medical assistance. They can handle any type of medical emergency. The company has a range of employees from first aiders to paramedics with degrees. EventHelpers has contacted you to help them design the database so that they can keep track of which employees went to which events. The company provided you with the following details: A first aider has a certificate, which indicates the expiration date of the certificate. The certificate has to be renewed every three (3) years. A paramedic has a degree that does not expire. The company needs the ID, Name, Surname, Contact details and, the address of each employee. The company sends several medical assistants, a few first aiders and, depending on the size of the events, 1-3 ambulances, to each event. Each medical assistant is paid per hour based on their qualification. To book EventHelpers for an event, the following details are required: The name of the event. The time and date of the event. The address of the event. The number of expected people at the event. Because most events don't have an end time, the company only invoices the events afterward. To invoice an event, they will need to know which medical assistants were at which event and how many hours they have worked.

Jun 02, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here