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...
-
Demand for an item is projected to be 100 units per month. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a. Determine tire EOQ. b. If the vendor is...
-
In Example 3.4.5, compute the probability that water demand X is greater than electric demand Y.
-
After observing a physical inventory, an auditor compared the physical inventory counts with the perpetual inventory records and noted apparent shortages that were materially larger than those found...
-
The Louisville City bus system engaged in the following transactions: 1. It issued $10,000,000 in 8 percent revenue bonds. It used the proceeds to acquire new buses. The bonds were issued at par. 2....
-
Develop an engaging and versatile format to communicate your personal classroom philosophy to diverse families and stakeholders. Embed student learning and behaviors in a collaborative manner...
-
If an amino acid is found at the exact same location in the alignment of two homologous proteins, that amino acid is said to be "absolutely conserved." An amino acid type can also be conserved at a...
-
What is the future value of $7,960 at the end of 7 periods at 8% compounded interest ?
-
British Sugar, part of Associated British Foods, provides sugar for the top brand names in sugar confectionery, chocolate confectionery, soft drinks and preserves, etc. The company has six factories...
-
You are employed as the accountant for Cars Ltd, a local garage which has a bodyshop. The bodyshop manager, Mr George, has contacted you saying that one of the companys present customers has offered...
-
Show the order in which the nodes in the tree are processed by 1. an inorder traversal of the tree. 2. a postorder traversal of the tree. 3. a preorder traversal of the tree. B tree D K J M N Q P R T...
-
A minimum heap has the following order property: The value of each element is less than or equal to the value of each of its children. What changes must be made in the heap operations given in this...
-
BY Ltd is considering carrying out a major programme of staff training. The training scheme will cost 100,000 and will be paid for immediately. It is expected to produce additional cash flows as...
-
Bob Carlton Golf Course estimates the following labor requirements for its services over the next two years: Quarter: 1 2 3 4 5 6 7 8 Demand (hours): 4400, 6400, 3200, 5200, 4400, 6400, 3700, 5000...
-
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....
-
Describe circumstances that might cause a client to understate assets such as cash and financial investments.
-
What prevents the person who opens incoming mail from being able to abstract cash collections from customers?
-
Select the best answer for each of the following situations and give reasons for your choice. a. You have been assigned to the year-end audit of a financial institution and are planning the timing of...
Study smarter with the SolutionInn App