Question: Develop an EER diagram for the below problems 1- A cloth retail chain has multiple stores. Each store is identified by an address and its

Develop an EER diagram for the below problems 1- A cloth retail chain has multiple stores. Each store is identified by an address and its attributes are area, and max number of allowed customers. Each retail store employs multiple Employees. The employees are several retail associates and a store manager. Further there are on-call and full-time retail associates the on-call employee can work in multiple stores while full time can only work in one store the manager can only work for one store. Employees attributes are employee number, name. Retail associates are paid by hour and they have hourly rate, while the managers and assistant momagers have an annual salary. the database should also keep track of the number of hours that an employee worked every day. Retail stores contain multiple products. Products are identified with product number and they have color, size, and quantity attributes. 2- A charity organization has volunteers. Volunteers have name, working hours and telephone number. Some of the volunteers have a role of supervising the work of other volunteers. A supervisor can supervise multiple volunteers and a volunteer can only have one supervisor. A volunteer is assigned tasks. The attribute of tasks are task id, description, and special health and safety requirements to do the task. A volunteer might be assigned multiple tasks and a task can be assigned to more than one volunteer. You also need to track the last date when a volunteer was assigned a task (if a volunteer was assigned the same task more than once then you need to track the date of the last time the volunteer was assigned the task)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
