Case Study

Chapter 8

Pine Valley Case Study

1. A. What data will the Customer Profile Form need to collect? Using the guidelines presented in the chapter, design the Customer Profile Form. (See form on next page)

Data to collect will include:

* Customer Name

* Address

* Telephone/Fax

* Email Address

* Date completed (for discount purposes)

B. Using the guidelines presented in the chapter, design the Products by Demographics Summary Report. (See report on following pages)

C. Using the guidelines presented in the chapter, design the Customer Purchasing Frequency Report. (See report on following pages)

D. Modify the dialogue diagram presented in Figure 8-20 to reflect the addition of the Customer Profile Form, Products by Demographics Summary Report, and the Customer Purchasing Frequency Report. (See report on following pages)

-------------------------------------------------

CUSTOMER PROFILE FORM

-------------------------------------------------

CUSTOMER PROFILE FORM

New Customer Manage Profile

Existing Customer Add Profile

Customer ID

First Name Phone

Last Name Fax

Address Email

Date Completed

10% Discount Approval Code

-------------------------------------------------

PRODUCTS BY DEMOGRAHIC SUMMARY REPORT

-------------------------------------------------

PRODUCTS BY DEMOGRAHIC SUMMARY REPORT

As of: January 1, 2011 – October 1, 2011

Region: Northeast

Region: Northwest

Region: Central

Region: Northwest

Region: Southwest

-------------------------------------------------

CUSTOMER PURCHASING FREQUENCY REPORT

-------------------------------------------------

CUSTOMER PURCHASING FREQUENCY REPORT

0

Log-On Screen

System

0

Log-On Screen

System

-------------------------------------------------

Dialogue Diagram

-------------------------------------------------

Dialogue Diagram

1

Main Menu

0, System

1

Main Menu

0, System...