Gofar Travel Vehicles sells new and used recreational vehicles. When new vehicles arrive at Gofar Travel...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Gofar Travel Vehicles sells new and used recreational vehicles. When new vehicles arrive at Gofar Travel Vehicles from the manufacturer, a new vehicle record is created. Included in the new vehicle record is the following information: vehicle identification number (VIN), name, model, year, name of manufacturer, and cost or amount paid to the manufacturer. When a customer arrives at Gofar Travel Vehicles, he/she works with a salesperson to discuss a vehicle purchase. The customer can purchase a new or used vehicle. On the new vehicle the customer can add options like a microwave, special lighting, fridge, stove, better seats etc. When the purchase has been agreed to, a sales invoice is completed by the salesperson. The invoice summarizes the details of the purchase. It will include all customer information, information on the vehicle being purchased and any options (if any), information on the trade-in vehicle and the trade-in dollar amount allowed (if a trade in exists). If the customer requests dealer-installed options, they will be listed on the invoice as well as the price. The invoice also summarizes the final price, plus any applicable taxes (7%) and license fees. The transaction concludes with a customer signature on the sales invoice. Customers are assigned a customer ID when they make their first purchase from Gofar Travel Vehicles. Name, address, and phone number are recorded for the customer. If there is a trade- in vehide it is described by a serial number, make, model, and year. Dealer installed options are described by an option code, description, cost from the manufacturer and selling price. Each invoice will list just one customer and one vehicle sold. It is rare but if a customer wants 2 vehicles then it requires two invoices be prepared. A person does not become a customer until they purchase a vehicle. Over time, a customer may purchase a number of vehicles from Gofar Travel Vehicles. Every invoice must be filled out by only one salesperson. A new salesperson may not have sold any vehicles, but experienced salespeople have sold many vehicles. A customer may decide to have no options added to the vehicle, or may choose to add many options. The optional equipment (stove, fridge, fire extinguisher) is stored in the warehouse. An option like a fire extinguisher can be installed on different types of vehicles. A customer may trade in only one vehicle toward the purchase of a new vehicle. The trade in vehicle may be sold later to another customer, who later trades it in on another Gofar. Travel Vehicle. The same vehicle over time can be sold several times. 1) Design the database to handle the above. There are assumptions to be made. For this case the selling price is the price the product sells for. There is no negotiating a lower price. This applies to options and the vehicle. 2) What changes to the design would you make if the price shown was a suggested price, but the webicle.could be sald for somother geootinted.pric MacBook Air Gofar Travel Vehicles sells new and used recreational vehicles. When new vehicles arrive at Gofar Travel Vehicles from the manufacturer, a new vehicle record is created. Included in the new vehicle record is the following information: vehicle identification number (VIN), name, model, year, name of manufacturer, and cost or amount paid to the manufacturer. When a customer arrives at Gofar Travel Vehicles, he/she works with a salesperson to discuss a vehicle purchase. The customer can purchase a new or used vehicle. On the new vehicle the customer can add options like a microwave, special lighting, fridge, stove, better seats etc. When the purchase has been agreed to, a sales invoice is completed by the salesperson. The invoice summarizes the details of the purchase. It will include all customer information, information on the vehicle being purchased and any options (if any), information on the trade-in vehicle and the trade-in dollar amount allowed (if a trade in exists). If the customer requests dealer-installed options, they will be listed on the invoice as well as the price. The invoice also summarizes the final price, plus any applicable taxes (7%) and license fees. The transaction concludes with a customer signature on the sales invoice. Customers are assigned a customer ID when they make their first purchase from Gofar Travel Vehicles. Name, address, and phone number are recorded for the customer. If there is a trade- in vehide it is described by a serial number, make, model, and year. Dealer installed options are described by an option code, description, cost from the manufacturer and selling price. Each invoice will list just one customer and one vehicle sold. It is rare but if a customer wants 2 vehicles then it requires two invoices be prepared. A person does not become a customer until they purchase a vehicle. Over time, a customer may purchase a number of vehicles from Gofar Travel Vehicles. Every invoice must be filled out by only one salesperson. A new salesperson may not have sold any vehicles, but experienced salespeople have sold many vehicles. A customer may decide to have no options added to the vehicle, or may choose to add many options. The optional equipment (stove, fridge, fire extinguisher) is stored in the warehouse. An option like a fire extinguisher can be installed on different types of vehicles. A customer may trade in only one vehicle toward the purchase of a new vehicle. The trade in vehicle may be sold later to another customer, who later trades it in on another Gofar. Travel Vehicle. The same vehicle over time can be sold several times. 1) Design the database to handle the above. There are assumptions to be made. For this case the selling price is the price the product sells for. There is no negotiating a lower price. This applies to options and the vehicle. 2) What changes to the design would you make if the price shown was a suggested price, but the webicle.could be sald for somother geootinted.pric MacBook Air
Expert Answer:
Answer rating: 100% (QA)
CUSTOMER Company PK CustomerID make OH PK Company D Name phone a... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
The following are the assumptions for the projected cash flow and profit or loss statements for 20X3 for Zinc Mining Inc.: Zinc will sell 176,900 metric tons of zinc at an average price of $2,180...
-
A mechanical engineering contractor has been using a large and complex C software system for over 12 years. There is no documentation for the system and the maintenance programmers have moved to a...
-
Fill in the blanks with the right option: The children, Select one: O a. studyed - stopped b. studied - stoped c. studyed-stoped Od studied stopped for a long time. They at midnight.
-
Two thousand kg of water, initially a saturated liquid at 150C, is heated in a closed, rigid tank to a final state where the pressure is 2.5 MPa. Determine the final temperature, in C. the volume of...
-
Suppose that x0 = 1, y0 = 0, xn = xn-1 + 2yn-1, and yn = xn-1 + yn-1 for n N. Prove that x2n - 2y2n = 1 for n N and xn/yn 2 as n
-
In each of these two examples, a different explanation was given for the terms 'revenue' and 'costs'. What is the difference between the two explanations given for 'revenue'? What is the difference...
-
XCBob, Inc. is an online motorcycle and ATV parts business from the owners home. XCBob entered into oral agreements with the defendant, Ed Tucker Distributers, for purchases of various materials to...
-
Equipment replacement decisions and performance evaluation. Bob Moody manages the Knoxville plant of George Manufacturing. He has been approached by a representative of Darda Engineering regarding...
-
Bank extends a revolving line of credit to Epstein Corp., secured by Epstein's inventory and receivables. Epstein has now filed bankruptcy. At all times during the 90 days preceding the filing the...
-
X rays with initial wavelength 0.0665 nm undergo Compton scattering. What is the longest wavelength found in the scattered x rays? At which scattering angle is this wavelength observed?
-
Construct MST for the given graph, using Prims and Kruskals algorithm. Take 'A' as start vertex for vertex oriented algorithm (Step by step solution is required) 22 20 B 10 2 6 11 H
-
What are the most common areas where there is financial waste within a landscape project?
-
6. Process Payroll - a) What do you click to process payroll? - b) If there are errors on a paycheck it can be _____ and /or __________ 7. Remit Payroll taxes a) Where in QBO do you go to process...
-
Under the Health and Safety at Work Act, an employer must. Select the correct answer. Provide a bright, cheerful place to work. Safeguard the safety and health of all employees. Give everyone their...
-
Looking at an account that preserves some of the money as well as growing some at a low rate, would be appropriate for which time horizon: Immediate Short-Term Intermediate-Term Long-Term
-
The fund's investments are selected by A fund is two products in one: 1. an investment 2. source of revenue for the company that created and runs the fund: ________________________ vary from fund to...
-
Circuit below represents structural design of 4 bits binary up counter Carry3 Cout A S Sum3 HA V Rst D Q B Cik Carry2 Count3 Cout S Sum2 HA V Rst D Q CIK A B Carry1 Count2 Cout S Sum1 D HA Rst CIK A...
-
A survey of 70 college freshmen asked whether students planned to take biology, chemistry, or physics during their first year. Use the diagram to answer each question. How many of the surveyed...
-
What is the importance of the declaration date, record date, and payment date in conjunction with corporate dividends?
-
Carters Produce has applied for a loan and has agreed to use its inventory to collateralize the loan. The company currently has an inventory balance of $289,000. The cost of goods sold for the past...
-
During 2011, Lang Merchandising Company purchased $20,000 of inventory on account. The company sold inventory on account that cost $15,000 for $22,500. Cash payments on accounts payable were $12,500....
-
How might planning in a not-for-profit organization such as the World Wildlife Fund differ from planning in a for-profit organization such as Airbnb?
-
Provide examples of the sources of data a residential solar panel company might gather when engaging in environmental scanning. Exhibit 8-6 may be helpful when answering this question.
-
What advantages and disadvantages does Johnson Controls OpenBlue platform have over companies looking to develop solutions on their own?
Study smarter with the SolutionInn App