laudon Kenneth In what ways might it rprise softwa Pianning process might look i

Question

laudon Kenneth In what ways might it rprise softwa Pianning process might look ike if the re. Improving Decision Making: Using Database Software to Design a Customer System for Auto Sales Software skills: Database design, querying, reporting, and forms Business skills:Sales lead and customer analysis 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 adver tises in local newspapers and is also listed as an authorized dealer on the Subaru Web site and other major auto-buyer Web sites. The compan word-of-mouth reputation and name recognition and is a leading source of information for Subaru vehicles in the Halifax area. y benefits from a good local

Explanation / Answer

1. Requirement analysis:

Problem:

Ace Auto dealers wants to keep track of following information:

1. Customers visiting them and customer actually purchasing vehicles

2. Customer touch points which has produced maximum sales

3. Improve marketing using this data

Solution:

1. Record information regarding SalesRepresentative, Customer, VEHICLE and CustomerTouchPoints in database

2. Use Bi tools like Excel (Power Pivot) or Power BI or SSRS to create reports for analysing the data further

Benefits:

1. Excel tool is user firendly and charts and grids can be easily created as per requirement to analyze data

2. They can easily copy paste data for further computations

3. Reports can be generated easily and quickly

This solution will allow Ace to keep track of their customers, touch points and using that information they can find out where they need to focus to enhance their marketing strategies

Couple of business processes related to gathering customer information, bill payments etc will be changed from manual forms to feed data into database using tool

Database design:

CREATE TABLE SalesRepresentative(
   REPID INT IDENTITY PRIMARY KEY,
   NAME VARCHAR(100),
   ADDRESS VARCHAR(1000),
   DESIGNATION VARCHAR(100),
   NUMBEROFSALES INT
)

CREATE TABLE Customer(
   CUSTOMERID INT IDENTITY PRIMARY KEY,
   NAME VARCHAR(100),
   ADDRESS VARCHAR(500),
   PHONENUM VARCHAR(20),
   VISITDATE DATETIME,
   SOURCEID VARCHAR(500),
   VEHICLEID INT,
   PURCHASEDVEHICLE BIT
)

CREATE TABLE VEHICLE(
   VEHICLEID INT IDENTITY PRIMARY KEY,
   MAKE VARCHAR(100),
   MODEL VARCHAR(100)
)

CREATE TABLE CustomerTouchPoints(
   SOURCEID INT IDENTITY PRIMARY KEY,
   NAME VARCHAR(100)
)

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.