Draw the necessary E-R diagram for the following database requirements specification (20 points). A Grocery chain...

 

Transcribed Image Text:

Draw the necessary E-R diagram for the following database requirements specification (20 points). A Grocery chain has several stores with a maximum of 2 stores per city. Each store is managed by a supervisor who is responsible for the day-to-day activities of the store with the help of up to a maximum of 10 members as workers. The data stored regarding each of all these store employees include employee number, full name, address, position, salary, name of the supervisor (where applicable), details (address) of the branch office at which an employee is working. Draw the necessary E-R diagram for the following database requirements specification (20 points). A Grocery chain has several stores with a maximum of 2 stores per city. Each store is managed by a supervisor who is responsible for the day-to-day activities of the store with the help of up to a maximum of 10 members as workers. The data stored regarding each of all these store employees include employee number, full name, address, position, salary, name of the supervisor (where applicable), details (address) of the branch office at which an employee is working.

Answer rating: 100% (QA)

Heres a simplified EntityRelationship ER ... View the full answer