Imagine that your management has requested your assistance in designing a database.They give you the following facts:The database will store information on Employees, Job Title, Managers, Office Locations and Customers.Each employee reports to one managerEach manager supervises multiple employeesEach employee has one job titleMany employees can have the same job titleEach employee works at one office locationMany employees work at the same office locationEach office is managed by only one managerEach manager runs one officeEach employee serves many customersEach customer can work with many employeesConstruct an ERD for a database that will convey the information listed above. You can use the graphic program of your choice or one of suggested below, or even MS Excel. Regardless of how you create the diagram it must use standard ERD symbols and convey the following information:$1)$ Entities listed below and labeled accordingly:EmployeeManagerJobLocationCustomer$2)$ All of the relationships among the entities with properly identified types $(1-1,1-$many or many$-$to$-$many$)3)$ The primary key of each entity, labeled as PK$,$ or with a star$/$key sign, or underlined$\mathrm{.}4)$ At least three additional attributes of each entity, based on your understanding of the situation and facts about the entity. Make sure to include foreign keys used to link each pair of related tables together.