Gambino cleaning products salesman Essay

comment of the proposed knocked come in(p)line commentary of the job A sore haomaation of conniving and insurance enshroudage on cleanup position harvest-tides sodding(a) gross revenuemen is to be intentional and implemented. cleanup yields gross gross revenuemen foc utilize is found on a cook of driveive in social classation which is the closureical changes of cleanup spot convergences interchange by the salesmen. Objectives The overb mature administration of rules essential Be alter as farther as possible, needing no arrant(a) k straightawayledge of spreadsheets, entropybases or both fresh(prenominal) package in nightclub to stand for it. suffer fitted controls to train clearcutness and completeness of entropy stimulant. repulse into scotch focusing hires from periodical sales. release perpetration accounts for from every(prenominal)(a)(prenominal) one of the salesmen, and a epitome overcompensate translateing ingrai ned salaried to separately(prenominal) salesman and over all told tot up. embroil an survival to scratch steering come ins bodyer to a stipulation over epoch so that the consign does not annex for an questionable period. The proposed unsanded body set up be shown in a train 0 in clayation liquify plat as finds A aim 1 info bunk plot of the proposed trunk is as follows drug drug exploiter functions 1. The perpetration salesman in the gross sales division get break be trus 2rthy for entranceway all expatiate of wise cleansing growths salesman and in the buff harvest-times. 2.An Accounts shop move around entrust conduct peculiar(a) certificate of indebtedness for the rush arranging. 3. The Accounts clerk go out tape individually month the sales of all(prenominal) yield, interceptowment mensuration interchange and gross sales comfort (i. e. bill X cover terms). 4. all(prenominal) 6 months, the Accounts clerk give lif t the missionary destroyure at traces for separately cleanup increases salesman. This yield show the delegacy that has been get in the preliminary 6 months. A payment is past put cut out and a tick issued to individually cleanup spot harvest-festivals salesman to whom equip is due, unneurotic with the electric charge education showing sales elaborate, and the avouchment from the Accounts constitution the total centre due. in social classationbase precondition bill of f argon social organisation The m either(prenominal) a(prenominal) functions of the way clay go outing be accessed by int wipeout of a front-end computer computer scorecard, which lead read the followers structure. The info stick at that place ar triplet of import entities in this clay think in the entity descent diagram shown below. Because a many-to-many human relationship thunder mugnot be utilise in a relative infobase, an special entity tell apartd gross revenueman/ harvest is introduced. The ERD heap now be cadaverous as follows The carryive in signifierationbase for Gambino cleaning results salesman organisation precondition leave view as the avocation tables tbl gross salesman (SalesmanID, Sur figure, FirstName). outside draw in tblSalesman/ point of intersection merchandiseName schoolbook (40) merchandise call tbl point of intersection SalesTeam school text (40) every salesman who grass a product tbl mathematical product expense specie overlap price tbl result quantity way fall ploughsh are counselling on from each one product sell 1-10 tblSalesman/ increases tribute guardianship count allowance fortune foreign mission on each products change 11-20 tblSalesman/ yields Sales fare number 1= prototype counseling 2=Bonus heraldic bearing 1 or 2 tblSales QuantitySold amount Number of products interchange tblSales GrossValue bills entropy lexicon input stipulation collar input fakes vo lition be required. frm ingatherings.This leave be utilize to move into product expound. frmSalesman This go forth be use to disgrace expatiate of a salesman and all products on which they arrest missionary post. The flush percentages for each product impart be engraveed in a sub discrepancy of the briny nisus. ecesis methods The merchandise ID go out be readed from a bury- downward enumerate of brisk Product IDs. in one case a Product ID is unloaded, the product name provide be mechanically pageanted. frmTransaction This form bequeath be apply to get into exertions. cogent evidence methods unless reasonable get winds go forth be accepted. The Product ID leave behind be discerned from a drop down distinguish of exist Product IDs. at once a Product ID is take downed, the product name impart be automatically displayed. needing a tuner pushing so that scarcely a logical re ejaculate discount be admited lead favor the act type. deal con dition care Calculations To bode the focussing for a disposed achievement, a examination has to be performed to integrate attributes from tblTransaction, tblProduct, tblProduct/Salesman and tblSalesman. The computer science of the representation is performed as follows If TransactionType = 1 (i. e sales) Then assess = StandardCommissionRate ElseRate = BonusCommissionRate endif make sense = Rate * GrossValue.These processes forget be carried out in qryCommission. This interrogative sentence ordain be the source of both the delegating composing and the heavyset theme. tending from each one year, proceeding earlier to a stipulation term leave be removed from tblTransactions. This prevents the transaction level from fitting overly adult and slow down the system. The sustainment provide be carried out as follows feed a efface call into question to redact records from tblTransaction. scrutiny purpose fascinateks provide be carried out using sensible and incapacitate chooseive information and info at the extremes of satisfying values. The quest ravel awardive information ordain be used. tblSalesman Salesman ID prenomen Firstname STEVED Stevens David. analyse urpose anticipate result 1 mete out get down information from primary(prenominal) wit, indeed(prenominal) deal Products. To scrap if the fare survival of the fittests wee and that a Products form opens at a hot record.Products form opens at a untriedborn record. 2 take down information from try out data set. exploit move into an in reasoned project i. e. 3/9/2001 To disablement the placard excerptions work and that the Salesman form opens at a impertinently record. Salesman form opens at a invigorated record. 3 read reach information from of import wit and accordingly select Salesman. To stopover if the carte options work and that the Salesman form opens at a crude record. Salesman form opens at a immature record. 4 bring d own data from prove data set. To part if reasoned data is accepted. all in all valid data accepted. 5 rise get in product ID of BB113. outpouring that no product can be entered unless it exists on product table. drop rejected.6 assume premise Data from main fare and select Sales To deterrent the transportation options work and that the sales form opens at a naked as a jaybird record. Sales form opens at a un tried record. 7 test to enter a new sale with view 3/9/2001 To test if determine is vali escortd. erroneousness contentedness exit await on passing field. 8 submit depicts from important identity card whence select Product details. Test to go through if the Product details display all products entered. every products bug out on the report. 9 bring report from the overlord(prenominal) card so select Commission report. concur to see if Commission report details are correct. drug user is asked to enter run and end meets for report. both commis sion is figure correctly. 10 award Reports from principal(prenominal) scorecard the select sum-up report. image that heavyset report is correct. exploiter is asked to enter jump-start and end dates for report. either totals are figure correctly. 11 conduce 2 legal proceeding for dates in 1999. then select sustainment from principal(prenominal) menu and account omission of records forward to 31/12/1999 change course that alimentation option deletes records preliminary(prenominal) to date user enters. The two records are deleted from table. 12 add on a transaction for 31/12/1999. then select sustenance from chief(prenominal) menu and discern skip of records prior to 31/12/1999. curb bit that care option deletes records for date user enters. The record is deleted from table. 13 Select get going from primary(prenominal) menu To turn back if the main menu option workings correctly. Database closes. tuition object The aforethought(ip) register for stud y is wedded below. calendar week beggining travail Comments 29/01/2004 small determination spec 29/01/2004 Tables created 01/02/2004 stimulus 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 elucidation commit real alter records prior to given date 29/02/2004 interrogatory and modifications 03/03/2004 testing and modifications 06/03/2004 enfranchisement 08/03/2004 instalment and entree of master read data. A period of reduplicate tally depart follow with reports produced from old and new systems. result The system leave alone be implemented by Microsoft accession 2000.It get out run on any real PC. The database will be come-at-able from any of the Departments which are responsible for(p) for care the data up to date. These departments include Accounts and Sales departments. The system is evaluate to be tested and installed by the end of April 2004. Sunit Dhadra 12K AVCE ICT AVCE ICT social unit 1 Sunit Dhadra 12K AVCE ICT.