$1.(15$ points$)$ The Granite Sales Company

Create a Crow$$s Foot ERD using the following scenario. Granite Sales Company keeps data about departments and the employees working for the department. A department has many employees, and each employee works for only one department. Each department has data about the department name, mail box number, and office phone extension.

All employees have an employee number, the employee$$s name, and his$/$her address. Each employee must be one of the following three types $($cannot be two types simultaneously$)$: hourly, salaried, or contract. For hourly employees, hourly wages and target weekly hours are kept in the system. For all salaried employees, the yearly salary is recorded in the system. Some salaried employees are salespeople who can earn a commission in addition to their base salary. Salespeople$$s sales commission and profit commission are stored in the system. For contract employees, the beginning date and end date of their contracts are stored along with the billing rate for their hours.

A diagram is sufficient for the answer.