Location Customers can have multiple locations. Attributes of location are Customer ID (identifier), Location ID (which is unique only for each Customer ID), Address (which is composed of Street, City, State, and Zip Code), Telephone, and Building Size 17. Develop an EER model for the following situation using the traditional EER notation, the Visio notation, or the sub- types inside supertypes notation, as specified by your instructor Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with cor-Service porations to determine their security needs. You have A security service is performed for a customer at one or been hired by Wally and Henry to design a database management system to help them manage their business more locations. Before services are performed, an esti- mate is prepared. Attributes of service are Service ID ue to a recent increase in business, Fin and Finicky(identifier), Description, Cost, Coverage, and Clearance has decided to automate their client tracking system You and your team have done a preliminary analysis and come up with the following set of entities, attrib- utes, and business rules: Required Additional Business Rules In addition to the entities outlined previously, the fol- lowing 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: Consultant There are two types of consultants: business consult- ants 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 per- form services according to the specifications devel oped by the business consultants Estimates, which have characteristics of Date, Amount, Business Consultant, Services, and Customer .Services Performed, which have characteristics of Date, Amount, Technical Consultant, Services, and Customer Attributes of business consultant are the following Employee ID (identifier), Name, Address (which is com-the following: posed of Street, City, State, and Zip Code), Telephone, Date Of Birth, Age, Business Experience (which is com- posed of Number of Years, Type of Business [or busi- nesses], and Degrees Received) In order to construct the EER diagram, you may assume A customer can have many consultants providing many services. You wish to track both actual serv ices performed as well as services offered. Therefore there should be two relationships between cus- tomer, service, and consultant, one to show services performed and one to show services offered as part of the estimate. Attributes of technical consultant are the following Employee ID (identifier), Name, Address (which is com- posed of Street, City, State, and Zip Code), Telephone, Date Of Birth, Age, Technical Skills, and Degrees Received. Customer Customers are businesses that have asked for consulting services. Attributes of customer are Customer ID (iden- tifier), Company Name, Address (which is composed of Street, City, State, and Zip Code), Contact Name, Contact Title, Contact Telephone, Business Type, and Number Of Employees