• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Gambino cleaning products salesman System Specification.

Extracts from this document...


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 1. The Commissioning Salesman in the Sales Department will be responsible for entering all details of new cleaning products salesman and new products. ...read more.


The calculation of the commission is performed as follows: If TransactionType = 1 (i.e 'sales') ThenRate = StandardCommissionRate ElseRate = BonusCommissionRate endif Amount = Rate * GrossValue These processes will be carried out in qryCommission. This query will be the source of both the commission report and the summary report. Maintenance Each year, transactions prior to a given date will be removed from tblTransactions. This prevents the transaction file from becoming too large and slowing down the system. The maintenance will be carried out as follows: Run a Delete query to delete records from tblTransaction. Test Plan Tests will be carried out using valid and invalid data and data at the extremes of acceptable values. The following test data will be used. tblSalesman Salesman ID Surname Firstname STEVED Stevens David JAMED James David CORLES Corleone Santino BHOGG Bhogal Gurdeep GAMBC Gambino Carlo SCHWM Schwarznegger Maninder JONEF Jones Frank BIGPL Plant Big tblProduct Product ID Product Name Sales Team Price AA111 Mop David Stevens, David James, �2.00 AA112 Broom Frank Jones, Big Plant, Santino Corleone �2.50 AA113 Dustpan and Brush Santino Corleone, Maninder Schwarznegger, David James �1.00 AA114 Dettol David Stevens, Big Plant, Frank Jones �2.99 AA115 Mr Sheen Big Plant, David Stevens, Carlo Gambino �1.00 AA116 Vacuum Santino Corleone, Carlo Gambino, Big Plant �10.00 AA117 Mini-vac David Stevens, Big Plant, Frank Jones �6.99 AA118 Cleaning cloth (pack of 10) ...read more.


The two records are deleted from table. 12 Add a transaction for 31/12/1999. then select Maintenance from Main menu and identify deletion of records prior to 31/12/1999 Check that maintenance option deletes records for date user enters. The record is deleted from table. 13 Select Exit from Main menu To check if the main menu option works correctly. Database closes. Development Plan The planned schedule for development is given below. Week beggining Task Comments 29/01/2004 Detailed design spec 29/01/2004 Tables created 01/02/2004 Input forms created 15/02/2004 Queries and reports created Reports on products and salesman 21/02/2004 Standard commission report created 27/02/2004 Procedures for clearing file developed Clearing records prior to given date 29/02/2004 Testing and modifications 03/03/2004 Testing and modifications 06/03/2004 Documentation 08/03/2004 Installation and entry of master file data. A period of parallel running will follow with reports produced from old and new systems. Conclusion The system will be implemented by Microsoft Access 2000. It will run on any existing PC. The database will be accessible from any of the Departments which are responsible for keeping the data up to date. These departments include Accounts and Sales departments. The system is expected to be tested and installed by the end of April 2004. Sunit Dhadra 12K AVCE ICT AVCE ICT Unit 1 Sunit Dhadra 12K AVCE ICT ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. What is transaction processing?

    A field is an individual heading, which contains one piece of data for example in names and addresses a field heading would be FIRST NAME. In order to manipulate, process and present data, a set of tools will need to be used, such as:- Forms, which are use to input,

  2. Smart Card System

    Rivest, Adi Shamir, and Leonard Adleman in 1977. There are a variety of different cryptographic schemes and protocols based on the RSA algorithm in products all over the world. The RSAES-OAEP encryption scheme and the RSASSA-PSS signature scheme with appendix is recommended for new applications. 2.3.1 RSAES-OAEP (RSA Encryption Scheme - Optimal Asymmetric Encryption Padding)

  1. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    * The program has to be reliable. There will be no errors in the program due to coding which will could cause a fault within the program or make it crash causing lose of data. The system will have to be reliable in order for it to be effective otherwise the old system may be preferred by the user.

  2. Creating a computer system for Wooten Basset Rugby Club

    Each query will hold the attributes, MembershipNumber and name to identify players. Also a calculated field that sums the total number of respective statistics. I will these queries using SQL and the sum function. The sum function will sum all the values in a given field. SELECT tblPlayer.Name, tblPlayer.MembershipNumber, Sum([tblPlayers-Fixtures].Penalties)

  1. Introduction to spreadsheets

    It did not work the first time this is because I had spelt the name of the sheet wrong. After correcting this error it did take me to Sales\stock page. Products:- Test No. Purpose of test Method of testing and test data Expected result of test and result Testing the

  2. Stace & Dunphy (2001) identify five dilemmas of change

    list the actual norms that currently guide their behaviour and attitudes. This can be done for one or many cultural change groups, departments and divisions. Sometimes, it takes a little prodding and a few illustrations to get the process started, but once it begins, cultural change group members are quick to suggest many norms.

  1. The Global Positioning System

    There are several main users of GPS. The first is in the military. Being able to accurately calculate a platoons position on a map is a godsend, especially when the platoon is cold, wet and hungry. While not strictly military users, ramblers and those who enjoy orienteering still do the

  2. How audio products work.

    This means that you can erase and re-record songs on a Minidisk without having to worry about how they fit together. This is tremendously convenient compared to a cassette tape, where you have to basically re-record the entire tape if you want to change any of the songs on it.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work