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

  Identifies all the stakeholders relevant to the system

Analyse the Case Study documents and produce a Vision document for a software system to meet the needs identified in the Case Study. Make sure your Vision document.

  Assignment 32nbspdatabase notation is not consistent you

assignment 3.2nbspdatabase notation is not consistent. you have probably seen that already when you tried to create an

  Why this table not in first normal form (1nf) normalization

Why is this table NOT in First Normal Form (1NF) normalization? What can you do to put it in 1NF?

  Find all non-trivial dependencies

Compute the closure sets of R, find all non-trivial dependencies and what are the candidate keys of R?

  Synchronization between the database and the transaction log

A point of synchronization between the database and the transaction log is called a(n): An ACID transaction is one that is:

  Develop an erd for flyakite

Develop an ERD for FlyAKite

  Dml stands for

DML stands for

  Data dictionary serves as important data management tool

The data dictionary serves as an important data management tool by? assigning attributes to the data, maintaining data in updated form.

  Draw dfd for placing order based on the e-r diagram

Draw a DFD (Context and Level 1) for placing an order based on the E-R diagram shown here.

  Determine the functional dependencies

After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form.

  Sketch diagram for data warehouse of shop by star schema

Assume that data warehouse for video game shop consists of th three dimensions: time, player, and game, and two measures number of games played and price paid per game. Sketch schema diagram for data warehouse using the star schema.

  Draw a uml class diagram

Agencies typically keep the details of the employers they have dealt with, even when they have no current business with them.

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