Question

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.

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