Use-Case Diagram) Staff * Cougars Travel Vehicle Sales System Create New Vehicle Record Create Sales Transaction Record Salesperson Customer

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

A Cougars Real Estate Inc. (CRE) sells houses. People who want to sell their houses sign a contract with CRE and provide information on their house such as the current owner’s SSN, the owner’s name, the address of the house, the number of rooms, the number of baths, and the square feet of the house to a staff of CRE who is responsible for the management of house information. Then, the information is entered into the database by the staff of CRE. This information is kept in a database and a subset of this information is sent to the citywide multiple listing service used by all real estate agents.

CRE works with two types of potential buyers. Some buyers have an interest in one specific house. In this case, advising specialists of CRE (advising specialists don’t manage the house information) print information from its database, which the advising specialists use to help show the house to the buyer. Other buyers seek CRE’s advice in finding a house that is wider than 2000 sq ft. In this case, the buyer completes and submits a buyer information form to advising specialists of CRE, and the advising specialists use its information to search CRE’s database. The results of these searches are printed and used to help the real estate agent show houses to the buyer.

  • Using a drawing tool, draw a use-case diagram for the case

 

 Consider the following mini case and use-case diagram attached.

Cougars Travel Vehicle (CTV) sells new recreational vehicles and travel trailers. When new vehicles arrive at CTV, a new vehicle record is created. Included in the new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost.

When a customer arrives at CTV, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed upon, a sales invoice is completed by the salesperson. The invoice summarizes the purchase, including full customer information, information on the trade-in vehicle (if any), the trade-in allowance, and information on the purchased vehicle. The invoice also summarizes the final negotiated price, plus any applicable taxes and license fees.

If the customer requests dealer-installed options (simply options), they are listed on the invoice as well. A customer may decide to have no options added to the vehicle or may choose to add many options. Dealer-installed options are described by an option code, description, and price. Each invoice lists just one customer. An option may be listed on no invoices, or it may be listed on many invoices.

The trade-in vehicle is described by a serial number, make, model, and year. A customer may trade in no more than three vehicles on a purchase of a new vehicle. The trade-in vehicle may be sold to another customer who later trades it in on another CTV.

The transaction concludes with a customer's signature on the sales invoice. Customers are assigned a customer ID when they make their first purchase from CTV. Name, address, date of birth, age, and phone number are recorded by the customer. A person does not become a customer until he or she purchases a vehicle.

Over time, a customer may purchase at most five vehicles from CTV. Every invoice must be filled out by one salesperson. A new salesperson might not have sold any vehicle, but experienced salespeople have probably sold many vehicles. Each invoice only lists one new vehicle. If a new vehicle in inventory has not been sold, there will be no invoice for it. Once the vehicle sells, there will be just one invoice for it. 

 

  • Using a drawing tool, draw a class diagram for the case.

 

  • In the use-case diagram above, we may find a use cases Create New Vehicle Record. Draw a sequence diagram for the use case, using a drawing tool. 

 

 

  • In the use-case diagram above, we may find a use cases Create Sales Transaction Record. Using a drawing tool, draw a sequence diagram for the use case.

 

 

Use-Case Diagram)
Staff
*
Cougars Travel Vehicle Sales System
Create New
Vehicle Record
Create Sales
Transaction
Record
Salesperson
Customer
Transcribed Image Text:Use-Case Diagram) Staff * Cougars Travel Vehicle Sales System Create New Vehicle Record Create Sales Transaction Record Salesperson Customer
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education