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

In this assignment you will write r functions for

In this assignment, you will write R functions for forecasting future values of a time series, and apply them to observations on numbers of deaths and maximum temperatures in Houston, Texas. Doing this will provide more ...

Assignmentthe csit racing club is a group that runs amateur

Assignment The CSIT Racing Club is a group that runs amateur car racing events throughout the US. In This project, write a program that will help the club determine the winner of their Fall Rally Race. You will need to d ...

A theater-seating chart is implemented as a two-dimensional

A theater-seating chart is implemented as a two-dimensional array of ticket prices, like this: ROW 6: 10 10 10 10 10 10 10 10 10 10 ROW 5: 10 10 10 20 20 20 20 10 10 10 ROW 4: 20 20 20 20 20 20 20 20 20 20 ROW 3: 20 20 3 ...

Assignmentmany applications impose rules for user passwords

Assignment Many applications impose rules for user passwords. Write a program that utilizes methods to check a user entered password ***** print out either "Valid" or "Invalid", based on the following rules: • Password * ...

First write a program that reads students names followed by

First... Write a program that reads students' names followed by their test scores. The program should output each student's name followed by the test scores and the relevant grade. It should also find and print the highe ...

Assignmenta student had to make a decision on how to be

Assignment A student had to make a decision on how to be paid. The student could accept a straight $10/hour or take 10 cents for the first hour, but have the hourly wage double each hour. That is, the student would make ...

Spreadsheet exercise1 run the spreadsheet program in your

Spreadsheet Exercise 1. Run the spreadsheet program in your computer and type the following:   A B C D E F 1 PAYROLL 2 XYZ COMPANY Employee Name Department Degree Salary Need Increase? 3 Nasser Mechanical Master 15000   ...

Question 1briefly explain these main programming paradigm

Question 1: Briefly explain these main programming paradigm (Logic, Functional, Object Oriented, Procedural, Imperative and Aspect-oriented), and for each of these paradigms name at least one language that can be used fo ...

Assignmenteagle airlines has contracted you to implement a

Assignment Eagle Airlines has contracted you to implement a basic airline ticketing system for passengers. Your program will allow the application's user to enter the information associated with each passenger. The ticke ...

Assignmentindent code and insert comments to document your

Assignment Indent code and insert comments to document your program. Program must be implemented and run as instructed. Source file and executable are placed in a folder. Define the class with the name BankAccount to sto ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen