Scenario 1: A privately owned company that sells industrial kitchen equipment needs to set-up a database for their employees. The company has vastly expanded over the last couple of years and needs to...

Scenario 1:

A privately owned company that sells industrial kitchen equipment needs to set-up a database for their employees. The company has vastly expanded over the last couple of years and needs to keep track of its employees’ salaries.

The salaries are worked out according to the position of the person in the department that they work in. Each department has certain facilities, for example the director’s department has a smoking balcony, the factory has a water cooler e.t.c.

Each position has the same salary, regardless of the department. For example, a manager in the factory has the same salary as the manager of the IT department. Each employee is uniquely identified by their employee’s ID number.

The CEO would also like to know how many positions in each department there are, as well as the name of the branch each employee works for. Each branch must have the information of the country it is situated in.

Question 1:

Draw a complete entity relationship diagram with all identified many-to-many relationships resolved.

Assign appropriate relationship names and include documentation where necessary.