Question

Prepare an entity-relationship diagram for the database in a following company: Holiday Travel Vehicles sells new...

Prepare an entity-relationship diagram for the database in a following company:

Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicle arrives at Holiday Travel Vehicles, a new vehicle record is created.

Included in a new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost.

When a customer arrives at Holiday Travel Vehicles, he or she 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 request dealer-installed options, they will be 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.

Based on these business rules in force at Holiday Travel Vehicle, draw an ERD and document the relationship with appropriate cardinality.

Include the attributes for each entity. Draw the entity-relationship diagram for this system with a software tool (Visio). OR www.lucidchart.com site choose educations and option ERD .

The goal is to draw a diagram that includes most of the major design issues. Your diagram should have at least Five OR Six entities, each of which has a single clear meaning.

Homework Answers

Answer #1

A SalesPerson can negotiate with multiple customer, when a deal finalised an invoice will be generated fior a single deal there will be a single invoice

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicles arrive at Holiday...
Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicles arrive at Holiday Travel Vehicles, 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 Holiday Travel Vehicles, 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...
Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicles arrive at Holiday...
Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicles arrive at Holiday Travel Vehicles, 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 Holiday Travel Vehicles, 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...
Question. Ashton Auto Place is a new auto dealer in the town where you can buy...
Question. Ashton Auto Place is a new auto dealer in the town where you can buy new as well as used cars of all makes. Ashton Auto Place uses computerized Transaction Processing System (TPS) to process all sales transactions. Whenever Salesperson sells a Car, the Salesperson enters sales data (which includes customer information, details of the car, and sales information) using the TPS. The system prints sales invoice for the customer, daily sales statement for each Salesperson. The Account Manager...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT