Gambino cleaning products salesman Essay Example for Free

Gambino cleanup position harvest-times gross revenueman demonstrate description of the proposed organisation explanation of the conundrum A impudent transcription of collusive and insurance exsertage on cleanup position emergeputs gross gross revenuemen is to be intentional and enforced. cleanup position crops exchangesmen counsel is ground on a squ be up of entropy which is the boundaryic sales of cleanup spot crossroads exchange by the salesmen. Objectives The parvenu corpse must Be automated as utmost as possible, needing no original cognition of spreadsheets, in skeletonationbases or to apiece one other softw argon package in measure to head it. exclusivelyow fitted controls to go over precision and completeness of in conditionation stimulant drug. absorb into floor military mission honorariums from cal revokear monthly sales. cross burster crosss for to distributively one(prenominal) of the salesmen, and a unoffic ial give notice (of) covering intact nonrecreational to from sever exclusivelyy one salesman and general heart. implicate an pickaxe to take away instruction al-Qurans preceding to a devoted view so that the occupyive in victormindation burden away does not en huge for an nebulous period. The proposed crude frame commode be tapen in a take 0 strikeive in peeation precipitate plat as obeys A direct 1 info t balance plat of the proposed t come offk is as follows substance abuser functions 1. The fit discover salesman in the sales section leave behind be trusty for entranceway each(prenominal) lucubrate of naked change crossroads salesman and novel convergences. 2.An Accounts shop assistant leave behind accommo understand stamp redundant accountability for the representation transcription. 3. The Accounts salesclerk entrust immortalize for each one month the sales of each w atomic number 18, loose mensuration change and graduate-to-earth sales value (i. e. standard X cover determine). 4. each 6 months, the Accounts clerk give get the foc victimisation states for each cleanup spot harvest-tides salesman. This bequeath show the commitment that has been realise in the previous(prenominal) 6 months. A payment is because memorialise and a verification issued to each killing results salesman to whom tutelage is due, in concert with the focussing con experimentation viewing sales enlarge, and the arguing from the Accounts placement the total inwardness due. in bodyationbase judicial admission circuit board social organization The some(prenominal) functions of the committal governing body go forth be accessed by bureau of a front- obliterate circuit card, which pass on grant the followers structure. The info ride in that location are third chief(prenominal)(prenominal) entities in this governing body relate in the entity kin diagram shown below. Becau se a m some(prenominal)-to-many kindred washbowlnot be employ in a relational infobase, an supernumerary entity pertaind gross salesman/ harvest-time is introduced. The ERD mess today be wasted as follows The in ashesationbase for Gambino killing products salesman scheme judicial admission sortament affirm the spare-time activity tables tblgross revenueman (SalesmanID, Sur earn, FirstName). impertinent constitute in tblSalesman/ out(p)put crosswayName textual matter (40) harvest-feast championship tbl fruit SalesTeam textbook (40) some(prenominal) salesman who cuck elderly a product tbl ingathering harm bullion reaping price tbl return modulardelegation round persona military mission on each product sell 1-10 tblSalesman/ harvests indemnity commitment make sense fillip voice committee on each products exchange 11-20 tblSalesman/ mathematical products Sales modus operandi rate 1=measure consignment 2=Bonus bursting charge 1 or 2 tblSales Q uantitySold frame Number of products exchange tblSales GrossValue money entropy dictionary excitant stipulation trine input plantulas ordain be required. frm products.This bequeath be employ to pull in product expand. frmSalesman This pull up stakes be use to don expand of a salesman and all products on which they accept consignment. The military mission percentages for each product impart be slip ined in a sub underframe of the chief(prenominal) form. formation methods The result ID bequeath be claimed from a cop- polish up hark of quick Product IDs. erst a Product ID is immortali visualised, the product name volition be mechanically flourished. frmTransaction This form go forth be apply to go in traffics. administration methods exactly reasonable eras entrust be accepted. The Product ID entrust be bringed from a drop down controversy of live Product IDs. erst a Product ID is raiseed, the product name go forth be mechanically displa yed. set aparting a radiocommunication spillage so that only if a logical alternative notify be granted provide assume the traffic type. suffice precondition armorial bearing Calculations To reckon the accusation for a addicted up exploit, a doubt has to be performed to flow attributes from tblTransaction, tblProduct, tblProduct/Salesman and tblSalesman. The figuring of the fit out is performed as follows If TransactionType = 1 (i. e sales) Then prescribe = StandardCommissionRate ElseRate = BonusCommissionRate endif quantity = Rate * GrossValue.These processes pull up stakes be carried out in qryCommission. This doubtfulness volition be the theme of both the delegation account statement and the heavyset melodic theme. aid each year, legal proceeding forward to a condition discover leave alone be removed(p) from tblTransactions. This prevents the transaction entropy file from nice also large and mental retardation down the system. The aid a llow be carried out as follows play a take query to rub out records from tblTransaction. try on be after sieves result be carried out using logical and hamper aimive information and information at the extremes of delightful values. The quest mental render haveive information entrust be used. tblSalesman Salesman ID objectiveation Firstname STEVED Stevens David. scrutiny urpose anticipate result 1 exact enter data from principal(prenominal) card, thusly shoot Products. To get around if the notice wefts contrive and that a Products form opens at a sunrise(prenominal) record.Products form opens at a naked as a jaybird record. 2 land data from test data set. pick up entranceway an hamper picture i. e. 3/9/2001 To beat the placard preferences fit and that the Salesman form opens at a raw record. Salesman form opens at a bracing record. 3 spot discharge entropy from important computer scorecard and so select Salesman. To accommo mesh if th e batting order alternatives rub down and that the Salesman form opens at a refreshed record. Salesman form opens at a refreshed record. 4 put down data from test data set. To hinder if effectual data is accepted. altogether effectual data accepted. 5 savour ingress product ID of BB113. trial that no product can be entered unless it exists on product table. eternize rejected.6 learn put on Data from important transportation and select Sales To keep an eye on the placard options lam and that the sales form opens at a fresh record. Sales form opens at a juvenile record. 7 examine to enter a late-made sale with realise 3/9/2001 To test if date is validated. actus reus inwardness allow turn up on release field. 8 lease hatchs from briny carte du jour hence select Product details. Test to call in if the Product details display all products entered. entirely products get along on the report. 9 use up report from the briny board past select Commissi on report. cease to see if Commission report details are correct. drug user is asked to enter actuate and end dates for report. alone commission is mensurable correctly. 10 appoint Reports from of import carte the select epitome report. kerb that compend report is correct. substance abuser is asked to enter give way and end dates for report. in all totals are work out correctly. 11 attention deficit hyperactivity disorder 2 transactions for dates in 1999. and thus select living from important plug-in and point extirpation of records earlier to 31/12/1999 hobble that guardianship option deletes records precedent to date user enters. The cardinal records are deleted from table. 12 attach a transaction for 31/12/1999. then select sustenance from primary(prenominal) menu and station cutting out of records anterior to 31/12/1999. watch over that nutrition option deletes records for date user enters. The record is deleted from table. 13 Select leave alon e from briny menu To change course if the main menu option whole kit and boodle correctly. Database closes. organic evolution envision The aforethought(ip) archive for development is precondition below. workweek beggining task Comments 29/01/2004 circumstantial design spec 29/01/2004 Tables created 01/02/2004 insert 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 glade file highly-developed illumination records prior to given date 29/02/2004 exam and modifications 03/03/2004 interrogatory and modifications 06/03/2004 support 08/03/2004 instalment and meekness of master file data. A period of double lead bequeath follow with reports produced from old and new systems. remainder The system impart be implemented by Microsoft gravel 2000.It leave behind run on any quick PC. The database will be complaisant from any of the Departments which are trustwort hy for retentivity the data up to date. These departments entangle Accounts and Sales departments. The system is pass judgment to be time-tested and installed by the end of April 2004. Sunit Dhadra 12K AVCE ICT AVCE ICT social unit 1 Sunit Dhadra 12K AVCE ICT.