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 (DRAW IN TABLE)