Q3. Suppose you are given the following requirements specification:
We have developed a new firm for providing security services to companies. We consult with companies to
determine their security needs. The information for our firm working is as follows:

There are two types of consultants: business consultants 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 business consultant includes 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:
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.
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. 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. 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.
In addition to the entities outlined previously, the following information will need to be stored and should be shown
in the model. These may be entities, but they also reflect a relationship between more than one entity:
• 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 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. Draw erd diagram