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

  Case study- data breaches and regulatory requirements

Case Study: Data Breaches and Regulatory Requirements, The National Institute of Standards and Technology (NIST) provides an extensive amount of information, resources, and guidance on IT and information security topics

  Discuss advantages and disadvantages of xml in application

XML is one of the base technologies around which many other technologies are developing. Describe an application used at work (or online) that is based on XML and discuss the advantages and disadvantages of XML in this application.

  Online transactions versus a data warehouse optimized

Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data

  What stage of water watch would you put ellis in

This is REAL data. Ellis, KS is currently listed in a Stage 3 Water Emergency. Some argue that this is not reflective of the actual situation. What stage of water watch would you put Ellis in

  How can i read serialized objects from a database

How can I read and write serialized objects to and from a database? Can a Vector or a Hashtable be serialized and deserialized?

  Create an erd for this video store case

Create an ERD for this video store case. Turn in an ERD with appropriate relationship sentences. You can use drawing tools in MS Word or MS Visio to create your ERD. Make sure your relationship sentences are consistent with your relationship in yo..

  How would your answers to the two questions change

How would your answers to the two questions change, if at all, if your system did not support indexes with multiple-attribute search keys?

  How you can ensure the security of database your team plans

Consult with your team members on how you can ensure the security of the database your team plans to design. How will your team protect the data contained in the database?

  Design class of Student that has given Data members

Design a class of Student that has the attributes:· Data members: name, Mathematics score and Chemistry score - Declare an array of three elements.

  Basic component of a database system

Which of the following is not a basic component of a database system? Which of the following terms is synonymous with "tuple"

  Determine functional dependencies of table

Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table.

  Prepare database design using the data definition

Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

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