Test Bank for Database Concepts, 16th edition by David M. Kroenke.pdf

,DOWNLOAD THE Test Bank for Database Concepts 9th Edition Kroenke
c c c c c c c c c




DatabasecConcepts,c9ec(Kroenke)c
Chapterc2c ThecRelationalcModel

1) Ackeycmustcbecunique.
Answer:c FALSE
Diff:c1 PagecRef:c74
AACSB:c InformationcTechnology
ChaptercObj.:c LearncbasiccrelationalcterminologycClassification:
c Concept




2) Ensuringcthatceverycvaluecofcacforeignckeycmatchescacvaluecofctheccorrespondingcprimaryckeycisc
ancexamplecofcacreferentialcintegritycconstraint.
Answer:c TRUE
Diff:c1 PagecRef:c80
AACSB:c InformationcTechnology
ChaptercObj.:c LearncbasiccrelationalcterminologycClassification:
c Concept




3) Acdoublecarrowcnotation,cA→→cB,ciscusedctocindicatecacmultivaluedcdependency.cA
nswer:c TRUE
Diff:c2 PagecRef:c96
AACSB:c InformationcTechnology
ChaptercObj.:c LearncbasiccrelationalcterminologycClassification:
c Concept




4) MicrosoftcAccesscformsccanconlyccontaincdatacfromconectable.c
Answer:c FALSE
Diff:c1 PagecRef:c114
AACSB:c InformationcTechnology
ChaptercObj.:c LearncbasiccrelationalcterminologycClassification:
c Concept




5) Whilecthecrelationalcmodelcforcdatabasescappearsctocholdcmuchcpromise,cfewccommercialcd
atabaseschavecimplementedcit.
Answer:c FALSEcDiff
:c1 PagecRef:c70
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecconceptualcfoundationcofcthecrelationalcmodelcClassific
ation:c Concept

6) Everyccellcincacrelationccancholdconlycacsinglecvalue.c
Answer:c TRUE
Diff:c1 PagecRef:c71
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecconceptualcfoundationcofcthecrelationalcmodelcClassific
ation:c Concept


1
Copyrightc©c2020cPearsoncEducation,cInc.
mynursytest.store

,DOWNLOAD THE Test Bank for Database Concepts 9th Edition Kroenke
c c c c c c c c c




7) Incthecrelationalcmodel,ceachcrowcofcactableccontainscdatacthatcrepresentscancattributecofcthecen
tity.
Answer:c FALSEcDiff
:c2 PagecRef:c71
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecconceptualcfoundationcofcthecrelationalcmodelcClassific
ation:c Concept

8) Tocbecconsideredcaccompositeckey,cackeycmustccontaincatcleastctwocattributes.cA
nswer:c TRUE
Diff:c1 PagecRef:c74
AACSB:c InformationcTechnology
ChaptercObj.:c Learncthecmeaningcandcimportancecofckeys,cforeignckeys,candcrelatedcterminologycClassificat
ion:c Concept

9) Candidateckeyscmaycorcmaycnotcbecunique.c
Answer:c FALSE
Diff:c2 PagecRef:c75
AACSB:c InformationcTechnology
ChaptercObj.:c Learncthecmeaningcandcimportancecofckeys,cforeignckeys,candcrelatedcterminologycClassificat
ion:c Concept

10) Thecprimaryckeyciscusedcbothctocidentifycuniquecrowscincacrelationcandctocrepresentcrowscincrel
ationships.
Answer:c TRUE
Diff:c2 PagecRef:c75
AACSB:c InformationcTechnology
ChaptercObj.:c Learncthecmeaningcandcimportancecofckeys,cforeignckeys,candcrelatedcterminologycClassificat
ion:c Concept

11) Nullcvaluesccanccausecproblemscbecausectheycarecambiguous.c
Answer:c TRUE
Diff:c1 PagecRef:c84
AACSB:c InformationcTechnology
ChaptercObj.:c Learncthecmeaningcandcimportancecofckeys,cforeignckeys,candcrelatedcterminologycClassificat
ion:c Concept

12) IfcthecconditioncexistscsuchcthatcknowingcthecvaluecofcattributecXcdeterminescthecvaluecofcat
tributecY,cthencattributecYciscfunctionallycdependentconcattributecX.
Answer:c TRUE
Diff:c1 PagecRef:c85
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecmeaningcofcfunctionalcdependenciescCl
assification:c Concept




2
Copyrightc©c2020cPearsoncEducation,cInc.
mynursytest.store

, DOWNLOAD THE Test Bank for Database Concepts 9th Edition Kroenke
c c c c c c c c c




13) GivencthecfunctionalcdependencycforcthecattributescofcENTITY1,cXc→c(A,cB,cC),cXciscacca
ndidateckeycforcthecrelationcENTITY1c(A,cB,cC,cX).
Answer:c TRUE
Diff:c3 PagecRef:c87
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecmeaningcofcfunctionalcdependenciescCl
assification:c Concept

14) Surrogateckeycvalueschavecnocmeaningctocthecusers.c
Answer:c TRUE
Diff:c1 PagecRef:c79
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecpurposecandcusecofcsurrogateckeyscClass
ification:c Concept

15) Sincecsurrogateckeyscarecusedctocuniquelycidentifycrows,ctheircvaluescarecnormallycdisplayedcpr
ominentlyconcallcformscandcreportscforcthecusersctocsee.
Answer:c FALSEcDiff
:c2 PagecRef:c79
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecpurposecandcusecofcsurrogateckeyscClass
ification:c Concept

16) ThecusecofcsurrogateckeyscusuallyccomplicatescapplicationcprogrammingcsincecmostcDBMScp
roductscrequirecthecapplicationcprogramctocgeneratecsurrogateckeycvalues.
Answer:c FALSEcDiff
:c2 PagecRef:c79
AACSB:c InformationcTechnology
ChaptercObj.:c LearncthecpurposecandcusecofcsurrogateckeyscClass
ification:c Concept

17) Normalizationciscthecprocesscofcremovingcallcfunctionalcdependenciescfromcacrelation.cA
nswer:c FALSE
Diff:c2 PagecRef:c88
AACSB:c InformationcTechnology
ChaptercObj.:c LearnctocapplycacprocesscforcnormalizingcrelationscClassification:
c Concept




18) Toccreatecacwell-
formedcrelationcthroughcnormalization,ceverycdeterminantcmustcbecaccandidateckey.
Answer:c TRUE
Diff:c1 PagecRef:c89
AACSB:c InformationcTechnology
ChaptercObj.:c LearnctocapplycacprocesscforcnormalizingcrelationscClassification:
c Concept




3
Copyrightc©c2020cPearsoncEducation,cInc.
mynursytest.store