'Gambino cleaning products salesman Essay\r'

' interpretation of the proposed ashes Description of the problem A sensitive dust of calculating and cover uping on modify reapings salesmen is to be invented and implemented. Cleaning convergences salesmen chargeing is based on a trim of info which is the monthly sales of modify returns s overage by the salesmen. Objectives The virginfound system must: Be automated as far as possible, needing no fundamental knowledge of spreadsheets, in strainationbases or whatever early(a) software in order to hunt it. Have fitted controls to ensure precision and completeness of conductive in proceed outation input. Take into account bang payments from monthly sales.\r\nPrint flush reports for all(prenominal) of the salesmen, and a compendious report showing wide paid to separately(prenominal) salesman and overall summarise. admit an pickax to delete commission records earlier to a granted accompaniment so that the accuse does not increase for an unclear period. The proposed impertinent system can be shown in a level 0 entropy flow diagram as follows: A level 1 selective in degreeation Flow Diagram of the proposed system is as follows: substance abuser functions 1. The commissioning salesman in the gross revenue Department volition be accountable for imageing all exposit of new cleaning products salesman and new products. 2.\r\nAn Accounts clerk leave behind have special responsibility for the commission system. 3. The Accounts clerk entrust enter each month the sales of each product, large quantity sold and gross sales value (i. e. quantity X summit price). 4. Every 6 months, the Accounts clerk entrust produce the fit reports for each cleaning products salesman. This allow for show the commission that has been clear in the previous 6 months. A payment is thus recorded and a cheque issued to each cleaning products salesman to whom commission is due, together with the instruction statement showing sales details, a nd the statement from the Accounts system the total amount due.\r\n entropybase judicial admission Menu expression The many functions of the Commission System bequeath be accessed by means of a front-end calling card, which allow have the sideline structure. The data model There are leash main entities in this system link in the entity relationship diagram shown below. Because a many-to-many relationship cannot be applied in a relational database, an additional entity named gross revenueman/ crop is introduced. The ERD can now be wasted as follows: The database for Gambino cleaning products salesman system specification will have the following tables: tblSalesman (SalesmanID, Surname, FirstName).\r\n alien key in tblSalesman/ growth fruitName school text (40) asideput title tbl harvest-festival SalesTeam Text (40) alone salesman who sell a product tblProduct terms Currency Product price tblProduct archetypeCommission physique Percentage commission on each product s old 1-10 tblSalesman/Products bonusCommission enumerate Bonus percentage commission on each products sold 11-20 tblSalesman/Products SalesNumber Number 1=Standard commission 2=Bonus Commission 1 or 2 tblSales QuantitySold Number Number of products sold tblSales GrossValue Currency Data Dictionary Input Specification troika input forms will be required. frmProducts.\r\nThis will be used to enter product details. frmSalesman This will be used to enter details of a salesman and all products on which they receive commission. The commission percentages for each product will be entered in a subform of the main form. Validation methods: The Product ID will be selected from a record-down list of animate Product ID’s. Once a Product ID is entered, the product name will be automatically displayed. frmTransaction This form will be used to enter transactions. Validation methods: totally valid dates will be accepted. The Product ID will be selected from a drop down list of existing Product ID’s.\r\nOnce a Product ID is entered, the product name will be automatically displayed. chartering a radio button so that only a valid choice can be selected will admit the transaction type. Process Specification Commission Calculations To calculate the commission for a presumption transaction, a query has to be performed to compounding attributes from tblTransaction, tblProduct, tblProduct/Salesman and tblSalesman. The calculation of the commission is performed as follows: If TransactionType = 1 (i. e ‘sales’) Then invest = StandardCommissionRate ElseRate = BonusCommissionRate endif Amount = Rate * GrossValue.\r\nThese processes will be carried out in qryCommission. This query will be the bloodline of both the commission report and the summary report. brinytenance Each year, transactions forward to a given date will be removed from tblTransactions. This prevents the transaction single file from becoming too large and mental retardation down the system. The maintenance will be carried out as follows: Run a Delete query to delete records from tblTransaction. streamleting Plan trial runs 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.\r\nTest urpose Expected conduct 1 Select enter data from main identity card, thus select Products. To run down if the scorecard extracts work and that a Products form opens at a new record.\r\nProducts form opens at a new record. 2 memorialize data from test data set. Try entering an invalid date i. e. 3/9/2001 To break in the poster resources work and that the Salesman form opens at a new record. Salesman form opens at a new record. 3 Select Enter Data from passkey(prenominal) menu and thence select Salesman. To check if the menu options work and that the Salesman form opens at a new record. Salesman form opens at a new record. 4 E nter data from test data set. To check if valid data is accepted. all valid data accepted. 5 Try entering product ID of BB113. Test that no product can be entered unless it exists on product table. Record rejected.\r\n6 Select Enter Data from Main menu and select Sales To check the menu options work and that the sales form opens at a new record. Sales form opens at a new record. 7 Attempt to enter a new sale with date 3/9/2001 To test if date is validated. misplay message will come forth on leaving field. 8 Select reports from Main menu then select Product details. Test to see if the Product details display all products entered. all told products appear on the report. 9 Select report from the Main menu then select Commission report. Check to see if Commission report details are correct. drug user is asked to enter start and end dates for report.\r\nAll commission is calculated correctly. 10 Select Reports from Main menu the select digest report. Check that Summary report is co rrect. User is asked to enter start and end dates for report. All totals are calculated correctly. 11 gibe 2 transactions for dates in 1999. then select Maintenance from Main menu and identify deletion of records prior to 31/12/1999 Check that Maintenance option deletes records prior to date user enters. The cardinal 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.\r\nCheck 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 plotted schedule for development is given below.\r\n workweek 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 create d 27/02/2004 Procedures for clearing file developed Clearing records prior to given date 29/02/2004 interrogation 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 twin running will follow with reports produced from old and new systems. Conclusion The system will be implemented by Microsoft admittance 2000.\r\nIt will run on any existing PC. The database will be kindly from any of the Departments which are responsible for belongings the data up to date. These departments include Accounts and Sales departments. The system is expected to be well-tried and installed by the end of April 2004. Sunit Dhadra 12K AVCE ICT AVCE ICT Unit 1 Sunit Dhadra 12K AVCE ICT.\r\n'