mis5208 - lab02 - sample solution - temple mis€¦ · mis 5208 – lab 02 edward s. ferrara...
TRANSCRIPT
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 1 of 8
1 Chapter31.1 Questions/Exercises
1) VerifythedatafromtheACL_Tutorial_Metaphorprojectforallofthetablesinthispartofthetutorial.
AcceptableCodesCommand:VERIFYFIELDSCARDNUMCREDLIMCUSTNOEXPDTFINCHGMINPYMTDUENEWBALPASTDUEAMTPMTDUEDTPREVBALRATESTMTDTERRORLIMIT10TOSCREENTable:MIS5208_LAB02--------------------------------------------------------------------------------0datavalidityerrorsdetectedCompanyDepartmentCommand:VERIFYFIELDSCARDNUMCREDLIMCUSTNOEXPDTFINCHGMINPYMTDUENEWBALPASTDUEAMTPMTDUEDTPREVBALRATESTMTDTERRORLIMIT10TOSCREENTable:MIS5208_LAB02--------------------------------------------------------------------------------0datavalidityerrorsdetectedEmployeesCommand:VERIFYFIELDSCARDNUMCREDLIMCUSTNOEXPDTFINCHGMINPYMTDUENEWBALPASTDUEAMTPMTDUEDTPREVBALRATESTMTDTERRORLIMIT10TOSCREENTable:MIS5208_LAB02--------------------------------------------------------------------------------0datavalidityerrorsdetectedUnacceptableCodesCommand:VERIFYFIELDSCARDNUMCREDLIMCUSTNOEXPDTFINCHGMINPYMTDUENEWBALPASTDUEAMTPMTDUEDTPREVBALRATESTMTDTERRORLIMIT10TOSCREENTable:MIS5208_LAB02--------------------------------------------------------------------------------0datavalidityerrorsdetected
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 2 of 8CreditCardTransactionsCommand:VERIFYFIELDSCARDNUMCREDLIMCUSTNOEXPDTFINCHGMINPYMTDUENEWBALPASTDUEAMTPMTDUEDTPREVBALRATESTMTDTERRORLIMIT10TOSCREENTable:MIS5208_LAB02--------------------------------------------------------------------------------0datavalidityerrorsdetected
2) ExtracttherecordswithaNEWBALvaluegreaterthan1000toanewtableforlateranalysis.Submittheresults.
ProducedwithACLby:ACLEducationalEdition-NotForCommercialUseCommand:COUNTIFNEWBAL>1000Table:MIS5208_LAB02Filter:NEWBAL>1000(65recordsmatched)IfCondition:NEWBAL>1000(65recordsmatched)--------------------------------------------------------------------------------65recordscounted
3) WhatisthedifferencebetweenthetotalnumberoftransactionsandthenumberoftransactionswithaNEWBALgreaterthan2000?Submittheresults?
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 3 of 8ProducedwithACLby:ACLEducationalEdition-NotForCommercialUseCommand:COUNTIFNEWBAL>2000Table:MIS5208_LAB02IfCondition:NEWBAL>2000(53recordsmatched)--------------------------------------------------------------------------------53recordscounted200records–53records=147
4) OfthecreditcardnumbersthathaveanewNEWBALvaluegreaterthan2000,howmanyhaveaPASTDUEAMTgreaterthanzero?Submittheresults.
ProducedwithACLby:ACLEducationalEdition-NotForCommercialUseCommand:COUNTIF(NEWBAL>2000)and(PASTDUEAMT>0)Table:MIS5208_LAB02
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 4 of 8IfCondition:(NEWBAL>2000)AND(PASTDUEAMT>0)(12recordsmatched)--------------------------------------------------------------------------------12recordscounted
5) ChecktheCredit_Card_metaphortableforallcardnumberswithazeroNEWBALvalue.Submittheresults.
ProducedwithACLby:ACLEducationalEdition-NotForCommercialUseCommand:COUNTIFNEWBAL=0Table:MIS5208_LAB02Filter:NEWBAL=0(16recordsmatched)IfCondition:NEWBAL=0(16recordsmatched)--------------------------------------------------------------------------------
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 5 of 816recordscounted
6) ChecktheCredit_Card_MetaphortableforallcardnumberswithanegativeNEWBALvalue.Submittheresults.
Command:COUNTIFNEWBAL<0Table:MIS5208_LAB02Filter:NEWBAL<0(27recordsmatched)IfCondition:NEWBAL<0(27recordsmatched)--------------------------------------------------------------------------------27recordscounted
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 6 of 8
7) Underthetermsofthecreditcardprogram,Metaphorcanavoidinterestchargesifemployeessubmittheirreceiptsontimetotheaccountingdepartment.Metaphorwantstounderstandhowmuchmoneyitlosesunnecessarilyfromfinancescharges.TotaltheFINCHGvaluethatisgreaterthan$10.00.Submittheresults.
ProducedwithACLby:ACLEducationalEdition-NotForCommercialUseCommand:TOTALFIELDSFINCHGTable:MIS5208_LAB02Filter:FINCHG>10(60recordsmatched)--------------------------------------------------------------------------------FINCHG3,780.21
8) Metaphorwantstoknowthetotalofallcurrentbalances.IntheCredit_Card_Metaphortable,totaltheNEWBALfield.Submittheresults.
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 7 of 8ProducedwithACLby:ACLEducationalEdition-NotForCommercialUseCommand:TOTALFIELDSNEWBALTable:MIS5208_LAB02--------------------------------------------------------------------------------NEWBAL286,315.79
9) Metaphorisconsideringreducingitsuppercreditlimit.Howmanycreditcardnumbershavecreditlimitsexceeding$10,000?Submittheresults.
Command:COUNTIFCREDLIM>10000.00Table:MIS5208_LAB02Filter:CREDLIM>10000.00(2recordsmatched)
MIS5208–Lab02EdwardS.FerraraFebruary09,2016Page 8 of 8IfCondition:CREDLIM>10000.00(2recordsmatched)--------------------------------------------------------------------------------2recordscounted