The following document is an invoice kept within Quality Imports. Information regarding the sale of a...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 Sold to: Sold by: Name: Address Trade-In: Serial No: TY43768 Make: Toyota Extra Options: City: State: IN Telephone: Gary Newman Selling Price: Added Options Year 1986 1992 Sub-Total: Bill George 63345 Lincolnway East South Bend Discount (Negotiated): Trade-In Allowance: Zip: 46630 (219)-233-9933 Model: Supra-SE Year: 1998 Code R14 E01 $20 Make Honda Toyota $ 23,000 $ 1,810 Phone Extension: Home Phone: Description Stereo Radio and CD Player Extended Warranty Spoiler $ 310. $ 7,500 Invoice No: 00808 Date: 06/19/81 Total: Tax: Listed Price: Commission (Total - List - Options): 209 238-9030 Color: White Price 310.00 300.00 1200.00 Model VIN# Allowance Accord 86244522890 1000.00 Camry 92H44689200 6500.00 $ 24,810 $ 17,000 850 $ $14,000 $ 1,190 Prepare an E-R diagram for the view for Quality Imports. In particular: Identify the appropriate entities, relationships and attributes 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 i. ii. iii. iv. Indicate the primary key for each entity Show the cardinality of each relationship You can use the following assumptions when constructing the E-R diagram. - An invoice is for the sale of only ONE vehicle. - Multiple vehicles can be traded for the sale of the vehicle. In addition, options can be added to the vehicle. Commission earned is not determined by a fixed formula. Salesperson can take a lesser amount in order to close a sale. Quality Imports recognizes only one primary customer buying the vehicle. The price of each option is a negotiated amount between the salesperson and the customer. The allowance given by the dealership is also a negotiated amount. A sale is handled by only one salesperson. A customer can purchase as many cars as desired. You can assume that the name of the salesperson is unique. You can assume here for simplicity that customer name is unique. In order to make your design is robust, you have to consider the following situation: Jack bought a Toyota Camry and traded his Toyota Corolla Jill bought the Toyata Corolla that was in the lot 1 year later, Jill bought a Dodge Stratus and decides to trade the Toyoto Corolla The VIN # is pre-assigned to all cars in the USA. The Serial# is asigned by Quality Imports to its vehicle. It can be interpreted as an inventory type number. Therefore, a car sold and re- sold will be assigned to two different serial # because it is sold on different transactions. 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 Sold to: Sold by: Name: Address Trade-In: Serial No: TY43768 Make: Toyota Extra Options: City: State: IN Telephone: Gary Newman Selling Price: Added Options Year 1986 1992 Sub-Total: Bill George 63345 Lincolnway East South Bend Discount (Negotiated): Trade-In Allowance: Zip: 46630 (219)-233-9933 Model: Supra-SE Year: 1998 Code R14 E01 $20 Make Honda Toyota $ 23,000 $ 1,810 Phone Extension: Home Phone: Description Stereo Radio and CD Player Extended Warranty Spoiler $ 310. $ 7,500 Invoice No: 00808 Date: 06/19/81 Total: Tax: Listed Price: Commission (Total - List - Options): 209 238-9030 Color: White Price 310.00 300.00 1200.00 Model VIN# Allowance Accord 86244522890 1000.00 Camry 92H44689200 6500.00 $ 24,810 $ 17,000 850 $ $14,000 $ 1,190 Prepare an E-R diagram for the view for Quality Imports. In particular: Identify the appropriate entities, relationships and attributes 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 i. ii. iii. iv. Indicate the primary key for each entity Show the cardinality of each relationship You can use the following assumptions when constructing the E-R diagram. - An invoice is for the sale of only ONE vehicle. - Multiple vehicles can be traded for the sale of the vehicle. In addition, options can be added to the vehicle. Commission earned is not determined by a fixed formula. Salesperson can take a lesser amount in order to close a sale. Quality Imports recognizes only one primary customer buying the vehicle. The price of each option is a negotiated amount between the salesperson and the customer. The allowance given by the dealership is also a negotiated amount. A sale is handled by only one salesperson. A customer can purchase as many cars as desired. You can assume that the name of the salesperson is unique. You can assume here for simplicity that customer name is unique. In order to make your design is robust, you have to consider the following situation: Jack bought a Toyota Camry and traded his Toyota Corolla Jill bought the Toyata Corolla that was in the lot 1 year later, Jill bought a Dodge Stratus and decides to trade the Toyoto Corolla The VIN # is pre-assigned to all cars in the USA. The Serial# is asigned by Quality Imports to its vehicle. It can be interpreted as an inventory type number. Therefore, a car sold and re- sold will be assigned to two different serial # because it is sold on different transactions.
Expert Answer:
Answer rating: 100% (QA)
Based on the given information and assumptions we can create an EntityRelationship ER diagram for Quality Imports Heres the ER diagram Vehicle Custome... View the full answer
Related Book For
Accounting Information Systems basic concepts and current issues
ISBN: 978-0078025334
3rd edition
Authors: Robert Hurt
Posted Date:
Students also viewed these accounting questions
-
A juice manufacturer produces and sells two fruit beverages, cranapple and apple- berry. One gallon of cran-apple beverage is made from three quarts of cranberry juice and one quart of apple juice;...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
In Exercises find the values of x for which the series converges. n=0 (x + 1)n n!
-
The flow Q [m3/s] in an open channel can be predicted with the Manning equation (recall Sec. 8.2) Q = 1/n AcR2/3 S1/2 Where n = Manning roughness coefficient (a dimensionless number used to...
-
Consider three \((T-1) \times T\) matrices defined in (8.15) as follows: \(C_{1}=\) the first \((T-1)\) rows of \(\left(I_{T}-\bar{J}_{T} ight), C_{2}=\) the first-difference operator, \(C_{3}=\) the...
-
For the data set in Example 2, find the percentile that corresponds to $34,000. Data from Example 2 The tuition costs (in thousands of dollars) for 25 liberal arts colleges are listed. Use technology...
-
At the beginning of the current season on April 1, the ledger of Five Pines Pro Shop showed Cash $3,000; Merchandise Inventory $4,000; and Irene Tiger, Capital $7,000.These transactions occurred...
-
From your perspective, what are the three most important things you have learned thus far this semester? Completely discuss and be specific. How are you going to use this new knowledge in your day to...
-
Find the average temperature for a particular winter month in the region where your home is located. From your family's heating bills, estimate as best you can the amount of oil or gas consumed to...
-
As patient-centered care is more widely implemented, how do you envision health record practice evolving
-
What is outsourcing?
-
Indicate whether each of the following statements is true or false by writing T or F in the answer c olumn. A contract ratifi cation must apply to the entire contract.
-
Describe the relationship between production scheduling and inventory levels.
-
How is high-frequency trading similar to broker-dealer internalization? How is it different?
-
A written contract or agreement. a. administrator b. antenuptial or prenuptial a greement c. auctioneer d. executor e. guaranty f. memorandum g. parol evidence rule h. personal prope rty i. real...
-
Rachel deposits $90,000 into an account that pays 6% interest per year, compounded annually. Michael deposits $90,000 into an account that also pays 6% per year. But it is simple interest. Find the...
-
Smthe Co. makes furniture. The following data are taken from its production plans for the year. Required: 1. Determine the hazardous waste disposal cost per unit for chairs and for tables if costs...
-
Please match each item on the left with the most appropriate item on the right. 1. Autonomy of practice 2. Career mission statement 3. Jeff Skilling 4. Knowledge integration 5. Metaethics 6. Mintz...
-
a. What is the basic purpose of each business process discussed in this chapter (conversion, financing, human resources)? b. What are the similarities and differences between job costing and process...
-
a. In your own words, explain the similarities and differences between accounting and bookkeeping. b. What systems do accountants use to create and modify a chart of accounts? c. What internal...
-
Input the other metrics from the individual tax returns (e.g., income from wages and salaries, interest earned, and estimated tax payments). a. Review the dollars horizontally across the three years...
-
Input the IRS Schedules C from the 20132015 income tax returns into a spreadsheet. a. Add percent columns to the right of dollar column for each year. b. Calculate common-sized percentages in the...
-
Go to a business library or university librarian and locate RMA Annual Financial Statement Studies or a similar publication and locate convenience stores and comparable ratios (e.g., cost of goods...
Study smarter with the SolutionInn App