Assignment
Company XYZ provides cell phone service along with cellphone products to its customers. The telesales division of XYZ takes orders for new cell phones from existing customers, but does not handle changes to cellphone service plans or the establishment of new accounts (new accounts must be established in person).
The order entry process for telesales begins when a customer calls the telesales headquarters. The customer provides his/her phone number and pin, which is entered into the computer by the salesperson. The computer pulls up the customer's account information and displays it for the salesperson.
The salesperson then obtains and enters the last four digits of the phone number associated with the equipment that the customer would like to upgrade. Based on what the salesperson entered, the computer accesses the enterprise database to provide pricing and financing options for phones offered by XYZ. The salesperson shares this information with the customer. The customer then tells the salesperson what model they would like to purchase as well as their preferred financing terms, and the salesperson makes the appropriate selection which results in the allocation of inventory when inventory is in-stock (phones not in-stock trigger an error routine).
The computer then displays on the screen of the salesperson a request for the billing information and shipping address from the customer (to obtain the required down payment or full purchase price of the phone). The salesperson obtains and enters credit card information, a billing address, and a shipping address from the customer. The computer contacts the credit card company, provides the billing information and purchase amount, and receives a confirmation number if the charges are approved (the associated error routine is not described here).
The salesperson provides the customer with an order verification number that the computer displays on the salesperson's computer screen. The computer then changes the inventory from allocated to sold and sends an electronic picking ticket to the warehouse.
1.1 Provide a table of entities and activities for XYZ's telesales order entry process.
Entity
|
Para
|
Activity
|
|
customer
|
1
|
1
|
Calls the telesales headquarters
|
salesperson
|
1
|
2
|
Request phone number and pin
|
customer
|
1
|
3
|
Provides his/her phone number and pin
|
salesperson
|
1
|
4
|
Enters customer's phone number and pin into the computcr
|
computer
|
1
|
5
|
Pulls up customer's account info
|
|
1
|
6
|
Displays customer's account info on salesperson's screen
|
salesperson
|
2
|
7
|
requests the last four digits of the phone number associated with the equipment that the customer would like to upgrade
|
customer
|
2
|
8
|
provides the last four digits of the phone number associated with the equipment that the customer would like to upgrade
|
salesperson
|
2
|
9
|
obtains and enters the last four digits of the phone number associated with the equipment that the customer would like to upgrade
|
Computer
|
2
|
10
|
Accesses the enterprise database
|
|
|
11
|
Provides pricing (from inventory master data) and financing options (from financing options master data)
|
Salesperson
|
2
|
12
|
Shares the information with the customer
|
customer
|
2
|
13
|
Tells the salesperson what they want to purchase and preferred financing terms
|
salesperson
|
2
|
14
|
Makes the selection which results in the allocation of inventory when inventory is in-stock
|
computer
|
3
|
15
|
Displays a request for billing info and shipping address
|
salesperson
|
3
|
16
|
requests credit card info, a billing address and a shipping address from the customer
|
customer
|
3
|
17
|
provides credit card info, a billing address and a shipping address from the customer
|
salesperson
|
3
|
18
|
obtains and enters credit card info, a billing address and a shipping address from the customer
|
computer
|
3
|
19
|
Contacts the credit card company
|
|
|
20
|
Provide credit card company with the billing info and purchase amount
|
|
|
21
|
Receives a confirmation number from the credit card company (if no error)
|
computer
|
4
|
22
|
Display an order verification number on salesperson's screen
|
salesperson
|
4
|
23
|
Provides the customer with an order verification number
|
computer
|
4
|
24
|
Changes the inventory from allocated to sold
|
|
4
|
25
|
Sends an electronic picking ticket to the warehouse
|
1.2 Partition your table of entities and activities and annotate it to designate the sub-processes for your level 0 logical DFD. Below, draw a level 0 logical DFD. (Note, for your level 0 logical DFD, you must use a separate data store for each type of information that is being accessed; do not use a single data store for the "enterprise database";.
1.3 Provide a systems flow chart for XYZ's telesales order entry process (Note: you can use a single data disk to designate the enterprise database;).