mga bro..kinsa nato diri nka agi na ani nga problem??
Draw a class diagram, showing the relevant classes, attributes, operations, and
relationships, for the following situation: Wally Los Gatos and his partner Henry
Chordate have formed a new limited partnership, Fin and Finicky Security
Consultants. Fin and Finicky consults with corporations to determine their
security needs. You have been hired by Wally and Henry to design a database
management system to help them manage their business.
Due to a recent increase in business, Fin and Finicky has decided to automate
their 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: 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 are the following: EmployeeID (identifier),
Name, Address (Street, City, State, Zip code), Telephone, DateofBirth, Age,
Business Experience [Number of years, Type of business (or businesses)],
Degrees Received
Attributes of technical consultant are the following: EmployeeID (identifier),
Name, Address (Street, City, State, Zip code), Telephone, DateofBirth, Age,
Technical Skills, Degrees Received.
Customer
Customers are businesses that have asked for consulting services. Attributes of
customer are: CustomerID (identifier), Company name, Address (Street, City,
State, Zip code), ContactName, ContactTitle, ContactTelephone, BusinessType,
NumberOfEmployees.
Location
Customers can have multiple locations. Attributes of location are: CustomerID,
LocationID (which is unique only for each CustomerID), Address (Street, City,
State, Zip code), Telephone, BuildingSize.
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:
ServiceID (identifier), Description, Cost, Coverage, ClearanceRequired.
Additional Business Rules
In addition to the classes outlined previously, the following information will
need to be stored and should be shown in the model. These may be classes but
they also reflect a relationship between more than one class.
Estimates: Date, Amount, Business consultant, Services, Customer
Services Performed: Date, Amount, Technical Consultant, Services, Customer
In order to construct the class diagram, you may assume the following:
A customer can have many consultants providing many services. We 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.
Entity-Relationship Diagram -----Modern Systems analysis and design
ako bai.. ehehe
Reply With Quote
Posting Permissions
