Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Make E-R diagram, thanks The following document is an invoice kept within Quality Imports. Information regarding the sale of a vehicle is recorded in this

Make E-R diagram, thanks image text in transcribed
image text in transcribed
The following document is an invoice kept within Quality Imports. Information regarding the sale of a vehicle is recorded in this invoice. Note that this document is not available to the cus- tomer because information on commission earned is reported here. QUALITY IMPORTS 1221 Bendix Drive South Bend, IN 46628 Invoice No: 00808 Date: 06/19/81 Sold to: Name: Address City: State: IN Telephone: Bill George 63345 Lincolnway East 63345 Lincolnway Ea South Bend Zip: 46630 (219)-233-9933 Sold by: Gary Newman Phone Extension: Home Phone: 209 238-9030 Serial No: TY43768 Make: Toyota Model: Supra-s Year: 1998 Color: White Extra Options Code R14 Description Stereo Radio and CD Player Edtended Warranty Spoiler Price 310.00 300.00 1200.00 B01 820 Trade-In: Year 1986 1992 Make Honda Toyota Model Accord Carry VIN# 86244522890 92H44689700 Allowance 1000.00 6500.00 $ 24, 810 Selling Price: $ 23,000 Added Options $ 1,810 Sub-Total: Discount (Negotiated): $ 310 Trade-In Allowance: $ 7,500 Total: Tax Listed Price: Commission (Total - List - Options): $ 17,000 $ 850 $ 14,000 $ 1, 190 Prepare an E-R diagram for the view for Quality Imports. In particular: i. Identify the appropriate entities, relationships and attributes ii. Include attributes in the E-R diagram. Account for all the data items (including calcu- lated values) and for all relationships that appear on each figure Indicate the primary key for each entity Show the cardinality of each relationship

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Accounting questions