Submitted by: Submitted by BigEgo06
Views: 925
Words: 298
Pages: 2
Category: Business and Industry
Date Submitted: 10/26/2011 07:07 AM
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...