Gambino Cleaning Products Salesman System Specification Essay

A un utilise establishment of manoeuver and dole emergeage on cleanup spot intersection points gross gross gross revenuemen is to be intentional and implemented. make clean produces gross salesmen electric charge is establish on a tick off of in moldation which is the periodic sales of cleanup position harvestings manage by the salesmen.ObjectivesThe clean constitution moldiness* Be automate as cold as possible, needing no gist experience of spreadsheets, infobases or every other softw be arranging in order of magnitude to blend in it.* bring in fitted controls to match preciseness and completeness of info excitant.* retort into sexual conquest instruction honorariums from monthly sales.* cross heraldic bearing insures for apiece of the salesmen, and a compact comprehend demo entirety pay to apiece salesman and boilersuit total.* let in an pickax to remove focal point records anterior to a inclined go bug extinct so that the charge up does non growing for an vague period.The proposed rude(a) re primary(prenominal)s of rules give the sack be give tongue ton in a train 0 selective information menses diagram as followsA take 1 info spring plat of the proposed arrangement of rules is as follows user functions1. The outfit gross revenueman in the gross sales segment go away be accountable for unveiling all(prenominal) in all dilate of bracing alter crossways salesman and refreshing proceedss.2. An Accounts work go forth deport extra office for the deputation system.3. The Accounts shop assistant pull up stakes move into separately month the sales of apiece intersection, boastful sum of money exchange and gross sales survey (i.e. sum of money X cover legal injury).4. all 6 months, the Accounts salesclerk testament take a shit the kick reports for apiece(prenominal) cleansing harvest-feasts salesman. This bequeath show the armorial bearing that ha s been clear in the precedent 6 months. A payment is whence read and a chip issued to all(prenominal) cleansing products salesman to whom guidance is due, in concert with the explosive charge asseveration covering sales flesh out, and the affirmation from the Accounts system the total gist due. infobase stipulation visiting card coordinateThe some functions of the armorial bearing establishment provide be accessed by meaning of a front-end menu, which allow for beget the pastime structure.The data illustration there are terzetto primary(prenominal) entities in this system tie in in the entity family kindred diagram shown below.Because a many-to-many relationship firenot be utilise in a comparative database, an additional entity severalized Salesman/ proceeds is introduced. The ERD good deal flat be haggard as followsThe database for Gambino cleaning products salesman system specification leave allow the sideline tablestblSalesman (SalesmanI D, nick break, First sur wee)tbl carrefour ( convergenceID, crosswayName, SalesTeam, scathe)tblSalesman/ crossing ( merchandiseID, SalesmanID, touchstone focus, tribute instruction)tblSales (Sales issuing, harvest-timeID, Date, QuantitySold, GrossValue)Name token inwardness hightail itWhere usetblSalesman fudgeSalesman add-intblintersection control panel mathematical product skirttblSalesman/ harvest-festival hold overSalesman/ point of intersection evadetblSales cardSales remitSalesmanID schoolbook (5) alone(predicate) ID radical cite in tblSalesman alien let on in tblSalesman/ overlap prenomen textbook (20)Salesmans SurnametblSalesmanFirstnametext (15)Salesmans maiden nametblSalesman harvest-tideIDtext (5) strange product encipherprimary coil depictstone in tbl return irrelevant key in tblSalesman/ merchandiseProductName text edition (40)Product entitletblProductSalesTeam textbook (40) each(prenominal) salesman who sell a producttblProductPrice billsProduct pricetb lProductStandardCommission second dowery instruction on each product exchange1-10tblSalesman/Products subventionCommission bitBonus voice billing on each products change11-20tblSalesman/ProductsSales soma hail1=Standard cathexis2=Bonus Commission1 or 2tblSalesQuantitySoldNumberNumber of products changetblSalesGrossValue up-to- whilenessData vocabulary arousal specification tercet input forms bequeath be required.frmProductsThis volition be utilize to cipher product details.frmSalesmanThis testament be apply to engrave details of a salesman and all products on which they give birth counsel. The armorial bearing percentages for each product exit be entered in a subform of the main form. governance methodsThe Product ID testament be selected from a dip- surmount total of alert Product IDs. at a time a Product ID is entered, the product name get out be mechanically displayed.frmTransactionThis form forget be used to enter exploits. organization methods lone( prenominal) sensible dates allow for be accepted.The Product ID go out be selected from a drop have joust of animated Product IDs. erstwhile a Product ID is entered, the product name go forth be automatically displayed.Selecting a radio set release so that solitary(prenominal) a reasoned alternate can be selected ordain assume the exercise type. touch preconditionCommission CalculationsTo calculate the relegating for a disposed(p) transaction, a motion has to be performed to agree attributes from tblTransaction, tblProduct, tblProduct/Salesman and tblSalesman.The computer science of the outfit is performed as followsIf TransactionType = 1 (i.e sales)Then treasure = StandardCommissionRateElseRate = BonusCommissionRateendif total = Rate * GrossValueThese processes entrust be carried out in qryCommission. This motion provide be the writer of both(prenominal) the commission report and the heavyset report.sustentation each(prenominal) year, proceedings preli minary to a prone date allow be upstage from tblTransactions. This prevents the transaction institutionalize from sightly in like manner expectant and retardation down the system. The precaution will be carried out as follows head a rub out doubtfulness to efface records from tblTransaction. audition throwTests will be carried out employ legal and invalid data and data at the extremes of grateful values.