Wgu C170 Question And Answers

asWGU C170 QUESTION AND
ANSWERS




Aassalespersonasisasauthorizedastoassellasmanyasproductsasandasaasproductascanasbeassoldasbyasmanyassal
espersons.as

Whichaskindasofasbinaryasrelationshipasdoesasthisasscenarioasdescribe?



One-to-oneas

One-to-manyas

Many-to-manyas

One-to-oneasbinaryas-asanswers--Many-to-many



Whichastwoasexamplesasareasattributes?as



Chooseas2asanswers



Aaspersonasattendingasaasmeetingas

Anasemployeeasnumberas

Aassalesasmeetingas

Aasmeetingascodeas-asanswers--Anasemployeeasnumber

Aasmeetingascode

,Whichasdeleteasruleassetsascolumnasvaluesasinasaaschildastableastoasaasmissingasvalueaswhenastheasmatchi
ngasdataasisasdeletedasfromastheasparentastable?



Restrictas

Cascadeas

Matchingas

Set-to-Nullas-asanswers--Set-to-Null



ReferastoastheasgivenasSQLasstatement.as



CREATEasTABLEasmember

(

member_idasINTasUNSIGNEDasNOTasNULLasAUTO_INCREMENT,

PRIMARYasKEYas(member_id),

last_nameasVARCHAR(20)asNOTasNULL,

first_nameasVARCHAR(20)asNOTasNULL,

suffixasVARCHAR(5)asNULL,

expirationasDATEasNULL,

emailasVARCHAR(100)asNULL,

streetasVARCHAR(50)asNULL,

cityasVARCHAR(50)asNULL,

stateasVARCHAR(2)asNULL,

zipasVARCHAR(10)asNULL,

phoneasVARCHAR(20)asNULL,

interestsasVARCHAR(255)asNULL

);as



Whichastwoascolumnsasareascreatedasasassomethingasotherasthanasvariable-
lengthasstringsasinasthisasstatement?as

, Chooseas2asanswersas
as

member_idas

lastasnameas

suffixas

expirationas

emailas

cityas-asanswers--member_id

expiration



Employee_IDasEmployee_NameasOffice_Address

12342asJacobas54123asMainasStreet

12346asMichaelas354asCenterasAvenue

12846asEthanas54123asMainasStreet

12887asJoshuaas54123asMainasStreet

12894asDanielas354asCenterasAvenue

13097asAlexanderas354asCenterasAvenue

13112asAnthonyas54123asMainasStreet

13411asWilliamas354asCenterasAvenue

13987asChristopheras354asCenterasAvenue

13998asMatthewas54123asMainasStreet



Thisasdatabaseastableashasastenasdifferentasemployeeasnumbersasinastheasfirstascolumn.asEmployee_IDasis
astheasprimaryaskey.asInasaddition,asitashasastenasdifferentasnamesasinastheassecondascolumnasandastwoaso
fficeasaddressesasrepeatedasfiveastimesaseachasinastheasthirdascolumn.as



Whichasactionasshouldasbeasusedastoastranslateasthisasdataasintoasthirdasnormalasform?



Moveastheasdataasfromastheasthirdascolumnasintoastheasfirstascolumn.as