Midterm Chapters 1-6 Database
Systems Design, Implementation and
Management (12e)
1. 3mVsm-
mCORRECTmANSWERm"ThreembasicmcharacteristicsmofmBigmDatamdatabases:mvolume,mvelocit
y,mandmvariety."
2. AdmHocmQuerym-mCORRECTmANSWERm"Amspur-of-the-momentmquery."
3. Aliasm-
mCORRECTmANSWERmAnmalternatemnamemgivenmtomamcolumnmormtableminmanymSQLmstateme
nt
4. AmericanmNationalmStandardsmInstitute(ANSI)m-
mCORRECTmANSWERmAmgroupmthatmacceptedmthemDBTGmrecommendationsmandmaugmente
dmdatabasemstandardsminm1975mthroughmitsmSPARCmcommittee.
5. AnalysisminmSDLCm-
mCORRECTmANSWERm"Usermrequirements,mexistingmsystemmevaluation,mandmlogicalmsyste
mmdesign"
6. AnalyticalmDatabasem-
mCORRECTmANSWERmAmdatabasemfocusedmprimarilymonmstoringmhistoricalmdatamandmbusin
essmmetricsmusedmformtacticalmormstrategicmdecisionmmaking.
7. ANSImSQLmStandardmConstraintsm-
mCORRECTmANSWERm"NotmNull,mUnique,mDefault,mandmCheck"
,8. Atomicitym-
mCORRECTmANSWERmThemtransactionmpropertymthatmrequiresmallmpartsmofmamtransactionmt
ombemtreatedmasmamsinglemindivisiblemlogicalmunitmofmworkmismcalledm_____________.mAllmp
artsmofmamtransactionmmustmbemcompletedmormthementiremtransactionmismaborted.
9. AssociativemEntitym-mCORRECTmANSWERmSamemasmCompositemEntity
10. "Associative,mbridge"m-
mCORRECTmANSWERmCompositemEntitymismsynonymousmwithmanm________________mentit
ymandmam____________mentity.
11. AtomicmAttributem-
mCORRECTmANSWERmAnm_______________m______________mcannotmbemfurthermsubdivi
dedmtomproducemmeaningfulmcomponents.mFormexamplemamperson'smlastmnamemattributemc
annotmbemmeaningfullymsubdivided.
12. Attributem-
mCORRECTmANSWERmAmcharacteristicmofmanmentitymormobject.mAnmattributemhasmamnamema
ndmdatamtype.
13. AttributemDomainm-
mCORRECTmANSWERmThem______________m_______________ismthemsetmofmvaluesmallowe
dminmanmattribute.
14. Authenticationm-
mCORRECTmANSWERmThemprocessmthemDBMSmusesmtomverifymthatmonlymregisteredmusersmac
cessmthemdatabase.mRequiresmamusermIDmandmpassword.
15. BigmDatam-
mCORRECTmANSWERm"Ammovementmtomfindmnewmandmbettermwaysmtommanagemlargemamo
untsmofmweb-
, generatedmdatamandmderivembusinessminsightmfrommit,mwhilemsimultaneouslymprovidingmhig
hmperformancemandmscalabilitymatmamreasonablemcost."
16. BinarymRelationshipm-
mCORRECTmANSWERm"AnmERmtermmformanmassociationm(relationship)mbetweenmtwomentitie
s.mFormexample,mPROFESSORmteachesmCLASS."
17. Bottom-upmDesignm-
mCORRECTmANSWERm"Amdesignmthatmstartsmbymidentifyingmthemdatamelementsmandmthemgro
upsmthemmtogetherminmdatamsets.mInmothermwords,mitmfirstmdefinesmattributes,mandmthenmgr
oupsmthemmtomformmentities."
18. Boundariesm-
mCORRECTmANSWERm"InmDBLC,mexternallymimposedmlimitsmtomthemsystem.mTheymcouldmals
ombemimposedmbymexistingmhardwaremandmsoftware."
19. Boyce-CoddmNormalmFormm(BCNF)m-
mCORRECTmANSWERmAmspecialmtypemofmthirdmnormalmformm(3NF)minmwhichmeverymdetermi
nantmismamcandidatemkeymismknownmasm____________________mform.
20. Boyce-Coddmnormalmformm(BCNF)m-
mCORRECTmANSWERmAmspecialmtypemofmthirdmnormalmformmwhichmeverymdeterminantmisma
mcandidatemkey.mAmtableminmBCNFmmustmbeminm3NF.
21. BusinessmIntelligencem(BI)m-
mCORRECTmANSWERm"Amcomprehensive,mcohesive,mandmintegratedmsetmofmtoolsmandmproc
essesmusedmtomcapture,mcollect,mintegrate,mstore,mandmanalyzemdatamwithmthempurposemofm
generatingmandmpresentingminformationmtomsupportmbusinessmdecisionmmaking."
22. BusinessmRulem-
mCORRECTmANSWERm"Amdescriptionmofmampolicy,mprocedure,mormprinciplemwithinmanmorgan
, ization.mFormexample,mampilotmcannotmbemonmdutymformmoremthanm10mhoursmduringmam24-
hourmperiod,mormamprofessormmaymteachmupmtomfourmclassesmduringmamsemester."
23. CandidatemKeym-
mCORRECTmANSWERm"Amminimalmsuperkey;mthatmis,mamkeymthatmdoesmnotmcontainmamsubse
tmofmattributesmthatmismitselfmamsuperkey."
24. Cardinalitym-
mCORRECTmANSWERmAmpropertymthatmassignsmamspecificmvaluemtomconnectivitymandmexpre
ssesmthemrangemofmallowedmentitymoccurrencesmassociatedmwithmamsinglemoccurrencemofmt
hemrelatedmentity.
25. CentralizedmDatabasem-mCORRECTmANSWERmAmdatabasemlocatedmatmamsinglemsite.
26. CentralizedmDesignm-
mCORRECTmANSWERmThemdesignmprocessmusedmwhenmtheremaremamrelativelymsmallmnumbe
rmofmobjectsmandmprocedures.mThemdesignmcanmbemcarriedmoutmandmrepresentedminmamfairl
ymsimplemdatabase.
27. ChenmNotationm-mCORRECTmANSWERmfavorsmconceptualmmodelingm(ERmmodel)
28. Classm-
mCORRECTmANSWERmAmcollectionmofmsimilarmobjectsmwithmsharedmstructurem(attributes)ma
ndmbehaviorm(methods).mAmclassmencapsulatesmanmobject'smdatamrepresentationmandmamm
ethod'smimplementation.mClassesmaremorganizedminmamclassmhierarchy.
29. ClassmDiagrammNotationm-
mCORRECTmANSWERmThemsetmofmsymbolsmusedminmthemcreationmofmclassmdiagramsminmUML
mobjectmmodeling.
Systems Design, Implementation and
Management (12e)
1. 3mVsm-
mCORRECTmANSWERm"ThreembasicmcharacteristicsmofmBigmDatamdatabases:mvolume,mvelocit
y,mandmvariety."
2. AdmHocmQuerym-mCORRECTmANSWERm"Amspur-of-the-momentmquery."
3. Aliasm-
mCORRECTmANSWERmAnmalternatemnamemgivenmtomamcolumnmormtableminmanymSQLmstateme
nt
4. AmericanmNationalmStandardsmInstitute(ANSI)m-
mCORRECTmANSWERmAmgroupmthatmacceptedmthemDBTGmrecommendationsmandmaugmente
dmdatabasemstandardsminm1975mthroughmitsmSPARCmcommittee.
5. AnalysisminmSDLCm-
mCORRECTmANSWERm"Usermrequirements,mexistingmsystemmevaluation,mandmlogicalmsyste
mmdesign"
6. AnalyticalmDatabasem-
mCORRECTmANSWERmAmdatabasemfocusedmprimarilymonmstoringmhistoricalmdatamandmbusin
essmmetricsmusedmformtacticalmormstrategicmdecisionmmaking.
7. ANSImSQLmStandardmConstraintsm-
mCORRECTmANSWERm"NotmNull,mUnique,mDefault,mandmCheck"
,8. Atomicitym-
mCORRECTmANSWERmThemtransactionmpropertymthatmrequiresmallmpartsmofmamtransactionmt
ombemtreatedmasmamsinglemindivisiblemlogicalmunitmofmworkmismcalledm_____________.mAllmp
artsmofmamtransactionmmustmbemcompletedmormthementiremtransactionmismaborted.
9. AssociativemEntitym-mCORRECTmANSWERmSamemasmCompositemEntity
10. "Associative,mbridge"m-
mCORRECTmANSWERmCompositemEntitymismsynonymousmwithmanm________________mentit
ymandmam____________mentity.
11. AtomicmAttributem-
mCORRECTmANSWERmAnm_______________m______________mcannotmbemfurthermsubdivi
dedmtomproducemmeaningfulmcomponents.mFormexamplemamperson'smlastmnamemattributemc
annotmbemmeaningfullymsubdivided.
12. Attributem-
mCORRECTmANSWERmAmcharacteristicmofmanmentitymormobject.mAnmattributemhasmamnamema
ndmdatamtype.
13. AttributemDomainm-
mCORRECTmANSWERmThem______________m_______________ismthemsetmofmvaluesmallowe
dminmanmattribute.
14. Authenticationm-
mCORRECTmANSWERmThemprocessmthemDBMSmusesmtomverifymthatmonlymregisteredmusersmac
cessmthemdatabase.mRequiresmamusermIDmandmpassword.
15. BigmDatam-
mCORRECTmANSWERm"Ammovementmtomfindmnewmandmbettermwaysmtommanagemlargemamo
untsmofmweb-
, generatedmdatamandmderivembusinessminsightmfrommit,mwhilemsimultaneouslymprovidingmhig
hmperformancemandmscalabilitymatmamreasonablemcost."
16. BinarymRelationshipm-
mCORRECTmANSWERm"AnmERmtermmformanmassociationm(relationship)mbetweenmtwomentitie
s.mFormexample,mPROFESSORmteachesmCLASS."
17. Bottom-upmDesignm-
mCORRECTmANSWERm"Amdesignmthatmstartsmbymidentifyingmthemdatamelementsmandmthemgro
upsmthemmtogetherminmdatamsets.mInmothermwords,mitmfirstmdefinesmattributes,mandmthenmgr
oupsmthemmtomformmentities."
18. Boundariesm-
mCORRECTmANSWERm"InmDBLC,mexternallymimposedmlimitsmtomthemsystem.mTheymcouldmals
ombemimposedmbymexistingmhardwaremandmsoftware."
19. Boyce-CoddmNormalmFormm(BCNF)m-
mCORRECTmANSWERmAmspecialmtypemofmthirdmnormalmformm(3NF)minmwhichmeverymdetermi
nantmismamcandidatemkeymismknownmasm____________________mform.
20. Boyce-Coddmnormalmformm(BCNF)m-
mCORRECTmANSWERmAmspecialmtypemofmthirdmnormalmformmwhichmeverymdeterminantmisma
mcandidatemkey.mAmtableminmBCNFmmustmbeminm3NF.
21. BusinessmIntelligencem(BI)m-
mCORRECTmANSWERm"Amcomprehensive,mcohesive,mandmintegratedmsetmofmtoolsmandmproc
essesmusedmtomcapture,mcollect,mintegrate,mstore,mandmanalyzemdatamwithmthempurposemofm
generatingmandmpresentingminformationmtomsupportmbusinessmdecisionmmaking."
22. BusinessmRulem-
mCORRECTmANSWERm"Amdescriptionmofmampolicy,mprocedure,mormprinciplemwithinmanmorgan
, ization.mFormexample,mampilotmcannotmbemonmdutymformmoremthanm10mhoursmduringmam24-
hourmperiod,mormamprofessormmaymteachmupmtomfourmclassesmduringmamsemester."
23. CandidatemKeym-
mCORRECTmANSWERm"Amminimalmsuperkey;mthatmis,mamkeymthatmdoesmnotmcontainmamsubse
tmofmattributesmthatmismitselfmamsuperkey."
24. Cardinalitym-
mCORRECTmANSWERmAmpropertymthatmassignsmamspecificmvaluemtomconnectivitymandmexpre
ssesmthemrangemofmallowedmentitymoccurrencesmassociatedmwithmamsinglemoccurrencemofmt
hemrelatedmentity.
25. CentralizedmDatabasem-mCORRECTmANSWERmAmdatabasemlocatedmatmamsinglemsite.
26. CentralizedmDesignm-
mCORRECTmANSWERmThemdesignmprocessmusedmwhenmtheremaremamrelativelymsmallmnumbe
rmofmobjectsmandmprocedures.mThemdesignmcanmbemcarriedmoutmandmrepresentedminmamfairl
ymsimplemdatabase.
27. ChenmNotationm-mCORRECTmANSWERmfavorsmconceptualmmodelingm(ERmmodel)
28. Classm-
mCORRECTmANSWERmAmcollectionmofmsimilarmobjectsmwithmsharedmstructurem(attributes)ma
ndmbehaviorm(methods).mAmclassmencapsulatesmanmobject'smdatamrepresentationmandmamm
ethod'smimplementation.mClassesmaremorganizedminmamclassmhierarchy.
29. ClassmDiagrammNotationm-
mCORRECTmANSWERmThemsetmofmsymbolsmusedminmthemcreationmofmclassmdiagramsminmUML
mobjectmmodeling.