Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop an EER model for the following situation using the traditional EER notation. XYZ Security company XYZ hired you to design a database management system.

Develop an EER model for the following situation using the traditional EER notation.

XYZ Security company XYZ hired you to design a database management system. You have conducted interviews and came up with the following entities, attributes, and business rules: Consultants Consultants can be either business consultants or technical consultants. Business consultants are contacted by a business in order to 1- determine security needs and 2- provide an estimate for the actual services to be performed. Technical consultants perform services according to the specifications developed by the business consultants.

Business consultant attributes are: 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). Technical consultant attributes 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 Customers are businesses that need consulting services. Customer attributes 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.

Locations Customers can have multiple locations. Location attributes 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.

Services Security services are 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 entities outlined previously, the following 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: 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 In order to construct the EER diagram, 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 etablish.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions