WGU C170 DATA MANAGEMENT - APPLICATIONS

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