You have been hired as a database analyst to develop a database for Kimco Insurance Agencies. The company is headed by a CEO within a County branch, who report to the Country Director. Three Directors work under the CEO heading the Customer Relations, Innovation hub and Marketing department. All workers in the departments are registered with the Human Resource department is outsourced but reports externally to the Continental managing director. Customers are entitled to Loan facilities as long as they are active and have 3 guarantors that are of majority age. Security covers are available upon annual subscriptions and claims are applicable within a month. Health, Education and accidental covers have basic and premium packages while general cover is available to all members. Perform the following tasks
1. Analyze the data and create an ER diagram to capture the all the entities and relations