This istudy isource iwas idownloaded iby i100000824083030 ifrom iCourseHero.com ion i06-17-2021 i06:56:14 iGMT i-05:00
https://www.coursehero.com/file/64367196/4-2-Lab-Cardinality-and-Targeted-Datadocx/
DAD-220
05/21/2020
1.Retrieve iemployee ituples iand iidentify ithe inumber iof iemployees iin iSan iFrancisco iand iNew iYork.
a.Command ifor iSan iFrancisco: iselect ifirstName, ilastName, ijobTitle, ioffices.city ifrom iemployees iinner ijoin ioffices ion iemployees.officeCode i= ioffices.officeCode iwhere istate i= i'CA'; b.Write iand irun ia icommand ito ireturn irecords ifrom iNew iYork ion iyour iown.
c.Validate ithe icompletion iof ithis istep iwith ia iscreenshot iof ithese itwo itables. This istudy isource iwas idownloaded iby i100000824083030 ifrom iCourseHero.com ion i06-17-2021 i06:56:14 iGMT i-05:00
https://www.coursehero.com/file/64367196/4-2-Lab-Cardinality-and-Targeted-Datadocx/Please isee iabove iscreenshots.
2.Retrieve iorder idetails ifor iorder iNumber i10330, i10338, iand i10194 iby irunning iSELECT iqueries iwith iWHERE iclauses iagainst ithe iorders itable.
a.Validate ithe icompletion iof ithis istep iwith ia iscreenshot.
b.Then, ireference ithe iModule i Four i Lab i ERD ito iassist iin iidentifying irelationships. iA
iversion iwith ialternative itext iis iavailable: iModule i Four i Lab i ERD i With i Alternative iText.
c.Now, iidentify iwhat itype iof icardinality ithis irepresents iin ithe ientity irelationship imodel.
Each iCUSTOMER ican ihave izero ior imany iorders. iOne iOrder ican ihave imultiple ientries iin iORDERDETAILS itable. iEach iOrderNumber iis iunique. iHigh iCardinality iwith ia iOne-To-Zero iMinima. iOne ior imore irow iin iORDERDETAILS itable ifor ieach irelated ientry iin iORDERS itable.
3.Delete irecords ifrom ithe ipayments itable iwhere ithe icustomer inumber iequals i103.
https://www.coursehero.com/file/64367196/4-2-Lab-Cardinality-and-Targeted-Datadocx/
DAD-220
05/21/2020
1.Retrieve iemployee ituples iand iidentify ithe inumber iof iemployees iin iSan iFrancisco iand iNew iYork.
a.Command ifor iSan iFrancisco: iselect ifirstName, ilastName, ijobTitle, ioffices.city ifrom iemployees iinner ijoin ioffices ion iemployees.officeCode i= ioffices.officeCode iwhere istate i= i'CA'; b.Write iand irun ia icommand ito ireturn irecords ifrom iNew iYork ion iyour iown.
c.Validate ithe icompletion iof ithis istep iwith ia iscreenshot iof ithese itwo itables. This istudy isource iwas idownloaded iby i100000824083030 ifrom iCourseHero.com ion i06-17-2021 i06:56:14 iGMT i-05:00
https://www.coursehero.com/file/64367196/4-2-Lab-Cardinality-and-Targeted-Datadocx/Please isee iabove iscreenshots.
2.Retrieve iorder idetails ifor iorder iNumber i10330, i10338, iand i10194 iby irunning iSELECT iqueries iwith iWHERE iclauses iagainst ithe iorders itable.
a.Validate ithe icompletion iof ithis istep iwith ia iscreenshot.
b.Then, ireference ithe iModule i Four i Lab i ERD ito iassist iin iidentifying irelationships. iA
iversion iwith ialternative itext iis iavailable: iModule i Four i Lab i ERD i With i Alternative iText.
c.Now, iidentify iwhat itype iof icardinality ithis irepresents iin ithe ientity irelationship imodel.
Each iCUSTOMER ican ihave izero ior imany iorders. iOne iOrder ican ihave imultiple ientries iin iORDERDETAILS itable. iEach iOrderNumber iis iunique. iHigh iCardinality iwith ia iOne-To-Zero iMinima. iOne ior imore irow iin iORDERDETAILS itable ifor ieach irelated ientry iin iORDERS itable.
3.Delete irecords ifrom ithe ipayments itable iwhere ithe icustomer inumber iequals i103.
