ABC Shop has a number of departments. Each department is identified by the department code, department name and department phone number.

The shop also employs several employees. Each employee should work in one department. Each departmet can have many employees. The employee is identitied by number, employee name, salary and year of hire is recorded.

The shop has has supervisors. Each supervisor manages one department and each department should be managed by only one supervisor. Each Supervisor is identified by a unique ID$,$ name, email and phone number.

The shop has many customers $.$A customer must buy from exactly one employee and employee may sell to many customers.Each customer is identified by number, name and city.

An employee may sells many products. A product can be sold by many employees. Each product has a product number, product name and unit price.

With reference to the above scenario, answer the following questions:

Create an Entity$-$Relationship Diagram $($ERD$)$ showing the relevant entities, attributes, and relationships, including appropriate labels.

Generate the relational model of the corresponding ERD