Identify classes described in the preceding scenario

Assignment Help Database Management System
Reference no: EM131150898

Holiday Travel Vehicles sells new recreational vehi- cles and travel trailers. When new vehicles arrive at Holiday Travel Vehicles, a new vehicle record is cre- ated. Included in the new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost.

When a customer arrives at Holiday Travel Vehi- cles, 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 infor- mation on the purchased vehicle. If the customer requests dealer-installed options, they are 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 signa- ture on the sales invoice.

a. Identify the classes described in the preceding scenario (you should find six). Create CRC cards for each class.

Customers are assigned a customer ID when they make their first purchase from Holiday Travel Vehi- cles. Name, address, and 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 class. Place the attributes onto the CRC cards.

Each invoice lists just one customer. A person does not become a customer until he or she purchases a vehicle. Over time, a customer may purchase a num- ber of vehicles from Holiday Travel Vehicles.

Every invoice must be filled out by only one sales- person. A new salesperson might 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 Holiday Travel vehicle.

c. Based on the preceding business rules in force at Holiday Travel Vehicles and CRC cards, draw a class diagram and document the relationships with the appropriate multiplicities. Remember to update the CRC cards.

Reference no: EM131150898

Questions Cloud

Which assignments and discussions were most useful to you : Were there things that you wanted or expected to learn that were not covered? How do you think that you will or can use information from this class in your career as a public health professional?
Prepare a powerpoint presentation on cellular networks : Prepare a PowerPoint presentation on cellular networks.- There is no restriction to the content.
Method for removing a split window : In Excel, which of the following is NOT a method for removing a split window
What is the medial forebrain bundle : What is the medial forebrain bundle? Discuss the evidence for and against its involvement in reward. In addition, review the evidence showing that the brain's dopamine pathways are critically involved in pleasure and reward.
Identify classes described in the preceding scenario : Develop a list of attributes for each class. Place the attributes onto the CRC cards - Identify the classes described in the preceding scenario (you should find six). Create CRC cards for each class.
He customers requirements and maximize profit : The customer wants 500 gallons of wine and it must contain at least 100 gallons of A and be at least 45% B. The customer also specified that the wine have an alcohol content of at least 12%. Wine A contains 14% alcohol while wine B contains 10%. The ..
About how change and development efforts : Choose a company and write about how change and development efforts will improve the company. Define the issues to be addressed in the company and use OD concepts and theories to provide solutions for the identified issues.
What is the highest value objective function coefficient : Big BOOM Explosives Company produces customized blasting compounds for use in the mining industry. The two ingredients for these explosives are agent A and agent B. Big Bang just received an order for 1400 pounds of explosive. Is the optimal solution..
What skills and abilities are most critical to success : What skills and abilities are most critical to success in your specialization? What strengths do you already bring to this area?-

Reviews

Write a Review

Database Management System Questions & Answers

  Structure of a database

Graphs and trees provide you with ways to visualize data sets, and the opportunity to do analysis on the data (e.g., shortest path). Knowing the structure of a database enables you to choose a proper algorithm for searching for data within a datab..

  Distribution of resource consumption

Compute the activity rates for the Filling Orders and Product Support activity cost pools by filling - Distribution of resource consumption

  What are four oracle system processes that run for database

What is an Oracle Instance? What are the four Oracle system processes that must always be up and running for the database to be useable.

  A motor vehicle maintenance center wants to enhance its

write a 200- to 300-word short-answer response for the followinga motor vehicle maintenance center wants to improve its

  Implement a new learning management system

Its a lead a project that will implement a new learning management system for your university. You have two key tasks: Task 1: Investigate learning management software packages that are available through application service providers.

  Sketch dfsa for identifiers-contain only letters and digits

Sketch a DFSA for identifiers which contain only letters and digits, where identifier should have at least one letter, but it need not be first character.

  Create oracle database tables

Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1. Make sure that entity and referential integrity are enforced by declaring a primary key for each table (these may be composite keys) and dec..

  Creating a database design in visio

Creating a Database Design in Visio-  Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors)

  Determine the total amount of supervisory wages

Determine the total amount of supervisory wages and factory utilities costs that would NOT be assigned to products.

  Create an er diagram for each of the descriptions

Create an ER diagram for each of the following descriptions: (a) Each company operates four departments, and each department belongs to one company. (b) Each department in part (a) employs one or more employees, and each employee works for one depa..

  Design diagram data warehouse using star schema

Assume that data warehouse consists of three dimensions time, customer, and cell phone plan, and two measures number of calls and cell phone bill. Sketch a schema diagram for above data warehouse using star schema.

  Describe data modeling tool such as erwin or rational rose

Consider the UNIVERSITY database described in Exercise Build the ER schema for this database using a data modeling tool such as ERwin or Rational Rose.

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