Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Programming Language Expert

This project requires you to perform a systems analysis and then plan a system solution by using database software. Ace Auto Dealers specializes in selling latest vehicles from Subaru. The company advertises in the local newspapers and is listed as an authorized dealer on Subaru Web site and other major Web sites for the auto buyers. The company advantages from a good local word- of- mouth reputation and name recognition and is a leading source of information for Subaru vehicles in Portland, Oregon, region. 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 information like the prospective customer’s name, telephone number, and address, date of visit, and make and model of the vehicle in that the customer is interested. The representative also asks where the vision heard about Ace— whether it was from a newspaper ad, the Web, or word of mouth— and this information is noted on the form also. If the customer decides to purchase an auto, the dealer fills out a bill of sale form.

Ace doesn’t believe it has enough information concerning its customers. It can’t easily determine which prospects have made auto purchases, nor can it discover which customer touch points have produced the greatest number of sales leads or real sales so it can focus advertising and marketing more on the channels that generate the most revenue. Are purchasers discovering Ace from newspaper ads, from word of mouth, or from the Web?

Make a two-page systems analysis report, in APA format, detailing Ace’s problem and a system solution which can be executed by using PC database management software. Then use database software to build up a simple system solution. Your systems analysis report must include the following:

- Description of the problem and its organizational and business impact.

- Proposed solution, solution objectives, as well as solution feasibility.

- Costs and advantages of the solution you have selected. The company has a PC with Internet access and the full suite of Microsoft Office desktop productivity tools.

- Information requirements to be addressed by solution.

- People, organization, and technology issues to be addressed through the solution, including any proposed changes in business processes.

Based on the requirements you have identified:

- Prepare an entity relationship diagram that models your proposed design.

- prepare out the SQL statements to make the database tables, relationships and populate each table with at least 10 records per table, where applicable.

- Use Microsoft Access to make a database called Ace-Auto-Dealers.accdb by using your SQL scripts.

- At last, use the database system you have created to generate data input forms, queries and reports that would be of most interest to management. The system is to support only the processing requirements described for the existing manual system.  You must have:

- A minimum of 3 data input forms depending upon your database design

- The following queries are required:

problem1. Which touch point generates the most sales leads? Least sales leads?

problem2. Which touch point generates the most purchases? Least purchases?

problem3. Which sales representative sells the most vehicles?

problem4. What is the best selling make of model?

The following reports are required:

Customer profile

- Leads by touch point including customer information

- Sales by touch point including customer and vehicle information

Programming Language, Programming

  • Category:- Programming Language
  • Reference No.:- M91038

Have any Question? 


Related Questions in Programming Language

1 loops the greatest and the least- write a program with a

1. Loops: The greatest and the least- Write a program with a loop that lets the user to enter a series of integers. The use should enter -99 to signal the end of the series. After all the numbers have been entered, the p ...

You must do this assignment correctly as described

You must do this assignment correctly as described below.  If you do not follow the directions or break the rules you will receive a 0 score. Simulation of checking tic-tac-toe board for wins by counting X and O in rows, ...

Programming assignment 1 grocery storethis assignment

Programming Assignment #1: Grocery Store This assignment attempts to serve as a refresher for concepts that I hope you learned in CS 122. In this assignment, you will be building a simple storefront for a small grocery s ...

Concurrent programming task ydetailsmany banking systems

CONCURRENT PROGRAMMING TASK YDETAILS Many banking systems allow multiple cardholders access a single account (e.g. a business account). The consequence of this is that is possible for more than one person to attempt to w ...

Assignmentyou will write a program that acts like a simple

Assignment You will write a program that acts like a simple calculator for binary numbers. You should read in a string of input that has the format: number operator number. Each of the numbers should be presented in two' ...

1 construct a markov algorithm that will reverse the order

1) Construct a Markov Algorithm that will reverse the order of an input string that consists of zero or more upper case letters. ABCDE should become EDCBA, AB should become BA, A should stay A, and A should stay A. NOTE: ...

Engineering programmingi need this now please accurate

Engineering programming I need this now please accurate answers and must be high rated Problem #1 Write a program that asks the user to input the number of miles and convert the miles to kilometers, and then print the ou ...

Write a program to test for the case of a math equation

Write a program to test for the case of a math equation entered via the keyboard using the SWITCH-CASE operator. Types of equations to test for: x + y  x / y   x * y and x - y. The program is to ask for the following: 1. ...

Pair programming phase 1talent agency user stories1 user

Pair Programming Phase 1 Talent Agency User Stories 1. User Story 1 As a head office administrator I want to be able to produce formatted output of all the information about our talent agencies so that I can easily incor ...

Object oriented system analysis and design1non-functional

Object Oriented System Analysis and Design 1. Non-Functional Requirements a) Analysis of NFRs Analyse the Case Study documents and determine the non-functional requirements (NFRs) or system quality attributes necessary t ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate