Wgu C170 Data Management - Applications

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