WGU C170 DATA MANAGEMENT -
APPLICATIONS
domainbn-bnanswers--
Inbndatabnmodeling,bnthebnconstructbnusedbntobnorganizebnandbndescribebnanbnattribute'sbnsetbnofbnpos
siblebnvalues
superkeybn-bnanswers--
Anbnattributebnorbnattributesbnthatbnuniquelybnidentifybneachbnentitybninbnabntable.bnAnybncompositebnk
eybnwithbnthisbnisbnalsobnthis.
candidatebnkeybn-bnanswers--
Abnminimalbnsuperkey;bnthatbnis,bnabnkeybnthatbndoesbnnotbncontainbnabnsubsetbnofbnattributesbnthatbni
sbnitselfbnabnsuperkey
entitybnintegritybn-bnanswers--
Thebnpropertybnofbnabnrelationalbntablebnthatbnguaranteesbneachbnentitybnhasbnabnuniquebnvaluebninbna
bnprimarybnkeybnandbnthatbnthebnkeybnhasbnnobnnullbnvalues
referentialbnintegritybn-bnanswers--
Abnconditionbnbybnwhichbnabndependentbntable'sbnforeignbnkeybnmustbnhavebneitherbnabnnullbnentrybnor
bnabnmatchingbnentrybninbnthebnrelatedbntable
databndictionarybn-bnanswers--
AbnDBMSbncomponentbnthatbnstoresbnmetadata.bnItbncontainsbnthebndatabndefinitionbn&bntheirbncharac
teristicsbnandbnrelationships;bnmaybnalsobnincludebndatabnexternalbntobnthebnDBMS
, systembncatalogbn-bnanswers--
Abndetailedbnsystembndatabndictionarybnthatbndescribesbnallbnobjectsbninbnabndatabase
homonymbn-bnanswers--
Thebnusebnofbnthebnsamebnnamebntobnlabelbndifferentbnattributes,bnmuchbnlikebnsimilar-
soundingbnwordsbnwithbndifferentbnmeanings
synonymbn-bnanswers--
Thebnusebnofbndifferentbnnamesbntobnidentifybnthebnsamebnobject,bnsuchbnasbnanbnentity,bnanbnattribute
,bnorbnabnrelationship.bnThesebnshouldbngenerallybnbebnavoided.
notbnnullbnandbnuniquebn-bnanswers--
Anybncandidatebnkeybnmustbnhavebnthesebntwobnconstraintsbnenforced
cardinalitybn-bnanswers--
Termbnforbnhowbnmanybninstancesbnofbnonebnobjectbnarebnrelatedbntobninstancesbnofbnanotherbnobjectb
n(maximum)
modalitybn-bnanswers--
Termbnforbnwhetherbnanbninstancebnofbnabnspecificbnentitybnisbnoptionalbnorbnmandatorybninbnabnrelatio
nshipbn(minimum)
connectivitybn-bnanswers--
Termbnforbnthebnclassificationbnofbnthebnrelationshipbnbetweenbnentities.bnClassificationsbnincludebn1:1,b
n1:M,bnandbnM:N
CREATEbnSCHEMAbnAUTHORIZATIONbn-bnanswers--SQLbncommandbntobncreatebnabndatabasebnschema
DEFAULTbn-bnanswers--
SQLbnoptionbntobndefinebnabndefaultbnvaluebnforbnabncolumnbn(whenbnnobnvaluebnisbngiven)
CHECKbn-bnanswers--
SQLbncommandbntobnvalidatebndatabninbnanbnattribute,bnusedbnduringbntablebncolumnbncreation
APPLICATIONS
domainbn-bnanswers--
Inbndatabnmodeling,bnthebnconstructbnusedbntobnorganizebnandbndescribebnanbnattribute'sbnsetbnofbnpos
siblebnvalues
superkeybn-bnanswers--
Anbnattributebnorbnattributesbnthatbnuniquelybnidentifybneachbnentitybninbnabntable.bnAnybncompositebnk
eybnwithbnthisbnisbnalsobnthis.
candidatebnkeybn-bnanswers--
Abnminimalbnsuperkey;bnthatbnis,bnabnkeybnthatbndoesbnnotbncontainbnabnsubsetbnofbnattributesbnthatbni
sbnitselfbnabnsuperkey
entitybnintegritybn-bnanswers--
Thebnpropertybnofbnabnrelationalbntablebnthatbnguaranteesbneachbnentitybnhasbnabnuniquebnvaluebninbna
bnprimarybnkeybnandbnthatbnthebnkeybnhasbnnobnnullbnvalues
referentialbnintegritybn-bnanswers--
Abnconditionbnbybnwhichbnabndependentbntable'sbnforeignbnkeybnmustbnhavebneitherbnabnnullbnentrybnor
bnabnmatchingbnentrybninbnthebnrelatedbntable
databndictionarybn-bnanswers--
AbnDBMSbncomponentbnthatbnstoresbnmetadata.bnItbncontainsbnthebndatabndefinitionbn&bntheirbncharac
teristicsbnandbnrelationships;bnmaybnalsobnincludebndatabnexternalbntobnthebnDBMS
, systembncatalogbn-bnanswers--
Abndetailedbnsystembndatabndictionarybnthatbndescribesbnallbnobjectsbninbnabndatabase
homonymbn-bnanswers--
Thebnusebnofbnthebnsamebnnamebntobnlabelbndifferentbnattributes,bnmuchbnlikebnsimilar-
soundingbnwordsbnwithbndifferentbnmeanings
synonymbn-bnanswers--
Thebnusebnofbndifferentbnnamesbntobnidentifybnthebnsamebnobject,bnsuchbnasbnanbnentity,bnanbnattribute
,bnorbnabnrelationship.bnThesebnshouldbngenerallybnbebnavoided.
notbnnullbnandbnuniquebn-bnanswers--
Anybncandidatebnkeybnmustbnhavebnthesebntwobnconstraintsbnenforced
cardinalitybn-bnanswers--
Termbnforbnhowbnmanybninstancesbnofbnonebnobjectbnarebnrelatedbntobninstancesbnofbnanotherbnobjectb
n(maximum)
modalitybn-bnanswers--
Termbnforbnwhetherbnanbninstancebnofbnabnspecificbnentitybnisbnoptionalbnorbnmandatorybninbnabnrelatio
nshipbn(minimum)
connectivitybn-bnanswers--
Termbnforbnthebnclassificationbnofbnthebnrelationshipbnbetweenbnentities.bnClassificationsbnincludebn1:1,b
n1:M,bnandbnM:N
CREATEbnSCHEMAbnAUTHORIZATIONbn-bnanswers--SQLbncommandbntobncreatebnabndatabasebnschema
DEFAULTbn-bnanswers--
SQLbnoptionbntobndefinebnabndefaultbnvaluebnforbnabncolumnbn(whenbnnobnvaluebnisbngiven)
CHECKbn-bnanswers--
SQLbncommandbntobnvalidatebndatabninbnanbnattribute,bnusedbnduringbntablebncolumnbncreation
