Question: Team 4 is the part i need locations. Attributes o Customers can have multiple location are customer ID, location ID (which is unique only for

Team 4 is the part i needTeam 4 is the part i need locations. Attributes o Customers can

locations. Attributes o Customers can have multiple location are customer ID, location ID (which is unique only for each customer ID), address (street, city, state, zip code), telephone, and building size. Service eam 3 A security service is performed for a customer at one or more locations. Before services are performed, an estimate is prepared. Attributes of service are service ID (identi- fier), description, cost, coverage, and clearance required. Additional Business Rules . Team In addition to the classes outlined above, the follow- ing information will need to be stored and should be shown in the model. These may be classes, but they also reflect a relationship between more than one class: Estimates: date, amount, business consultant, services, customer Services performed: date, amount, technical consultant, services, customer In order to construct the class diagram, you may assume the following: A customer can have many con- sultants providing many services. We wish to track both actual services performed and services offered. Therefore, there should be two relationships between customer-service and consultant-one to show ser- vices performed and one to show services offered as part of the estimate. locations. Attributes o Customers can have multiple location are customer ID, location ID (which is unique only for each customer ID), address (street, city, state, zip code), telephone, and building size. Service eam 3 A security service is performed for a customer at one or more locations. Before services are performed, an estimate is prepared. Attributes of service are service ID (identi- fier), description, cost, coverage, and clearance required. Additional Business Rules . Team In addition to the classes outlined above, the follow- ing information will need to be stored and should be shown in the model. These may be classes, but they also reflect a relationship between more than one class: Estimates: date, amount, business consultant, services, customer Services performed: date, amount, technical consultant, services, customer In order to construct the class diagram, you may assume the following: A customer can have many con- sultants providing many services. We wish to track both actual services performed and services offered. Therefore, there should be two relationships between customer-service and consultant-one to show ser- vices performed and one to show services offered as part of the estimate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!