Wally Los Gatos and his partner Henry’s Chordate have formed a new limited partnership, Fin & Finicky Security Consultan
Posted: Fri May 20, 2022 5:27 pm
Wally Los Gatos and his partner Henry’s Chordate have formed a
new limited partnership, Fin & Finicky Security Consultants.
Fin & Finicky consults with corporations to determine their
security needs. You have been hired to design a database management
system to help them manage their business. Due to a recent increase
in business, Fin & Finicky 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:
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.
new limited partnership, Fin & Finicky Security Consultants.
Fin & Finicky consults with corporations to determine their
security needs. You have been hired to design a database management
system to help them manage their business. Due to a recent increase
in business, Fin & Finicky 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:
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.