Creating use case to describe typical sales process

Assignment Help Database Management System
Reference no: EM1344622

Q1) Birzeit Travel Vehicles (BTV) sells new recreational vehicles and travel trailers. When new vehicles arrive at BTV, a new vehicle record is created. Included in the new vehicle record is a vehicle serial number, name, model, year, manufacturer, and base cost.

When a customer arrives at BTV, s/he works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed to, 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. If the customer requests dealer-installed options, they will he listed on the invoice as well. The invoice also summarizes the final negotiated price, plus any applicable taxes and license fees. The transaction concludes with a customer signature on the sales invoice.

A. identify the classes described in the above scenario (you should find six).
Customers are assigned a customer ID when they make their first purchase from BTV. Name, address, arid phone number are recorded for the customer. The trade-in vehicle is described by a serial number, make, model, and year. Dealer-installed options are described by an option code, description, and price.

B. Develop a list of attributes for each of the classes.

Each invoice will list just one customer. A person does not become a customer until they purchase a vehicle. Over time, a customer may purchase a number of vehicles from BTV.

Every invoice must be filled out by only one salesperson. A new salesperson may not have sold any vehicles, 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.

A customer may decide to have no options added to the vehicle, or may choose to add many options. An option may be listed on no invoices, or it may be listed on many invoices.

A customer may trade in no more than one vehicle on a purchase of a new vehicle. The trade-in vehicle may be sold to another customer, who later trades it in on another BTV.

C. Based on the above business rules in force at BTV,

D. Choose one of the more complex classes and create statechart diagram for it.

E. Create use case that describe a typical sales process. Then create a sequence diagram for the use case.

Reference no: EM1344622

Questions Cloud

Calculate the net present value of an item : Calculate the net present value of an item that has a buying value of $20,000, needs $1,000 maintenance at the end of each year except year 4.
Benefits of organized securities exchanges : What major benefits do corporations and investors enjoy due to the existence of organized security exchanges?
How long does it take to double your money : Explain how much will your collection be worth when you retire in 2058, assuming they appreciate at an annual rate of 6.1%
How long does it take for the last car to come : Do you agree with IBM's employment response to competition from software development contractors in India, like Wipro, that are expanding into IT consulting services? Why or why not.
Creating use case to describe typical sales process : Create use case to describe a typical sales process. Then make a sequence diagram for use case.
Explain how many days will he choose to stay in the hospital : If David's only illness this year results in an appendectomy, explain how many days will he choose to stay in the hospital.
Calculate terminal or horizon value of operations : Sony Company has never paid a dividend. The free cash flow is projected to be $40,000 & $50,000 for the next two years, & after 2nd year it is expected to grow at a constant rate of 6%.
Illustrate what monthly profit would she realize : Illustrate what monthly profit would she realize with that level of business during the next 3 years.
Characteristics of relational database management system : Describe the characteristics of a Relational Database Management System (RDBMS).

Reviews

Write a Review

Database Management System Questions & Answers

  Explain why data flow diagrams are developed in a hierarchy

Explain why data flow diagrams are developed in a hierarchy? What are the names of some levels in the hierarchy?

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Your task is to develop a database to support this activity

Your task is to develop a database to support this activity.Here is what you need to be able to provide Custom Auto Body in order to land your first consulting contract:

  Study and modify the postgresql source code

Write a Assignment to study and modify the PostgreSQL source code, with a focus on one of the core modules - the buffer manager

  Evaluate maximum rate at which data can be read from disk

What is the maximum rate at which data can be read from disk, assuming that we can only read data from one surface at a time? What is the average rotational latency?

  Characteristics of relational database management system

Describe the characteristics of a Relational Database Management System (RDBMS).

  Create a function

Create a function that returns the day of the week for a specified date. Create a trigger that displays the message "Emp table updated" when an update to the employee table increases the employee's basic salary.

  Describing the select statement

Data processing needs taking or receiving the data from a source and doing something with it. The same can be said about the transaction processing. When working along with a file, whether it be a fixed length.

  Create the following documents for the proposed system

MGMT321 Group Project: Create the following documents for the proposed system and deliver each SDLC documents by the end of each designated module, as shown below

  Draw an er diagram for database scenario

Draw an ER diagram for database scenario. Design a set of 3NF tables for your database scenario.

  Implement that entity as a database table with two subtypes

Implement that entity as a database table with two subtypes, Games and Movie.

  Describing the purpose of database an its functionality

Describing the purpose of database an its functionality, plus a detailed E-R diagram.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd