Develop an EER model for the following situation and make sure to list all assumptions. Jane Elliott and her business partner Nadine LaRue have formed a new limited partnership, Elliott LaRue Cybersecurity Consultants. Elliott and LaRue consults with corporations to determine their security needs. You have been hired by Jane and Nadine to design a database management system to help them manage their business.

Due to a recent increase in business, Elliott and LaRue has decided to automate its client tracking system. Your team have done a preliminary analysis to determine the following set of entities and business rules. As far as attributes, they are relying on your expertise to critically think through what they need and flesh out the attributes for each entity.

Consultantthere are two types of consultants: business and technical consultants. Business consultants are contacted by a business in order to first determine security needs and provide an estimate for the actual services to be performed. Technical consultants perform services according to the specifications developed by the business consultants. Attributes of consultant include employee ID (identifier), name, address (street, city, state, zip, etc.), tele numbers, date of birth, age, business experience (composed as number of years), type of business (or businesses), technical skills, degrees received, certifications, etc.

Customercustomers are businesses that have asked for consulting services. Attributes include customer ID (identifier), company name, address (street, city, state, zip code, etc.), contact name, contact title, contact tele, business type, number of employees, etc.

Locationcustomers can have multiple location. Attributes include customer ID (identifier), location ID (which is unique only for each customer ID), address (street, city, state, zip, etc.), tele, building size.

ServiceA security service is performed for a customer at one or more locations. Before services are performed, an estimate is prepared. Attributes of service include service ID (identifier), description, cost, coverage, clearance required, etc.

Additional Business Rulesthe following information will need to be stored to tables and should be shown in the model. These may be entities, but they also reflect a relationship between more than one entity:

o Estimates,whichhavecharacteristicsofdate,amount,businessconsultant,services,customer, etc.

o Servicesperformed,whichhavecharacteristicsofdata,amount,technicalconsultant,services, customer, etc.

A customer may have many consultants providing many services. Client wants to track both actual services performed as well as services offered. Therefore, there should be two relationships between customer, service, and consultant, one to show services performed and one to show services offered as part of the estimate.

In addition to the EER diagram, this client has requested you to develop a sample definition for each entity type, attribute, and relationship in the diagram.