WGU C170 DATA MANAGEMENT -
APPLICATIONS
domainas-asanswers--
Inasdataasmodeling,astheasconstructasusedastoasorganizeasandasdescribeasanasattribute'sassetasofaspossible
asvalues
superkeyas-asanswers--
Anasattributeasorasattributesasthatasuniquelyasidentifyaseachasentityasinasaastable.asAnyascompositeaskeyas
withasthisasisasalsoasthis.
candidateaskeyas-asanswers--
Aasminimalassuperkey;asthatasis,asaaskeyasthatasdoesasnotascontainasaassubsetasofasattributesasthatasisasits
elfasaassuperkey
entityasintegrityas-asanswers--
Theaspropertyasofasaasrelationalastableasthatasguaranteesaseachasentityashasasaasuniqueasvalueasinasaaspri
maryaskeyasandasthatastheaskeyashasasnoasnullasvalues
referentialasintegrityas-asanswers--
Aasconditionasbyaswhichasaasdependentastable'sasforeignaskeyasmustashaveaseitherasaasnullasentryasorasaas
matchingasentryasinastheasrelatedastable
dataasdictionaryas-asanswers--
AasDBMSascomponentasthatasstoresasmetadata.asItascontainsastheasdataasdefinitionas&astheirascharacteris
ticsasandasrelationships;asmayasalsoasincludeasdataasexternalastoastheasDBMS
, systemascatalogas-asanswers--
Aasdetailedassystemasdataasdictionaryasthatasdescribesasallasobjectsasinasaasdatabase
homonymas-asanswers--
Theasuseasofastheassameasnameastoaslabelasdifferentasattributes,asmuchaslikeassimilar-
soundingaswordsaswithasdifferentasmeanings
synonymas-asanswers--
Theasuseasofasdifferentasnamesastoasidentifyastheassameasobject,assuchasasasanasentity,asanasattribute,asor
asaasrelationship.asTheseasshouldasgenerallyasbeasavoided.
notasnullasandasuniqueas-asanswers--Anyascandidateaskeyasmustashaveastheseastwoasconstraintsasenforced
cardinalityas-asanswers--
Termasforashowasmanyasinstancesasofasoneasobjectasareasrelatedastoasinstancesasofasanotherasobjectas(ma
ximum)
modalityas-asanswers--
Termasforaswhetherasanasinstanceasofasaasspecificasentityasisasoptionalasorasmandatoryasinasaasrelationshi
pas(minimum)
connectivityas-asanswers--
Termasforastheasclassificationasofastheasrelationshipasbetweenasentities.asClassificationsasincludeas1:1,as1:
M,asandasM:N
CREATEasSCHEMAasAUTHORIZATIONas-asanswers--SQLascommandastoascreateasaasdatabaseasschema
DEFAULTas-asanswers--
SQLasoptionastoasdefineasaasdefaultasvalueasforasaascolumnas(whenasnoasvalueasisasgiven)
CHECKas-asanswers--
SQLascommandastoasvalidateasdataasinasanasattribute,asusedasduringastableascolumnascreation
APPLICATIONS
domainas-asanswers--
Inasdataasmodeling,astheasconstructasusedastoasorganizeasandasdescribeasanasattribute'sassetasofaspossible
asvalues
superkeyas-asanswers--
Anasattributeasorasattributesasthatasuniquelyasidentifyaseachasentityasinasaastable.asAnyascompositeaskeyas
withasthisasisasalsoasthis.
candidateaskeyas-asanswers--
Aasminimalassuperkey;asthatasis,asaaskeyasthatasdoesasnotascontainasaassubsetasofasattributesasthatasisasits
elfasaassuperkey
entityasintegrityas-asanswers--
Theaspropertyasofasaasrelationalastableasthatasguaranteesaseachasentityashasasaasuniqueasvalueasinasaaspri
maryaskeyasandasthatastheaskeyashasasnoasnullasvalues
referentialasintegrityas-asanswers--
Aasconditionasbyaswhichasaasdependentastable'sasforeignaskeyasmustashaveaseitherasaasnullasentryasorasaas
matchingasentryasinastheasrelatedastable
dataasdictionaryas-asanswers--
AasDBMSascomponentasthatasstoresasmetadata.asItascontainsastheasdataasdefinitionas&astheirascharacteris
ticsasandasrelationships;asmayasalsoasincludeasdataasexternalastoastheasDBMS
, systemascatalogas-asanswers--
Aasdetailedassystemasdataasdictionaryasthatasdescribesasallasobjectsasinasaasdatabase
homonymas-asanswers--
Theasuseasofastheassameasnameastoaslabelasdifferentasattributes,asmuchaslikeassimilar-
soundingaswordsaswithasdifferentasmeanings
synonymas-asanswers--
Theasuseasofasdifferentasnamesastoasidentifyastheassameasobject,assuchasasasanasentity,asanasattribute,asor
asaasrelationship.asTheseasshouldasgenerallyasbeasavoided.
notasnullasandasuniqueas-asanswers--Anyascandidateaskeyasmustashaveastheseastwoasconstraintsasenforced
cardinalityas-asanswers--
Termasforashowasmanyasinstancesasofasoneasobjectasareasrelatedastoasinstancesasofasanotherasobjectas(ma
ximum)
modalityas-asanswers--
Termasforaswhetherasanasinstanceasofasaasspecificasentityasisasoptionalasorasmandatoryasinasaasrelationshi
pas(minimum)
connectivityas-asanswers--
Termasforastheasclassificationasofastheasrelationshipasbetweenasentities.asClassificationsasincludeas1:1,as1:
M,asandasM:N
CREATEasSCHEMAasAUTHORIZATIONas-asanswers--SQLascommandastoascreateasaasdatabaseasschema
DEFAULTas-asanswers--
SQLasoptionastoasdefineasaasdefaultasvalueasforasaascolumnas(whenasnoasvalueasisasgiven)
CHECKas-asanswers--
SQLascommandastoasvalidateasdataasinasanasattribute,asusedasduringastableascolumnascreation