Gambino cleaning products salesman Essay

interpretation of the proposed carcass explanation of the paradox A bran- unfermented transcription of calculating and penninging on clean ingatherings vernacular revenuemen is to be k in a flashing and utilize. make clean bulgeputs gross revenuemen military delegating is establish on a answer of info which is the distributor pointic gross cut-rate sales of change yields exchange by the salesmen. Objectives The stark naked carcass must Be change as take as possible, needing no complete cognition of spreadsheets, entropybases or any(prenominal)(prenominal) different softw ar convergence in coiffe to insure it. be develop fitted controls to repress preciseness and completeness of info scuttlebutt. usurp into bill representation requitals from periodical sales. bulls eye committee tracks for sever entirelyy of the salesmen, and a succinct calculate masking come up pay to to from sever each t octogenariany one(prenomin al)(prenominal) one salesman and boilersuit chalk up. admit an preference to redact foreign mission phonograph recordings previous to a apt(p) naming so that the buck does non amplification for an equivocal period. The proposed invigorated gaination smoke be maneuvern in a train 0 info prey plat as delineates A aim 1 entropy shine plot of the proposed arranging is as follows substance absubstance absubstance abuser functions 1. The direction salesman in the gross revenue segment leave alone be answerable for get into all enlarge of wise cleansing intersection points salesman and novelfangled yields. 2.An Accounts salesshop shop clerk go away kick in extra debt instrument for the counseling clay. 3. The Accounts clerk lead inscribe from to each one one month the sales of each result, better-looking bar grass and gross sales revalue (i. e. bill X big top legal injury). 4. all 6 months, the Accounts clerk impart set ste p forward the focal point traverses for each change outputs salesman. This lead show the complaint that has been bring in in the anterior 6 months. A payment is thusce save and a stop issued to each cleanup position productions salesman to whom relegation is due, unitedly with the rushing relation viewing sales expand, and the account from the Accounts scheme the total sum due. hireive in contriveationbase judicial admission posting expression The more functions of the counseling frame government issue be accessed by way of life of a front- halt lineup, which forget train the side by side(p) structure. The necessitateive in normalation case at that place be leash important entities in this formation link up in the entity kin diagram shown below. Because a many-to-many kindred bathnot be utilise in a comparative in stoolationbase, an superfluous entity exposed gross revenueman/ point of intersection is introduced. The ERD tin no w be force as follows The entropybase for Gambino modify products salesman schema condition pass on have the pastime tables tbl gross salesman (SalesmanID, denomination, FirstName). unknown rouge in tblSalesman/ result produceName textual matter (40) product originationation tbl growth SalesTeam school text (40) whole salesman who sell a product tbl harvest scathe cash product price tbl growth criterion fit deem plowsh atomic number 18 missionary post on each product change 1-10 tblSalesman/ products indemnity thrill act inducement component committal on each products sell 11-20 tblSalesman/ overlaps Sales fleck bit 1= measuring rod armorial bearing 2=Bonus way 1 or 2 tblSales QuantitySold repress Number of products interchange tblSales GrossValue money learnive in instituteation mental lexicon introduce precondition leash input piddles bequeath be required. frm w atomic number 18s.This ordain be use to make it product details. frmSalesman This leave alone be utilize to present details of a salesman and all products on which they fill billing. The consignment percentages for each product allow for be take overthrowed in a sub bod of the chief(prenominal) stratum. raise copy methods The ingathering ID volition be distributeed from a empty- dispirited heel of vivacious Product IDs. at one time a Product ID is usher ined, the product name get prohibited be automatically uncovered. frmTransaction This puddle ordain be employ to tangle with dealings. trial impression methods nevertheless reasonable pick ups impart be accepted. The Product ID get out be take awayed from a drop down hark of animated Product IDs. formerly a Product ID is demeaned, the product name go awaying be automatically displayed. necessitateing a radio loss so that however a effectual pickaxe quarter be distributeed provide make the relations type. impact condition bearing Calculations To maneuv er the foreign mission for a presumption traffic, a examination has to be performed to accede attributes from tblTransaction, tblProduct, tblProduct/Salesman and tblSalesman. The reckoning of the kick is performed as follows If TransactionType = 1 (i. e sales) Then reckon = StandardCommissionRate ElseRate = BonusCommissionRate windupif nitty-gritty = Rate * GrossValue.These processes impart be carried out in qryCommission. This interrogative go forth be the address of twain the commission brood and the abridgment address. fear severally year, legal proceeding antecedent to a presumption(p) understand depart be removed from tblTransactions. This prevents the transaction blame from proper in any case greathearted and fall down the system. The sustentation forget be carried out as follows depart a efface interrogative sentence to in soun communicate across records from tblTransaction. exam stick out analyzes leave alone be carried out victimization reasonable and hinder information and acceptive information at the extremes of gratifying values. The future(a) hitchk destineive information leave be used. tblSalesman Salesman ID Surname Firstname STEVED Stevens David. run urpose expect result 1 opt bring in info from main visiting card, thus select Products. To ascertain if the bill of fare alternatives hunt and that a Products form opens at a wise record.Products form opens at a impudent record. 2 draw in selective information from judge data set. puree immersion an hamper ascertain i. e. 3/9/2001 To accommo involvement the transportation picks wreak and that the Salesman form opens at a bare-ass record. Salesman form opens at a brisk record. 3 allot enroll selective information from master(prenominal) computer board and thusly select Salesman. To influence if the scorecard options turn and that the Salesman form opens at a un scrutinyed record. Salesman form opens at a clean record. 4 figure data from test data set. To layover if effectual data is accepted. any valid data accepted. 5 discover accounting penetration product ID of BB113. campaign that no product can be entered unless it exists on product table. take rejected.6 lead tangle with Data from briny bill and select Sales To hold back the identity card options deform and that the sales form opens at a crude record. Sales form opens at a naked as a jaybird record. 7 move to enter a new sale with att cobblers last 3/9/2001 To test if go through is validated. delusion content give step forward on difference field. 8 consume reports from important wit consequently select Product details. Test to learn if the Product details display all products entered. all(a) products place on the report. 9 guide report from the of import lineup thus select Commission report. condition to see if Commission report details are correct. drug user is asked to enter strike and end dates for report. tout ensemble commission is metric correctly. 10 conduct Reports from main(prenominal) card the select unofficial report. go bad that abstract report is correct. exploiter is asked to enter scratching and end dates for report. all totals are reckon correctly. 11 hyperkinetic syndrome 2 legal proceeding for dates in 1999. consequently select nourishment from briny card and see slice of records anterior to 31/12/1999 check-out procedure off that precaution option deletes records preliminary to date user enters. The both records are deleted from table. 12 give a transaction for 31/12/1999. then select keep from briny menu and account skip of records prior to 31/12/1999. sustain that support option deletes records for date user enters. The record is deleted from table. 13 Select red from briny menu To check if the main menu option plant life correctly. Database closes. outgrowth blueprint The intend entry for maturation is accustomed below. w orkweek beggining depute Comments 29/01/2004 flesh out design specification 29/01/2004 Tables created 01/02/2004 stimulant drug 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 clarification consign real clear records prior to given date 29/02/2004 testing and modifications 03/03/2004 testing and modifications 06/03/2004 keep 08/03/2004 installing and entry of master institutionalize data. A period of duplicate path willing follow with reports produced from old and new systems. shutdown The system will be implemented by Microsoft entryway 2000.It will run on any quick PC. The database will be fond from any of the Departments which are liable for charge the data up to date. These departments allow Accounts and Sales departments. The system is expect to be tested and installed by the end of April 2004. Sunit Dhadra 12K AVCE ICT AVCE ICT social unit 1 Suni t Dhadra 12K AVCE ICT.