Sunit Dhadra 12K
AVCE ICT
Gambino cleaning products salesman System Specification
Description of the proposed system
Description of the problem
A new system of calculating and reporting on cleaning products salesmen is to be designed and implemented. Cleaning products salesmen commission is based on a set of data which is the monthly sales of cleaning products sold by the salesmen.
Objectives
The new system must:
- Be automated as far as possible, needing no thorough knowledge of spreadsheets, databases or any other software in order to operate it.
- Have fitted controls to ensure precision and completeness of data input.
- Take into account commission payments from monthly sales.
- Print commission reports for each of the salesmen, and a summary report showing total paid to each salesman and overall total.
- Include an option to delete commission records previous to a given date so that the file does not increase for an indefinite period.
The proposed new system can be shown in a level 0 data flow diagram as follows:
A level 1 Data Flow Diagram of the proposed system is as follows:
User functions
- The Commissioning Salesman in the Sales Department will be responsible for entering all details of new cleaning products salesman and new products.
- An Accounts clerk will have special responsibility for the commission system.
- The Accounts clerk will enter each month the sales of each product, giving quantity sold and gross sales value (i.e. quantity X cover price).
- Every 6 months, the Accounts clerk will produce the Commission reports for each cleaning products salesman. This will show the commission that has been earned in the previous 6 months. A payment is then recorded and a cheque issued to each cleaning products salesman to whom commission is due, together with the Commission statement showing sales details, and the statement from the Accounts system the total amount due.
Database specification
Menu structure
The many functions of the Commission System will be accessed by means of a front-end menu, which will have the following structure.
