Syazwan and his partner Sharmila have formed a new limited partnership, Syazwan & Sharmila Security Consultants (3SC). 3

[answerhappygod]

Syazwan and his partner Sharmila have formed a new limited partnership, Syazwan & Sharmila Security Consultants (3SC). 3SC consults with corporations to determine their security needs. Syazwan and Sharmila have hired you to design a database management system to help them manage their business. Due to a recent increase in business, 3SC has decided to automate its client tracking system. You and your team have done a preliminary analysis and come up with the following set of classes, attributes, and business rules :
Consultant
There are two types of consultants; (a) the business consultant determines security needs and estimates the actual services to be performed, and (2) the technical consultants perform services according to the specifications developed by the business consultants. Attributes of business consultant are the following: Employee ID (identifier), Name, Address (which is composed of Street, City, State, and Zip Code), Telephone, Date of Birth, Age, Business Experience (which is composed of Number of Years, Type of Business [or businesses], and Degrees Received). Attributes of technical consultant are the following: Employee ID (identifier), Name, Address (which is composed 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 (identifier), 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.
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.
Service
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 (identifier), Description, Cost, Coverage, and Clearance Required.
Additional Business Rules
In addition to the classes outlined previously, the following information will need to be stored in tables and shown in the model. These may be classes, but they also reflect a relationship between more than one class:
▪ 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
You may also assume the following:
A customer can have many consultants providing many services. You wish 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. From the case study given above, build Class Diagram.