CBIS 3210 Final Exam Questions And
Answers
AddZCommandZButtonsZ-ZCORRECTZZANSWER-
Add,ZDelete,ZSave,ZGoZtoZPrevious,ZGoZtoZNext,ZGoZtoZFirst,ZGoZtoZLast
AfterZyouZhaveZEnforcedZReferentialZIntegrity,ZtheZfollowingZrulesZapplyZ-
ZCORRECTZZANSWER-
YouZcannotZenterZaZvalueZinZtheZforeignZkeyZfieldZofZaZrelatedZtableZifZthatZvalueZdoesn'tZexi
stZinZtheZprimaryZkeyZfieldZofZtheZprimaryZtable
YouZcannotZdeleteZaZrecordZfromZaZprimaryZtableZifZmatchingZrecordsZexistZinZaZrelatedZtabl
e
YouZcannotZchangeZaZprimaryZkeyZvalueZinZtheZprimaryZtableZifZdoingZsoZwouldZcreateZorp
hanZrecords
AgileZ-ZCORRECTZZANSWER-
LettingZtheZprogrammingZteamZdoZwhateverZtheyZneedZtoZwithZnoZprojectZmanagement,Za
ndZnoZarchitecture,ZallowingZaZsolutionZtoZemerge,ZtheZprogrammersZwillZdoZallZtheZtestingZ
necessaryZwithZUnitZTests
AgileZModelingZ(AM)Z-ZCORRECTZZANSWER-
AZguidingZphilosophyZinZwhichZonlyZmodelsZthatZareZnecessary,ZwithZaZvalidZneedZandZatZt
heZrightZlevelZofZdetail,ZareZcreated
AlphaZTestingZ-ZCORRECTZZANSWER-
UserZtestingZofZaZcompletedZinformationZsystemZusingZsimulatedZdata
Analyze,ZDesign,ZandZImplementZOneZSmallerZPartZ-ZCORRECTZZANSWER-Result
AttributeZBZisZFunctionallyZDependentZonZAttributeZAZifZ-ZCORRECTZZANSWER-
ForZeachZvalueZofZattributeZAZthereZisZonlyZoneZcorrespondingZvalueZofZattributeZB
BetaZTestingZ-ZCORRECTZZANSWER-
UserZtestingZofZaZcompletedZinformationZsystemZusingZrealZdataZinZtheZrealZuserZenvironm
ent
, BriefZHistoryZofZDevelopmentZMethodologiesZ-ZCORRECTZZANSWER-1970ZWaterfall
1980ZV-Model
1985ZSpiralZModel
1991ZRAD
1998ZRUP
1999ZAGILE
BuildingZaZDatabaseZ-ZCORRECTZZANSWER-CreateZtheZblankZdatabase
CreateZrelationshipsZbetweenZtables
CreateZqueries
CreateZforms
CreateZreports
CodingZ-ZCORRECTZZANSWER-
PhysicalZdesignZspecificationsZareZturnedZintoZworkingZcomputerZcode
CodingZDeliverablesZ-ZCORRECTZZANSWER-Code
ProgramZdocumentation
CoffeeZClubZExample:ZwhereZhaveZweZdoneZsoZfar?Z-ZCORRECTZZANSWER-
NormalizationZtoZthirdZnormalZform
CreationZofZdatabase,Ztables,Zrelationships,ZandZqueries
CommonZFormsZofZNormalizationZ-ZCORRECTZZANSWER-
ThereZareZthreeZcommonZformsZofZnormalization:Z1st,Z2nd,ZandZ3rdZNormalZForm
CreateZandZPopulateZtheZTablesZ-ZCORRECTZZANSWER-
AddZfieldZname,ZprimaryZkey(s),ZdataZtype,Zdescription,ZandZsizeZinZtheZDesignZView
AddZrecordsZtoZpopulateZtheZtableZinZtheZDatasheetZView
CreateZComplexZQueriesZ-ZCORRECTZZANSWER-
Let'sZnowZbuildZaZqueryZthatZshowsZtheZtotalZsalesZperZcoffeeZnameZforZtheZCoffeeZClubZco
mpanyZ-ZuseZofZtheZSUMZfunction
CreateZQueriesZ-ZCORRECTZZANSWER-
AZqueryZisZaZrequestZforZdataZorZinformationZfromZaZdatabaseZtableZorZcombinationZofZtable
s
QueriesZareZwrittenZinZStructuredZQueryZLanguageZ(SQL)
MSZAccessZallowsZtheZuseZofZaZQueryZWizardZtoZavoidZwritingZtheZSQLZstatementsZfromZs
cratch
CreateZQueriesZusingZQueryZWizardZ-ZCORRECTZZANSWER-ClickZonZtheZCreateZTab
MakeZmodificationsZtoZtheZqueryZusingZtheZQueryZDesignZViewZifZneeded
CreateZRelationshipsZBetweenZTablesZ-ZCORRECTZZANSWER-GoZtoZDatabaseZToolsZ
ClickZonZRelationships
Answers
AddZCommandZButtonsZ-ZCORRECTZZANSWER-
Add,ZDelete,ZSave,ZGoZtoZPrevious,ZGoZtoZNext,ZGoZtoZFirst,ZGoZtoZLast
AfterZyouZhaveZEnforcedZReferentialZIntegrity,ZtheZfollowingZrulesZapplyZ-
ZCORRECTZZANSWER-
YouZcannotZenterZaZvalueZinZtheZforeignZkeyZfieldZofZaZrelatedZtableZifZthatZvalueZdoesn'tZexi
stZinZtheZprimaryZkeyZfieldZofZtheZprimaryZtable
YouZcannotZdeleteZaZrecordZfromZaZprimaryZtableZifZmatchingZrecordsZexistZinZaZrelatedZtabl
e
YouZcannotZchangeZaZprimaryZkeyZvalueZinZtheZprimaryZtableZifZdoingZsoZwouldZcreateZorp
hanZrecords
AgileZ-ZCORRECTZZANSWER-
LettingZtheZprogrammingZteamZdoZwhateverZtheyZneedZtoZwithZnoZprojectZmanagement,Za
ndZnoZarchitecture,ZallowingZaZsolutionZtoZemerge,ZtheZprogrammersZwillZdoZallZtheZtestingZ
necessaryZwithZUnitZTests
AgileZModelingZ(AM)Z-ZCORRECTZZANSWER-
AZguidingZphilosophyZinZwhichZonlyZmodelsZthatZareZnecessary,ZwithZaZvalidZneedZandZatZt
heZrightZlevelZofZdetail,ZareZcreated
AlphaZTestingZ-ZCORRECTZZANSWER-
UserZtestingZofZaZcompletedZinformationZsystemZusingZsimulatedZdata
Analyze,ZDesign,ZandZImplementZOneZSmallerZPartZ-ZCORRECTZZANSWER-Result
AttributeZBZisZFunctionallyZDependentZonZAttributeZAZifZ-ZCORRECTZZANSWER-
ForZeachZvalueZofZattributeZAZthereZisZonlyZoneZcorrespondingZvalueZofZattributeZB
BetaZTestingZ-ZCORRECTZZANSWER-
UserZtestingZofZaZcompletedZinformationZsystemZusingZrealZdataZinZtheZrealZuserZenvironm
ent
, BriefZHistoryZofZDevelopmentZMethodologiesZ-ZCORRECTZZANSWER-1970ZWaterfall
1980ZV-Model
1985ZSpiralZModel
1991ZRAD
1998ZRUP
1999ZAGILE
BuildingZaZDatabaseZ-ZCORRECTZZANSWER-CreateZtheZblankZdatabase
CreateZrelationshipsZbetweenZtables
CreateZqueries
CreateZforms
CreateZreports
CodingZ-ZCORRECTZZANSWER-
PhysicalZdesignZspecificationsZareZturnedZintoZworkingZcomputerZcode
CodingZDeliverablesZ-ZCORRECTZZANSWER-Code
ProgramZdocumentation
CoffeeZClubZExample:ZwhereZhaveZweZdoneZsoZfar?Z-ZCORRECTZZANSWER-
NormalizationZtoZthirdZnormalZform
CreationZofZdatabase,Ztables,Zrelationships,ZandZqueries
CommonZFormsZofZNormalizationZ-ZCORRECTZZANSWER-
ThereZareZthreeZcommonZformsZofZnormalization:Z1st,Z2nd,ZandZ3rdZNormalZForm
CreateZandZPopulateZtheZTablesZ-ZCORRECTZZANSWER-
AddZfieldZname,ZprimaryZkey(s),ZdataZtype,Zdescription,ZandZsizeZinZtheZDesignZView
AddZrecordsZtoZpopulateZtheZtableZinZtheZDatasheetZView
CreateZComplexZQueriesZ-ZCORRECTZZANSWER-
Let'sZnowZbuildZaZqueryZthatZshowsZtheZtotalZsalesZperZcoffeeZnameZforZtheZCoffeeZClubZco
mpanyZ-ZuseZofZtheZSUMZfunction
CreateZQueriesZ-ZCORRECTZZANSWER-
AZqueryZisZaZrequestZforZdataZorZinformationZfromZaZdatabaseZtableZorZcombinationZofZtable
s
QueriesZareZwrittenZinZStructuredZQueryZLanguageZ(SQL)
MSZAccessZallowsZtheZuseZofZaZQueryZWizardZtoZavoidZwritingZtheZSQLZstatementsZfromZs
cratch
CreateZQueriesZusingZQueryZWizardZ-ZCORRECTZZANSWER-ClickZonZtheZCreateZTab
MakeZmodificationsZtoZtheZqueryZusingZtheZQueryZDesignZViewZifZneeded
CreateZRelationshipsZBetweenZTablesZ-ZCORRECTZZANSWER-GoZtoZDatabaseZToolsZ
ClickZonZRelationships