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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!