Introduction

MacroHard Inc. has been contracted by Business Forms Inc. (BFI) to design and build a database system that will provide them improved access to stock and customer sales information. The system is expected to consist of an easy to use interface that will assist the salespeople of BFI in the retrieval and manipulation of critical information. We at MacroHard Inc. have decided to designate this system BFI-001.

Hardware The system will be designed to run in BFI's regional offices on the existing IBM-PCs. Future hardware upgrades will be assumed to be to either newer IBM-PCs or Macintosh systems.

We are assuming that BFI will not change their current distribution system to such an extent that they will not be using PC or Macintosh style computers in the future.

Summary

Business Forms Incorporated (BFI) is a Canadian company based in Calgary, Alberta. The company sells business forms such as invoices, receipts, ordering forms, and sales contracts. The forms can be either of a general design, or custom designed for an individual business. They feel the need for a new software package that will ease operations in the regional offices and assist the salesmen. The package should do the following:

• edit the distribution office location
• allow the salesman to access customer names, locations, projected order size
• frequency of orders, product information
• allow the modification of customer orders and track discounts
• create a list of the present customers a salesman should visit on a given day, either to deliver product or to approach for new orders

The list should be ordered in such a way that it will represent an optimal sales route. BFI has requested that we use their existing customer and product databases.

It is expected by BFI that we will make the application user friendly, and protect data from accidental changes. We will do our best to comply.