QUALITY IMPORTS 1221 Bendix Drive Invoice No: 00808 South Bend, IN 46628 Date: 06/19/81 Sold to: Name: Bill George Address 63345 Lincolnway East City: South Bend State: IN Zip: 46630 Telephone: (219)-233-9933 Sold by: Gary Newman Phone Extension: 209 Home Phone: 238-9030 Serial No: TY43768 Make: Toyota Model: Supra-SE Year: 1998 Color: White Extra Options Code Description Price R14 Stereo Radio and CD Player 310.00 Extended Warranty 300.00 Spoiler 1200.00 E01 $20 Trade-In: Year 1986 1992 Make Honda Toyota Model Accord Camry VIN# 86744522890 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 iv. Show the cardinality of each relationship