Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

Holiday Travel Vehicle (HTV) sells new recreational vehicles and travel trailers. When new vehicles arrive at HTV, 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 HTV, 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 HTV.

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 HTV. 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 HTV. 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.

(USE CASE DIAGRAM ATTACHED)

- Draw a class diagram for the case.

- In the use-case diagram attached, we may find a use case "Create New Vehicle Record". Draw a sequence diagram for the use case.

- In the use-case diagram attached, we may find a use case "Create Sales Transaction Record". Draw a sequence diagram for the use case.

Staff
Create New
Vehicle Record
Create Sales
Transaction
Record
Salesperson
Customer
expand button
Transcribed Image Text:Staff Create New Vehicle Record Create Sales Transaction Record Salesperson Customer
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education