Prepare a systems analysis report detailing ace''s problem

Assignment Help Database Management System
Reference no: EM13949772

Ace Auto Dealers specializes in selling new vehicles from Subaru. The company advertises in local newspapers and is also listed as an authorized dealer on the Subaru Web site and the major Web sites for auto buyers. The company benefits from good local word-of-mouth reputation and name recognition and is a leading source for Subaru vehicles in the Prince Edward Island area.

When a prospective customer enters the showroom, he or she is greeted by an Ace sales representative. The sales representative manually fills out a form with such information as the prospective customer's name, address, telephone number, date of visit, and model and make of vehicle in which he or she is interested. The representative also asks where the prospective buyer heard about Ace?whether it was from a newspaper ad, the Web, or word of mouth and this information is also noted on the form.

If the customer decides to purchase an auto, the dealer fills out a bill of sale form, listing the vehicle identification number, vehicle make and model, colour, options selected, base price, total price, and date of the sale along with the purchaser's name, address, and telephone number. This form also shows the amount of the total purchase price that was financed. Both forms are filed in manual folders?one for sales prospects and another for actual purchases.

Ace does not feel it knows enough about its customers. It cannot easily identify repeat customers at its dealership or customers who have purchased a Subaru in the past from another dealer. It cannot easily determine which prospective buyers have made auto purchases or the percentage of those who have been converted into buyers. Nor can it identify which customer touchpoints have produced the greatest number of sales leads or actual sales so it can focus its advertising and marketing more on the channels that generate the most revenue. Are purchasers coming from newspaper ads, from word of mouth, or from the Web?

Additionally, the firm cannot tell whether its customers are more interested in no-frills cars or ones with luxury options. Prepare a systems analysis report detailing Ace's problem and a systems solution that can be implemented using PC database management software.

Reference no: EM13949772

Questions Cloud

Technical literature contains discussions of ways : The technical literature contains discussions of ways for using tethered kite-mounted wind turbine systems to harvest power from high-altitude winds, including jet streams at elevations from 6 to 15 kilometers (4 to 9 miles). Analysts estimate tha..
Turbines for utility-scale electrical generation : Identify sites in your state where wind turbines for utility-scale electrical generation are feasible but do not yet exist. Prepare a memorandum to an appropriate governing or corporate entity with your recommendations as to whether wind-turbine e..
Describe behavior that each activity driver will encourage : Describe the behavior that each activity driver will encourage, and evaluate the suitability of that behavior for the company's objective of creating a sustainable competitive advantage.
Medical applications of mems technology : Using the Internet, identify at least five medical applications of MEMS technology. In each case, explain the scientific and technological basis for the application, discuss the state of current research, and determine how close the technology is ..
Prepare a systems analysis report detailing ace''s problem : Additionally, the firm cannot tell whether its customers are more interested in no-frills cars or ones with luxury options. Prepare a systems analysis report detailing Ace's problem and a systems solution that can be implemented using PC database ..
Neglecting kinetic and potential energy effects : During the process, a pressure-relief valve allows nitrogen to escape, maintaining constant pressure in the tank. Neglecting kinetic and potential energy effects, and using the ideal gas model with constant specific heats evaluated at 350 K, deter..
Kinetic and potential energy : Liquid octane (C8H18) at 778F, 1 atm enters a combustion chamber operating at steady state and burns completely with 50% excess dry air entering at 1208F, 1 atm. The products exit at 10608F, 1 atm. Determine the rate of heat transfer between the c..
Determine the balanced reaction equation : Determine the balanced reaction equation. For the CO and SO2, determine the amount, in kmol per 106 kmol of combustion products (that  is, the  amount in parts per million).
Prepare the income statement for the business : Prepare a 10-column worksheet for the year ended 30 June 2016 - prepare the income statement for the business for the year ended 30 June 2016.

Reviews

Write a Review

Database Management System Questions & Answers

  What functionality does their proposed clause provide

In the Zhang & Huang (2007) article, the authors propose introducing a CLUSTER BY clause into SQL. What functionality does their proposed clause provide? How might your current or previous workplace use it in a SQL query

  Data-flow diagrams can be used to the physical system

Data-flow diagrams can be used to model both the physical and logical systems. Data models can be analyzed to identify possible inconsistencies that exist between two sets of diagrams or within a single DFD.

  Compares and contrasts design method for database management

The chief information officer (CIO) has asked you to choose any methodology to summarize the electronic data interchange (EDI), Compares and contrasts design methods for database management

  Convert this eer diagram to relational database schemas

Show an alternative design using the General notations for the attribute described in Problem 2 that uses only entity types (including weak entity types if needed) and relationship types.

  Construct an entity-relationship model for the database

Construct an entity-relationship (ER) model for the database. Make sure you include in your model details of entities, relationships, attributes, keys and limits in participation.

  Show attributes and include relationship and connectivity

Show all attributes and include relationship and connectivity. Convert all M:N relationships into entities. You are to use Crow's Foot notation showing all attributes for each entity and naming each relationship. Do not show M:N relationship, convert..

  Can you say that attribute b defnitely is or is not a key

State the defnition of a lossless-join decomposition with respect to this example. Answer this question concisely by writing a relational algebra equation involving R, R1, and R2.

  Functional dependency explain the difference between

explain the difference between functional dependencies that arise from equations and those that do

  Discuss the costs involved in implementing the database

Using the SafeAssign link in Blackboard to submit your report. Download and print out the FULL report and attach to the appendix at the back of your report. Assignments without the full SafeAssign report will NOT be marked.

  Create a form based on the reservations table

Open the data file Reservations17 19. Create a form based on the Reservations table. Use the form to Own folder, and then copy the navigate to the record with Reservations table

  Define er diagram and database implementation

Development of an ER Diagram and Database Implementation- Course Objectives: This assessment task focuses on the following course objective -ITECH1006

  Describe inventory application with keyboard events

(Inventory Application with Keyboard Events) Enhance the Inventory application that you developed in Tutorial 4 to prevent the user from entering input that is not a number. Use keyboard events to allow the user to press the number keys, the left and..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd