This project requires you to perform a systems analysis and then design a system solution using…

This project requires you to perform a systems analysis and then design a system solution using database software. Ace Auto Dealers specializes in selling new vehicles from Subaru. The company advertises in local newspapers and is listed as an authorized dealer on the Subaru Website and other major Web sites for auto buyers. The company benefits from a good local word of-mouth reputation and name recognition and is a leading source of information for Subaru vehicles in the Portland, Oregon, 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 information such as the prospective customer’s name, address, telephone number, date of visit, and make and model of the vehicle in which the customer is interested. The representative also asks where the prospect 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 does not believe it has enough information about its customers. It cannot easily determine which prospects have made auto purchases, nor can it identify which customer touch points have produced the greatest number of sales leads or actual 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?

Prepare a two-page systems analysis report, in APA format, detailing Ace’s problem and a system solution that can be implemented using PC database management software. Then use database software to develop a simple system solution. Your systems analysis report should include the following:

  • Description of the problem and its organizational and business impact.
  • Proposed solution, solution objectives, and solution feasibility.
  • Costs and benefits 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 the solution.
  • People, organization, and technology issues to be addressed by the solution, including any proposed changes in business processes.

Based on the requirements you have identified:

  • Prepare an entity relationship diagram which models your proposed design.
  • Write the SQL statements to create the database tables, relationships and populate each table with at least 10 records per table, where applicable.
  • Use Microsoft Access to create a database called Ace-Auto-Dealers.accdb using your SQL scripts.
  • Finally, 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 should have:
    • A minimum of 3 data input forms depending upon your database design
    • The following queries are required:
      • Which touch point generates the most sales leads? Least sales leads?
      • Which touch point generates the most purchases? Least purchases?
      • Which sales representative sells the most vehicles?
      • 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

You may choose to add more sophistication to your DBMS application, but you are not required to do so. While the more you do, the better your performance will be judged, it is better to do the basics right, than to develop a sophisticated DBMS application which does not work properly. In making your decision, please keep in mind the time available to complete the project, your relative experience with DBMS software, and your prior experience with Access’ advanced capabilities. You are not required to go beyond the basic application framework.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Online Academic Experts
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Management
It's the second time I use this service and it does not let me down. Work quality is so good for its price!
Customer 452985, December 3rd, 2021
Emergency Management
Overall, I think it's a great service. I have yet to submit the assignment, so I don't know what kind of grade I'll get. But customer service was excellent. Reviews were made and the assignment proofed for satisfaction.
Customer 453015, December 15th, 2021
Nursing
It was a very long paper, but she followed all the instructions, and she even finished the paper 5 days before the due date. Will write an essay with her again, thanks!
Customer 452967, November 27th, 2021
Human Resources Management (HRM)
Very well written and very impressed with this service!
Customer 453077, February 16th, 2022
Management
It was gotten well after time I needed to make needed additions, but it is something that did help me. I could not get the concept of ho to start such a project but now reading this, I was over thinking the project it seems.
Customer 452801, July 19th, 2021
Human Resources Management (HRM)
On time and as always a great service! This semester has been very time consuming a tough for my family so this service has not only been a life saver but helped me keep up my grades! If you are in a time crunch or need help, don't hesitate! They are worth it!
Customer 453077, April 4th, 2022
English 101
thank you for the excellent work
Customer 452883, October 29th, 2021
Nursing
Paper much better compared to the one prior revision request. References need to be no more than the past 5 years.
Customer 452547, July 20th, 2021
Psychology
quick and before due date/time.
Customer 453027, January 29th, 2022
Human Resources Management (HRM)
I finished the first deliverable of a project presentation but had no time to finish my second deliverable. The writer revamped my first deliverable and made it much more appealing! Not only was I impressed with the content but I was so grateful for the time they took to redo the background. I have been under a lot of pressure at work and at home so this has been a great service when I have had little time! I appreciate the detail and help! Always on time and always exceeding expectations!
Customer 453077, April 5th, 2022
Humanities
Thank youuuu
Customer 452729, May 30th, 2021
Criminal Justice
This has been the greatest help while I am recovering from an illness. Thank your team so much.
Customer 452671, May 2nd, 2021
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat
AllEscortAllEscort
Live ChatWhatsApp
AllEscort