Created by Prof. Al Bento, University of Baltimore. Version 1.1 - February 1995.
VOICE's business was originally to sell electronic components, from which it derives its name: Volume Integrated Circuits Express. Presently VOICE is focused on selling computer products by mail. Its catalog includes items like DOS and Windows software, hardware add-on, and PCs. VOICE used to sell products by mail only. But computers and software change so fast that VOICE decided to develop an automated phone order system to receive and process orders and hired you to do the job.
You had the lowest bid, because you do not have that much experience in developing systems, and consequently won the contract. What follows are the results of interviews with VOICE management and other personnel.
If the customer decides to order the product, the sales representative assigns a customer number and enters the customer name, address, phone number, credit card number, date, item(s) number, description(s), quantity, unit price, shipping&handling, and totals into a request form. The ideal system would then transcribe this information to a customer file and a sales order file, and update the list (or file) of product quantity on-hand. Repeat customers should be able to either give their names or customer number and provide only changes to their existing information with VOICE. Repeat customers are key to VOICE's competitive ability because the cost of obtaining a new customer is twice that of maintaining existing customers. Obtaining credit-card approval of the customer charge to pay for the order is to be done after the order is entered.
VOICE's management would like to receive a daily summary sales report by product and a daily exception stockout report, both listing the product number, product description, unit price, quantity and total. They mentioned that percentages should be included. The first report if for them to know how much they are selling, and the second for them to know how much they may be losing on sales.
Given your limited experience with developing systems you secured the advice of Dr. Alben (a nationally recognized expert ) to be sure that you can do the job well. Dr. Alben advised you to develop a data flow diagram for the system based on the above description. Then you should define the files necessary to support the system -- design the data base. In addition you should design the order entry screen for the sales representative to use, and the format of the sales report by product. Finally, you should implement and test Data for testing the system was provided by VOICE -- see Appendix 1and 2. the system using an end-user data base language like Paradox, Access, etc. See also the specific instructions provided by your instructor.
|Catalog Number||description||unit price||QTY |
|14002||Paradox Win 4.5||135.67||35||17||30||25|
|23003||486 Pentium clone||2,459.00||30||20||20||17|
|E1237789||Smith||John S.||13 Monroe St.|
Tolltale, AL 32077
|A3247209||Lewis||Belle M.||256 Jones St.|
Laerne, CA 91000
|G9912567||Faria||Peter N.||780 Peace Blvd.|
Kyaville, LA 45120
|B5674320||Curtiss||Tony G.||1 Happy Ave.|
Heaven, CA 91006
|M0052713||Britt||Anne M.||1277 !st Ave.|
Nearby, MD 21004
|Order #||Date||Cust. Number||Cat. Number||Quantity|
Note: assume that when stock-out occurs the sales representative enters another order, in the next day, for the quantity available of the product, after talking with the customer.
This page is maintained by Al Bento who can be reached at abento@UBmail.ubalt.edu This page was last updated on August 27,1995. Although we will attempt to keep this information accurate, we can not guarantee the accuracy of the information provided.