Upload
javier-gonzalez-sanchez
View
223
Download
0
Embed Size (px)
Citation preview
7/22/2019 Bases de Datos | UDG 2005
1/185
@csj mj Mctds
F, Ks, Hcvijr Gdlzojz [lkbjz
hcvijrgsNckf,drg
7/22/2019 Bases de Datos | UDG 2005
2/185
hcvijrgsNckf,drg 0
Zlivjrsimcm mj Gucmcochcrc
Kjltrd Zlivjrsitcrid mj Kijlkics Jkdlfikd Cmfilistrctivcs
Kddrmilckil mj Ilvjstigckil y ^dstgrcmd
Fcjstrc jl ]jkldodgcs mj oc Iledrfckil
7/22/2019 Bases de Datos | UDG 2005
3/185
hcvijrgsNckf,drg ;
sjfclc kocsj jvcouckil
>3, >>, ^rjsjltckil mjo Kursd
>3, Kdlkjptds Gjljrcojs
>0, Bistdric
>;, Crquitjkturc y [istjfc mj @M
J3, Jxcfjl mj u`ikckil
>0, >=, Fdmjod JP ^rcktikc kdl JP
>;, >:, Cofckjlcfijltd esikd
>5, Ojlguchjs
J0, Kdlkjptds
>=, >7, Fdmjod Pjockidlco J;, Jxcfjl mj rjpcsdcofckjlcfijltd
>:, >2, ogj`rc Pjockidlco Jhjrkikid
>5, >2, ogj`rc Pjockidlco J=, Jxcfjl mj rjpcsd
>7, >9, [SO
3>, PM@F[ y dtrcs bjrrcfijltcs
33, rdyjktd
^rdyjktd pcrkico
>2, 30, Jxcfjl mj pjridmd pcrkico3;, Iltrdmukkil c Ldrfcoizckil
Jxcfjl pcrkico
>9, 3=, Ldrfcoizckil mjpjlmjlkics y mjskdfpdsikil)
3:, Mjskdfpdsikil3>, 35, Kcsd mj Jstumid
35, Ldrfcoizckil fuotivcoucmc mjpjlmjlkics y mjskdfpdsikil)
J:, Fdmjod Pjockidlco
33, 37, rcktikc Pjockidlco
30, 32, Fdmjod D`hjtd y D`hjtd Pjockidlco
39, Jltrjgc mjo prdyjktd eilco
Pjpcsd Gjljrco
3;, 0>, Jxcfjl Eilco Jxcfjl Eilco
7/22/2019 Bases de Datos | UDG 2005
4/185
hcvijrgsNckf,drg =
7/22/2019 Bases de Datos | UDG 2005
5/185
hcvijrgsNckf,drg :
D`hjtivd
Kdlkjptds
Misjd mj `csj mj mctds
fdmjocmd y ldrfcoizckil
Ifpojfjltckil mj `csj mj mctds
ojlguchjs y eckioimcmjs iltjreckjs)
jstcmd mjo crtj8 mistri`uimcs/ jspckicojs/ drijltcmcs cd`hjtds/ rjockidlcojs/ dtrcs
7/22/2019 Bases de Datos | UDG 2005
6/185
hcvijrgsNckf,drg 5
Cltjkjmjltjs
^rdgrcfckil
Jstrukturc mj mctds
Drgclizckil kdfputckidlco
[istjfcs dpjrctivds cvclzcmds (^rdgrcfckil cvclzcmc (
Ilgjlijrc mj [detwcrj (
prj & rjquisitd
7/22/2019 Bases de Datos | UDG 2005
7/185
hcvijrgsNckf,drg 7
0:* jxcfjl pcrkico8
0:* jxcfjl eilco8
;>* prdyjktd8
0>* tcrjcs y jhjrkids jl kocsj
3>>*
Jvcouckil
7/22/2019 Bases de Datos | UDG 2005
8/185
hcvijrgsNckf,drg 2
@i`oidgrcec
Eulmcfjltcos de mctc`csj systjfsPcfjz Jofcsri/ [bcfaclt @, Lcvctbj
Cmmisdl&Wjsojy/ 0>>>/ ;rc jmikil,
Mctc`csj systjfs 8 tbj kdfpojtj `ddaBktdr Gcrkc&Fdoilc/ Hjeerjy M, Zoofcl/ Hjlliejr Wimdf,^rjltikj Bcoo/ 0>>0,
Cl iltrdmuktidl td mctc`csj systjfsK, H, Mctj^jcrsdl $ Cmmisdl Wjsojy/ 0>>=, 2vc, Jmitidl,
7/22/2019 Bases de Datos | UDG 2005
9/185
hcvijrgsNckf,drg 9
Iltrdmukkil c ocs `csjs mj mctds
D`hjkt Drijltjm Mctc @csjs
Pjejrjlkics
7/22/2019 Bases de Datos | UDG 2005
10/185
hcvijrgsNckf,drg 3>
J3 & jxcfjl mj Z`ikckil
7/22/2019 Bases de Datos | UDG 2005
11/185
hcvijrgsNckf,drg 33
>3, Kdlkjptds gjljrcojs
7/22/2019 Bases de Datos | UDG 2005
12/185
hcvijrgsNckf,drg 30
@M/ @MF[/ sistjfc mj @M
@csj mj Mctds
Kdojkkil mj mctdsPjockil ogikc y kdbjrjltj
Misjd jspjkieikd
M@F[
^rdgrcfcCmfilistrcmdr
[istjfc mj `csj mj mctds
M@F[ ! M@
7/22/2019 Bases de Datos | UDG 2005
13/185
hcvijrgsNckf,drg 3;
Fjtc mctckctcodgd
mctc
M@F[
M@ cpoikckil
kdlkurrjlkic MMO kdfpiojr
cmfilistrcmdr
qujry kdfpiocmdr
Jsqujfc mjo [istjfc
7/22/2019 Bases de Datos | UDG 2005
14/185
hcvijrgsNckf,drg 3=
Kikod mj Mjscrrdood
Mjeilir QC%MVjspjkieikcr tipds
Kdlstruircofckjlcr
Fclipuocrkdlsuotc/ cktucoizckidl/ jtk
7/22/2019 Bases de Datos | UDG 2005
15/185
hcvijrgsNckf,drg 3:
Kdlkjptds
Fjtc&mctds8jsqujfcs 6 iltjlkil
Ilstclkics8mctds 6 jxtjlsil
jstcmdsUistcs
Dpjrckil c`strcktcKdlkurrjlkic]rclsckkil^jrsistjlkic
Pjockil
Pjstrikkil mjiltjgrimcm
@ckaup rjspcomd)
Pjkdvjry
rjkupjrckil)
Jskcoc`ioimcm
Y bc`oclmd mj @M vjrsus Eioj[ystjfs
7/22/2019 Bases de Datos | UDG 2005
16/185
hcvijrgsNckf,drg 35
>0, Bistdric
7/22/2019 Bases de Datos | UDG 2005
17/185
hcvijrgsNckf,drg 37
39=: kiltcs y `squjmc oiljco
39:9 ckkjsd cojctdrid c mctds jl cofckjlcfijltd
jojktrlikd
395> fdmjod hjrrquikd/ jl rjm y fuotiusucrid
397> ]jm Kdmm prjsjltc jo fdmjod rjockidlco
3975 Kbjl prjsjltc jofdmjod jltimcm rjockil
3975 Ojlguchjs mj kdlsuotc8 [SO/ S@J/ SZJO
392> M@F[ pcrc ^K "M`csj/ ^crcmdx)
392; M@F[ kdfjrkicojs8 Drckoj/ [y`csj/ Iledrfix
392: [SO jstclmcr prjoifilcr399> Ilkdrpdrckil mj kcpckimcmjs y
cktivimcmjs mjmuktivcs/ jspckicojs/
tjfpdrcojs y fuotifjmic,
399> ^crcojoisfd
Bistdric
7/22/2019 Bases de Datos | UDG 2005
18/185
hcvijrgsNckf,drg 32
>;, [istjfcs y Crquitjkturcs mj @m
7/22/2019 Bases de Datos | UDG 2005
19/185
hcvijrgsNckf,drg 39
Fdmjod mj Mctds
Livjojs mj c`strckkil
Dkuotcr mjtcoojs mjo cofckjlcfijltdesikd
Mjskri`ir kdlkjptucofjltj oc jstrukturcmj oc `csj mj mctds8 tipds/ rjockidljs/rjstrikkidljs/ dpjrckidljs ojlguchj),
7/22/2019 Bases de Datos | UDG 2005
20/185
hcvijrgsNckf,drg 0>
Fdmjod mj Mctds
Kdlkjptuco8 cotd livjoFDMJOD JP & Jltimcm/ ctri`utd/ rjockil
Pjprjsjltctivd8Kocsjs/ rjgistrds
FDMJOD PJOCKIDLCO/ PJM/ HJPCPSZIKD/ DD^
EI[IKD8 livjo `chdPutcs pctbs)
Cofckjlcfijltd esikd
7/22/2019 Bases de Datos | UDG 2005
21/185
hcvijrgsNckf,drg 03
Crquitjkturc ; kcpcs
Iltjrlc8 cofckl esikd
Kdlkjptuco8jsqujfc mj livjo cotd d fjmid
Jxtjrld8 vistcs mj usucrid)jsqujfc mj livjo cotd d fjmid
Fcpjd8 trclsedrfckil mj pjtikil$rjspujstc
Ilmjpjlmjlkicogikc mj mctds
Ilmjpjlmjlkicesikc mj mctds
7/22/2019 Bases de Datos | UDG 2005
22/185
hcvijrgsNckf,drg 00
Kocsieikckil mj sistjfcs mj @M
^dr fdmjod mj mctds8
Pjockidlco cotd livjo) &< tc`ocs/ ojlguchj cotd livjoPjm&< rjgistrds/ jf`j`imd c ojlguchjs vcridsHjrrquikd&< r`dojs/ sil ojlguchj jspjkicoDD^ &< d`hjtds$kocsjs/
^dr Zsucrids8
[ifpoj y fuotiusucrid
^dr sitids8
Kjltrcoizcmd y mistri`uimd y bdfdgljd d bjtjrdgljd
^dr kdstd8
^dr prdpsitd8
Gjljrco d jspjkico
7/22/2019 Bases de Datos | UDG 2005
23/185
hcvijrgsNckf,drg 0;
]38 kdlkjptds
Ojkturc mjo oi`rd mj tjxtd
Kdlkjptds gjljrcojs Fdmjod Jltimcm & Pjockil
7/22/2019 Bases de Datos | UDG 2005
24/185
hcvijrgsNckf,drg 0=
7/22/2019 Bases de Datos | UDG 2005
25/185
hcvijrgsNckf,drg 0:
>=, Fdmjod JP
7/22/2019 Bases de Datos | UDG 2005
26/185
hcvijrgsNckf,drg 05
Fdmjod mj cotd livjo
i,j, ld js ul fdmjod rjprjsjltctivd d mj ifpojfjltckil,J[ ZL FDMJOD KDLKJ^]ZCOpcrc oc kdlstrukkil mj jsqujfcs
clcoikjfds jo fdmjod sifpoj
Fdmjod JP
7/22/2019 Bases de Datos | UDG 2005
27/185
hcvijrgsNckf,drg 07
prd`ojfc
rjqujrifijltdscloisis
CO]D LILJO8Misjd kdlkjptuco
[kbjfcs]ipds/ rjockidljs/
kdlstrcilt
misjd
trclsckkidljs
ifpojfjltckil
M@F[Fdmjod mj
Ifpojfjltckil!
Fdmjod Esikd
ZFOMicgrcfc mj eouhd
Jtk,
Pjgocs mjo ljgdkid
Ojlguchj mj^rdgrcfckil
!Kdfpiockil
Mctds pjrsistjltjs prdgrcfckil
Fdmjod JP
7/22/2019 Bases de Datos | UDG 2005
28/185
hcvijrgsNckf,drg 02
Kdlstrukkil8 jltimcm
]ipd mj Jltimcm jltity typj) #iltjlkidlldf`rj ! ctri`utds
ckcsd js ulc kocsj 4
Jltimcm 6 mctd 6 kdsc jl jo fulmdckcsd ul d`hjtd4 #jxtjlsidl
Jltimcm y Jltimcm ergio,
[ustcltivd silguocr
7/22/2019 Bases de Datos | UDG 2005
29/185
hcvijrgsNckf,drg 09
Kdlstrukkil8 ctri`utd
]ipds mj Ctri`utds8
[ifpoj $ kdfpujstd)# ulc mirjkkidl
Fdldvcoucmd $ {fuotivcoucmd}# ul kdodr/ ul grcmd ckcmjfikd
Cofckjlcmd$mjrivcmd# jmcm y ejkbc
Luoo
Oocvj#
7/22/2019 Bases de Datos | UDG 2005
30/185
hcvijrgsNckf,drg ;>
Kdlstrukkil8 rjockil
]ipd mj Pjockil 8 csdkickil jltrj ]ipds Jltimcm,
Ilstclkic mj Pjockidl8TTTTTTTTTTTTTTTTT
Grcmd# + mj pcrtikipcltjs `ilcric/ tjrlcric)
Kcrmilcoimcm cogd csi 38L/ 383/ F8L ^crtikipckidl tdtco "d`oigcmc) d pcrkico
Pdo# cpdrtj mj oc jltimcm c oc rjockidl
Pjockidl Pjkursivc# TTTTTTTTTTTTTTTT
D`hjtds tijljl d oocvjs edrcljcs 4
Ctri`utds jl rjockidljs
Ujr`d
7/22/2019 Bases de Datos | UDG 2005
31/185
hcvijrgsNckf,drg ;3
Micgrcfcs JP
Ctri`utd
Ctri`utd
Oocvj pcrkico
Ctri`utdfuotivcodr
Kdfpujstd
rjockil
Jltity typj Jltity typj ergio
Ctri`utdmjrivcmd
Ctri`utd Oocvj
7/22/2019 Bases de Datos | UDG 2005
32/185
hcvijrgsNckf,drg ;0
C prcktikcr
7/22/2019 Bases de Datos | UDG 2005
33/185
hcvijrgsNckf,drg ;;
]crjc 0
Fdmjod JP mjo sistjfc mj
0>>=) & rjvistc migitco
0>>:) & ulivjrsimcm virtuco
0>>5) & rjkursds mj iledrfckil kdldkifijltds)
7/22/2019 Bases de Datos | UDG 2005
34/185
hcvijrgsNckf,drg ;=
7/22/2019 Bases de Datos | UDG 2005
35/185
hcvijrgsNckf,drg ;:
>:, Cofckjlcfijltd esikd
7/22/2019 Bases de Datos | UDG 2005
36/185
hcvijrgsNckf,drg ;5
Cofckjlcfijltd esikdDrgclizckil mj mctds jl rjgistrds y crkbivds jl ul fjmid mj
cofckjlcfijltd
Fjmid prifcrid 6 rpimd y oifitcmdFjmid sjkulmcrid 6 ojltd y jxtjlsd/ mj `chd kdstd
Fdmjod JP
7/22/2019 Bases de Datos | UDG 2005
37/185
hcvijrgsNckf,drg ;7
Crquitjkturc
@it@ytj^istcKioilmrd[jktdrjs # BW
@odquj# [W
ltjr `odqujs gcps)Koustjr
K^Z
Fjmid sjkulmcrid
Pdtckil]rclsejrjlkic
octjlkic
Fjmid prifcrid
@ueejr & PCF
edr
fct
Zlimcm mj trclsejrjlkic8@odquj
Mirjkkil8[upjreikij8pistc8`odquj
7/22/2019 Bases de Datos | UDG 2005
38/185
hcvijrgsNckf,drg ;2
Kdlkjptds
Jltimcm#rjgistrd
]ipd jltimcm# fjtcmctd tipds)8 ilt mctj/ `ddojcl/`od` `ilcry ocrgj d`hjkt)
Crkbivd 6 sjkujlkic mj rjgistrdsfisfd tcfcdtcfcd mistiltd sjpcrcmdrjs)
Pjgistrds ilsjrtcmds jl `odqujs8kdltiluds/ oigcmds/ ilmjxcmds
7/22/2019 Bases de Datos | UDG 2005
39/185
hcvijrgsNckf,drg ;9
Dpjrckidljs sd`rj Crkbivds
mj rjkupjrckil kdlsuotc)
mj cktucoizckil ilsjrkil/ `drrcmd/ )
Mj 3 rjsuotcmd
Mj 3 kdlhultd mj rjsuotcmds
Crkbivds vdotiojs # kcf`ids kdlstcltjs
Crkbivds jsttikds #pdkds kcf`idsCrkbivds kdl lmikjs # `usqujmc
7/22/2019 Bases de Datos | UDG 2005
40/185
hcvijrgsNckf,drg =>
Crkbivds
^rifcrid
Drmjl sil drmjllikd kdf`ilcmd
Pjgistrds eihds & vcric`ojs
[jkulmcrid
lmikj
7/22/2019 Bases de Datos | UDG 2005
41/185
hcvijrgsNckf,drg =3
Drgclizckil mj Crkbivd ^rifcrid
Bjcp eioj "sil drmjl)8usd csdkicmd c ilmikj/ `ujlc ilsjrkidl/ `usqujmcoiljco/ `drrcmd kdl ercgfjltckidl, Pjdrgclizckidl
y$d jlkcmjlcr`drrcmds kdl fcrkcs, Fdmieikcrifpoikc `drrcr j ilsjrtcr, Oistcmd mj rjgistrds jldrmjl ifpoikc ul fjrgj[drt jxtjrld,
[drtjm eioj "sjkujlkico)8
rjgistrds drmjlcmds jl miskd pdr ul kcfpd mcmd,Zsd mj `usqujmc `ilcric, Kdstdsd `drrcr j ilsjrtcr,]rclsckkidl ifpoikc kdpic y cljxd mj `usqujmcoiljco c oc `ilcric jxistjltj,
7/22/2019 Bases de Datos | UDG 2005
42/185
hcvijrgsNckf,drg =0
Drgclizckil mj Crkbivd ^rifcrid
Bcsb eioj8 rdwim pdr rjgistrd),
Iltjrld jl PCF)8 sdoukil mj kdoisil/ c`ijrtc sig,pdsikil)/ jlkcmjlcr/ fuotibcsbIfpoikc jo usd mj cogdritfds prdpids mj ilsjrkil/`drrcmd y sjojkkil
Jxtjrld8 pdr pdsikil rjoctivc mj `odquj d koustjr,
kdfpoikc kdlsuotc sjkujlkico, @squjmc js kcrcpcrc kcfpds ld oocvj, Fdmieikcr 6 `drrcr ! ilsjrtcr
7/22/2019 Bases de Datos | UDG 2005
43/185
hcvijrgsNckf,drg =;
Drgclizckil mj Crkbivd ^rifcrid
r`do8
kdfd mirjktdrid prifcrid y mctds jl crkbivd
7/22/2019 Bases de Datos | UDG 2005
44/185
hcvijrgsNckf,drg ==
lmikjs
lmikj8 jstrukturc mj ckkjsd pcrc ckjojrcrrjkupjrckidl mj mctds
]ipds8
3,`cscmd jl crkbivd drmjlcmd fdldlivjo)0, `cscmd jl r`do fuotilivjo);, `cscmd jl bcsb
C, lmikj esikd@, lmikj ogikd
^rd`ojfcs pcrc ilsjrtcr y `drrcr
7/22/2019 Bases de Datos | UDG 2005
45/185
hcvijrgsNckf,drg =:
fdldlivjo
^rifcrid8oistc mj lmikj8 mirjkkil,Mjlsd$Ld mjlsd,
Cpoikc sd`rj prifcrid drmjlcmd
Koustjrilg8kcfpd mj drmjl ld js oocvj likd),Ld mjlsd,
Cpoikc sd`rj crkbivd drmjlcmd,
[jkulmcrid8Crkbivd ld drmjlcmd/ mjlsd
7/22/2019 Bases de Datos | UDG 2005
46/185
hcvijrgsNckf,drg =5
fuotilivjo
r`dojs
kdf`ctjl oc mjsvjltchc mj ilsjrtcr y `drrcr jl odsfdldlivjo,
r`do @/ bcsb,
7/22/2019 Bases de Datos | UDG 2005
47/185
hcvijrgsNckf,drg =7
>5, Ojlguchjs
7/22/2019 Bases de Datos | UDG 2005
48/185
hcvijrgsNckf,drg =2
Ojlguchjs
7/22/2019 Bases de Datos | UDG 2005
49/185
hcvijrgsNckf,drg =9
Ojlguchjs
MMO mctc mjeilitidl oclguchj)Mjeilj jsqujfcs kdlkjptucojs j iltjrld
[MO stdrcgj mjeilitidl oclguchj)Mjeilj jsqujfc iltjrld
UMO vijw mjeilitidl oclguchj)Mjeilj jsqujfcs mj usucrids
MFO mctc mjeilitidl oclguchj)
Zsucrid/ kdflfjltj mjldfilcmd qujry oclguchj
Y jo ecfdsd [SO js ul kcsd tpikd mj ,4
7/22/2019 Bases de Datos | UDG 2005
50/185
hcvijrgsNckf,drg :>
J0 kdlkjptds
Bc`ioimcm kdlstruyjlmd fdmjods c`strcktds
Bc`ioimcm ec`rikclmd Sujry&[SO
7/22/2019 Bases de Datos | UDG 2005
51/185
hcvijrgsNckf,drg :3
]crjc ;
Fdmjod Pjockidlco Kdlvjrsil mj JP c P [if`dodgc )
ogj`rc Pjockidlco Jvdoukidlcmd oc ]jdrc mj kdlhultds
Ljkjsitcfds ul PM@F[ Drckoj/ fy[SO
7/22/2019 Bases de Datos | UDG 2005
52/185
hcvijrgsNckf,drg :0
7/22/2019 Bases de Datos | UDG 2005
53/185
hcvijrgsNckf,drg :;
Jxcfjl mj Pjpcsd
7/22/2019 Bases de Datos | UDG 2005
54/185
hcvijrgsNckf,drg :=
>7, Fdmjod Pjockidlco
7/22/2019 Bases de Datos | UDG 2005
55/185
hcvijrgsNckf,drg ::
Fdmjod Pjockidlco
7/22/2019 Bases de Datos | UDG 2005
56/185
hcvijrgsNckf,drg :5
Iltrdmukkil
Kdmm 397>
Jstc`oj y eirfj c livjo kdfjrkico
Kdlsimjrcr8 rjstrikkil mj iltjgrimcm
ogj`rc 6 kdojkkil mj dpjrckidljs pcrcfclipuocr rjockidljs
^rdyjkkil mj JP
7/22/2019 Bases de Datos | UDG 2005
57/185
hcvijrgsNckf,drg :7
kdlkjptdsJltimcm 6 tc`oc 6 rjockil
Mctds 6 Pjlgol 6 tupoc
Ctri`utd 6 kcfpd 6 ctri`utd
Mdfilid 6 tipd 6 mdfilid8 kdlhultd mj vcodrjs ctfikds M) 8 ldf`rj/ tipd/ edrfctd/cmikidlco ilmikckil,
Kcrmilcoimcm mjo mdfilid + jojfjltds)
Jsqujfc mj rjockil P) 6 P C3/ Cl), Ldf`rj/ oistc mj ctri`utds PDOjs mj mdfilid)?iltjlkil2, ogj`rc Pjockidlco
7/22/2019 Bases de Datos | UDG 2005
65/185
hcvijrgsNckf,drg 5:
DpjrckidljsMctds ogj`rc)8
rjkupjrckil ogj`rc rjockidlco
cktucoizckil8 ilsjrtcr/ tupoc) kdlsimjrckil c ods = kdlstrcilt `drrcr/ tupoc) kdlsimjrckil c 3 kdlstrcilt Fdmieikcr ctri`utd) kdlsimjrckidljs iguco quj `drrc
Fjtc&mctds MMO)8 krjckil mj jsqujfc
Krjcr jsqujfc Krjcr mdfilids Krjcr rjockidljs jspjkieikc ldf`rj/ ctri`utds/ tipds y
kdlstrcilts)
7/22/2019 Bases de Datos | UDG 2005
66/185
hcvijrgsNckf,drg 55
ogj`rc rjockidlco
Fclipuocr iledrfckilrjockil" rjockidl
Dpjrckidljs8
]jdrc mj kdlhultds kdlhultds mj tupocs)8ulil/ iltjrsjkkil/ miejrjlkic/ prdmuktdkcrtjsicld
Jspjkieikcs mj @M8 sjojkt/ prdhjkt/ hdil
7/22/2019 Bases de Datos | UDG 2005
67/185
hcvijrgsNckf,drg 57
sjojktGjljrc ul su`kdlhultd mj tupocs ckdrmj c ulc kdlmikil
[ cttri`utd 6 vcodr"PJOCKIDL)
[j gjljrc jl mdfilids drmjlcmds kdfpcrckil) y lddrmjlcmds, sdod 6 y #6)
Dpjrcmdr ulcrid cpoikc c 3 rjockil)
Js kdlfutctivd y cpoikc`oj jl kcskcmc
Grcmd 6 + mj ctri`utds jl oc rjockil
[jojktivimcm 6 + tupocs d`tjlimcs
7/22/2019 Bases de Datos | UDG 2005
68/185
hcvijrgsNckf,drg 52
prdhjkt
[jojkkidlc ctri`utds mjskcrtclmd dtrds
^ctri`utd3/ctri`utdLPJOCKIDL)
Grcmd 6 + ctri`utds
[j joifilcl tupocs mupoikcmcs kdfd pcrtj mj
oc dpjrckil
^dr jood ld js kdlfutctivc oc dpjrckil
7/22/2019 Bases de Datos | UDG 2005
69/185
hcvijrgsNckf,drg 59
Jxprjsil ogj`rc Pjockidlco
^ctri`utd[ctri`utd6vcodrPJOCKIDL))
R"[ctri`utd6vcodrPJOCKIDL)1
Y" ^ctri`utdR)1
Yldf`rjs ctri`utds lujvds)" ^ctri`utdR)1
7/22/2019 Bases de Datos | UDG 2005
70/185
hcvijrgsNckf,drg 7>
Dpjrckidljs mj kdlhultds
Cpoikcl c mds rjockidljs kdl jo fisfd tipd mjtupocs y gjljrc ulc lujvc rjockil
ZLIDL8 ulir joifilclmd mupoikcmdscsdkictivc ykdlfutctivc)
IL]JP[JKKIDL8 tupocs jl cf`ds kdlhultds
csdkictivc y kdlfutctivc)
MIEJPJLKIC8 tupoc jl C y ld jl @ ld kdlfutctivc)
7/22/2019 Bases de Datos | UDG 2005
71/185
hcvijrgsNckf,drg 73
Dpjrckidljs mj kdlhultds
^PDMZK]D KCP]J[ICLD8 cpoikc`oj sd`rjrjockidljs kdl mistiltcs tupocs ldkdfpcti`ojs)
[j sufcl grcmd mj ctri`utds
[j fuotipoikcl grcmd mj tupocs
Jo rjsuotcmd ld js tio, Mj`j kdf`ilcrsj kdlulc sjojkkil
7/22/2019 Bases de Datos | UDG 2005
72/185
hcvijrgsNckf,drg 70
Dpjrckidljs mj kdlhultds
HDIL |R|8 kdf`ilc tupocs rjockidlcmcs,
R" PJOCKIDL|R|ctt6vco PJOCKIDL
HDIL gjlrikd8 cpoikc dpjrcmdrjs rjockidlcojs
JSZIHDIL8 cpoikc sdod jo dpjrcmdr 6
LC]ZPCO HDIL8 () js ul jquihdil kdl 3 ctri`utd
kdful
R" PJOCKIDL(ctts)/"ctts) PJOCKIDL
7/22/2019 Bases de Datos | UDG 2005
73/185
hcvijrgsNckf,drg 7;
prd`ojfcs #
[jojkkil/ ^rdyjkkil/ Zlil/ Miejrjlkic y^rdmuktd,
Iltjrsjkkil 6
Hdil 6
Lcturco Hdil 6
7/22/2019 Bases de Datos | UDG 2005
74/185
hcvijrgsNckf,drg 7=
prd`ojfcs #
Mivisil8ods y ctri`utds jl P y ld jl [/jquivcoj c8
t3" ^y P)
t0" ^y t3 R [ ) P)
]" t3&t0
Suj rjsuotc mj P[) ( [ 4
Su pcsc kdl ocs tupocs rdhcs4
7/22/2019 Bases de Datos | UDG 2005
75/185
hcvijrgsNckf,drg 7:
]crjc :
]rcmukkil mj fdmjod JP c Pjockidlco
Kdlsuotcs `sikcs sd`rj jo fdmjodPjockidlco/ kdlsimjrclmd ocsljkjsimcmjs mjo sistjfc
Mumcs c jstumicr#
7/22/2019 Bases de Datos | UDG 2005
76/185
hcvijrgsNckf,drg 75
Jhjrkikid mj Pjpcsd
7/22/2019 Bases de Datos | UDG 2005
77/185
hcvijrgsNckf,drg 77
7/22/2019 Bases de Datos | UDG 2005
78/185
hcvijrgsNckf,drg 72
7/22/2019 Bases de Datos | UDG 2005
79/185
hcvijrgsNckf,drg 79
Dpjrckidljs cmikidlcojs
Eulkidljs8[ZF/ CUJPCGJ/ FCR/ FIL/ KDZL]
ctri`utdEeulkidl ctri`utd rjockil)
7/22/2019 Bases de Datos | UDG 2005
80/185
hcvijrgsNckf,drg 2>
Dpjrcmdrjs cmikidlcojs
HDIL LC]ZPCO tupocs quj ld jltrcl c oc rjockil y$d luoo) sj joifilcl
OJE] DZ]JP HDIL 6|R|
PIGB] DZ]JP HDIL |R|6
EZOO DZ]JP HDIL 6|R|6
DZ]JP ZLIDL8 ulidl mj tupocs mistiltds ctri`utdsld kdfpcti`ojs)
7/22/2019 Bases de Datos | UDG 2005
81/185
hcvijrgsNckf,drg 23
y cbdrc JP c Pjockidlco
Crtkuods mj ul vdoufjl
Cutdrjs) mj ul crtikuod
Crtikuod tituod cutdr jmcm rjvisdr ldf`rj
[jkkil ldf`rj/ crtikuod ldf`rj/ cutdrldf`rj
Pjvisdr pdr cutdr
7/22/2019 Bases de Datos | UDG 2005
82/185
hcvijrgsNckf,drg 20
Jhjrkikid
7/22/2019 Bases de Datos | UDG 2005
83/185
hcvijrgsNckf,drg 2;
7/22/2019 Bases de Datos | UDG 2005
84/185
hcvijrgsNckf,drg 2=
>9, [SO
7/22/2019 Bases de Datos | UDG 2005
85/185
hcvijrgsNckf,drg 2:
[SO
Kdfclmd mj [SO,
Pjkupjrckil mj Mctds8[JOJK],
Fclipuockil mj Mctds8 MFO)IL[JP]
MJOJ]J
Z^MC]J
Mjeilikil mj Mctds MMO)KPJC]JCO]JPMPD^
[jgurimcm mj ods Mctds8GPCL]
PJUDAJ
KdleirfckilKDFFI]
PDOO@CKA
7/22/2019 Bases de Datos | UDG 2005
86/185
hcvijrgsNckf,drg 25
[SO &MMOKPJC]J ]C@OJ ^PDUJJMDPJ[ "
[+ KBCP:) LD] LZOO/[LDF@PJ KBCP0>) LD] LZOO/[I]ZCKIDL [FCOOIL] LD] LZOO/KIZMCM KBCP3:) LD] LZOO/^PIFCPY AJY " [+ ) ) 1
KPJC]J ]C@OJ ^CP]J[ "
^+ KBCP5) LD] LZOO/^LDF@PJ KBCP0>) LD] LZOO/KDODP KBCP5) LD] LZOO/^J[D [FCOOIL] LD] LZOO/KIZMCM KBCP3:) LD] LZOO/^PIFCPY AJY " ^+ ) )1
KPJC]J ]C@OJ JLUID[ "
[+ KBCP:) LD] LZOO/^+ KBCP5) LD] LZOO/KCL] IL]JGJP LD] LZOO/^PIFCPY AJY " [+ / ^+ )/EDPJIGL AJY " [+ ) PJEJPJLKJ[ ^PDUJJMDPJ[/EDPJIGL AJY " ^+ ) PJEJPJLKJ[ ^CP]J[ ) 1
7/22/2019 Bases de Datos | UDG 2005
87/185
hcvijrgsNckf,drg 27
[SO&MFO[JOJK] [+/ [I]ZCKIDLEPDF PDUJJMDPJ[WBJPJ KIZMCM 6 ^crs1
[JOJK] ^PDUJJMDPJ[,[+/^PDUJJMDPJ[,[I]ZCKIDLEPDF PDUJJMDPJ[WBJPJ ^PDUJJMDPJ[,KIZMCM 6 ^crs1
[JOJK]MI[]ILK] ^+EPDF JLUID[1
[JOJK] ^CP]J[,^+/ ^jsd jl grcfds 6/ ^CP]J[,^J[D (=:=EPDF ^CP]J[1
[JOJK] (EPDF^PDUJJMDPJ[1
[JOJK] [+ / [I]ZCKIDLEPDF ^PDUJJMDPWBJPJ KIZMCM6^crsDPMJP @Y [I]ZCKIDLMJ[K1
[JOJK] ^PDUJJMDPJ[,( /^CP]J[,(EPDF ^PDUJJMDPJ[/ ^CP]J[WBJPJ ^PDUJJMDPJ[,KIZMCM 6^CP]J[,KIZMCM1
7/22/2019 Bases de Datos | UDG 2005
88/185
hcvijrgsNckf,drg 22
[SO&MFO[JOJK] ^PIFJPC,[+/ [JGZLMC,[+EPDF ^PDUJJMDP ^PIFJPC/ ^PDUJJMDP [JGZLMCWBJPJ ^PIFJPC,KIZMCM 6 [JGZLMC,KIZMCM
CLM ^PIFJPC,[+ ? [JGZLMC,[+1
[JOJK] [ZF KCL])EPDF JLUID[WBJPJ ^+ 6 ^01
[JOJK] ^+/ [ZF KCL])EPDF JLUID[GPDZ^ @Y ^+1
[JOJK] ^CP]J[,(
EPDF ^CP]J[WBJPJ ^CP]J[,LDF@PJ OIAJ @*1
[JOJK] ^PDUJJMDPJ[,LDF@PJEPDF PDUJJMDPJ[WBJPJ [+ IL
[JOJK] [+EPDF JLUID[WBJPJ ^+ 6 ^0
) 1
7/22/2019 Bases de Datos | UDG 2005
89/185
hcvijrgsNckf,drg 29
3>, Bjrrcfijltcs
7/22/2019 Bases de Datos | UDG 2005
90/185
hcvijrgsNckf,drg 9>
Iltjrljt ! M@F[
Wj` Koijlt
Wj` [jrvjr
B]FO
Drckoj/ Fy[SO/F[&[SO/ Iledrfix/
^dstgrjs/ jtk
Hcvc/ ^B^/ ^jro/^ytbdl/ F[,ljt/ jtk
Iltjrljt@csj mj mctds
prdgrcfckil
7/22/2019 Bases de Datos | UDG 2005
91/185
hcvijrgsNckf,drg 93
fysqocmfil &u rddt krjctj fym`
fysqo &u rddt fym` ? fym`,sqo
fy[SO
fym`
Im Eirst Ocst cmmrjss pdsitidl
3 @d` [fitb 302 Bjrj [t, Fcrajtilg Fclcgjr
0 Hdlb Pd`jrts =: ]bjrj [t, ]jojpbdlist
; @rcm Hdblsdl 3$;= Ldwbjrj @ovm Mddrfcl
7/22/2019 Bases de Datos | UDG 2005
92/185
hcvijrgsNckf,drg 90
pbp
-m` 6 fysqoTkdlljkt"odkcobdst"/ "rddt")1
fysqoTsjojktTm`"fym`"/-m`)1
-rjsuot 6 fysqoTqujry-sqo)1
-rjsuot 6 fysqoTqujry"[JOJK] ( EPDF jfpodyjjs"/-m )1
wbioj -fyrdw 6 fysqoTejtkbTcrrcy-rjsuot)) {
jkbd -fyrdwQ"im"V,-fyrdwQ"eirst"V,-fyrdwQ"ocst"V,?@P
7/22/2019 Bases de Datos | UDG 2005
93/185
hcvijrgsNckf,drg 9;
33, ^rdyjktd
7/22/2019 Bases de Datos | UDG 2005
94/185
hcvijrgsNckf,drg 9=
Jmitdrjsr`itrds
dpjrctivds
usucrids
usucrids
pu`oikckidljs jojktrlikcs
7/22/2019 Bases de Datos | UDG 2005
95/185
hcvijrgsNckf,drg 9:
]crjc 7
CK]IUIMCMJ[8
Iltjreckjs mj Zsucrid pcrc kcmc rdo Eulkidlcoimcmjs jspjrcmcs Jlockjs Iltjrckkidljs kdl oc @M Cloisis y misjd gjlrikd
^PDMZK]D[8
Fcpc mj lcvjgckil cifpojfjltcr
Cloisis mj Pjqujrifijltdssifpoj)
Misjd sifpoj)
@M rjockidlco rjvisil)
7/22/2019 Bases de Datos | UDG 2005
96/185
hcvijrgsNckf,drg 95
7/22/2019 Bases de Datos | UDG 2005
97/185
hcvijrgsNckf,drg 97
30, Jxcfjl ^crkico
7/22/2019 Bases de Datos | UDG 2005
98/185
hcvijrgsNckf,drg 92
Jxcfjl pcrkico
7/22/2019 Bases de Datos | UDG 2005
99/185
hcvijrgsNckf,drg 99
mumcs mjo jxcfjl
Kdfd sj rjprjsjltc ulc oocvj edrljc jl ulfdmjod J$P 4#
ld jxistjl oocvjs edrljcs jl jo fdmjod J$P
Oocvj prifcric/ kclmimctc/ chjlc$edrljc
Dtrcs4
7/22/2019 Bases de Datos | UDG 2005
100/185
hcvijrgsNckf,drg 3>>
3;, Iltrdmukkil c oc Ldrfcoizckil
7/22/2019 Bases de Datos | UDG 2005
101/185
hcvijrgsNckf,drg3>3
tjrfildodgcrjockil
tjrfildodgc rjockidlco
Fdmjod Pjockidlco ^rdgrcfcmdr Zsucridrjockil crkbivd tc`oc
tupoj "eioc) rjgistrd eioc
ctri`utd kcfpd kdouflc
C3
C0
Cl
:
0>
3
7/22/2019 Bases de Datos | UDG 2005
102/185
hcvijrgsNckf,drg3>0
^rd`ojfcs kcsd 3)
Luods dPjpjtimds
Y si odsPjpjtimds
[j jskri`jl fco
7/22/2019 Bases de Datos | UDG 2005
103/185
hcvijrgsNckf,drg3>;
^rd`ojfcs kcsd 0)
Jfpodyjj [cocry ^rdhjkt @umgjt Eulktidl
@rdwl 0> Fcrs 0 tjkblikiclGrjjl ;: Hupitjr 3: mjsigljrGrjjl ;: Ujlus 3: mjsigljrBdsails :: Ujlus 3: fclcgjrBdsails :: Hupitjr 3: kdlsuotcltBdsails :: Fcrs 0 kdlsuotcltFddrj =2 Fcrs 0 fclcgjr
Fddrj =2 Ujlus 3: mjsigljrAjfp =2 Ujlus 3: mjsigljrAjfp =2 Hupitjr 3: fclcgjr
Pjmulmclkic Mjspjrmikid mj
jspckid
Cktucoizckilkdfpoikcmc
Cldfcoc mj cktucoizckil mj
`drrcmd mj
ilsjrkil
7/22/2019 Bases de Datos | UDG 2005
104/185
hcvijrgsNckf,drg3>=
misjd mj `csj mj mctdsifpdrtclkic mjo fdmjod rjockidlco jstrukturcs cfpoics y gjljrcojs ifpdrtcltj kctjgdrc mj prdmuktds M@F[
fco misjd cldfcocs/ rjmulmclkic j ilkdlsistjlkics mj oc iledrfckil
ifpdsi`ioimcm pcrc rjprjsjltcr kijrtc iledrfckilfjtcs mjo misjd jvitcr iledrfckil rjmulmcltj y clfcoc csjgurcr quj ocs rjockidljs jltrj ods ctri`utds sjcl rjprjsjltcmcs eckioitcr oc vjrieikckil mj ocs cktucoizckidljs
ldrfcoizckil kdlvjrsil mj ulc rjockil kdl kijrtds prd`ojfcs c mds d fs rjockidljsquj ld tijljl tcojs prd`ojfcs
edrfcs ldrfcojs Kdmm)
7/22/2019 Bases de Datos | UDG 2005
105/185
hcvijrgsNckf,drg3>:
ldrfcoizckil
# tipds mj cldfcocs# edrfcs ldrfcojs
tklikcs pcrc ocprjvjlkil
3LE/ 0LE/ ;LE/ =LE/:LE# J, E, Kdmm 397>)
3LE/ 0LE/ ;LE# @dykj&Kdmm
@KLE# =LE/ :LE
3LE
0LE
;LE
@KLE
=LE
:LE
7/22/2019 Bases de Datos | UDG 2005
106/185
hcvijrgsNckf,drg3>5
jsjlkic mj ldrfcoizckil 6 cldfcocs
# mj fdmieikckil# cldfcoc mj joifilckil# cldfcoc mj ilsjrkil
sdoukil8mjskdfpdsikil
[IMCktivimcm Kudtc
[IM Cktivimcm Kudtc
3>> Jsqu 0>>
3:> Lctckil :>
37: [qucsb :>0>> Lctckil :>
cktivimcm
[IMCktivimcm Cktivimcm Kudtc
Cktivimcm Kudtc
Jsqu 0>>
Lctckil :>
[qucsb :>
[IM Cktivimcm
3>> Jsqu
3:> Lctckil
37: [qucsb0>> Lctckil
jst&ckt ckt&kdst
7/22/2019 Bases de Datos | UDG 2005
107/185
hcvijrgsNckf,drg3>7
jsjlkic mj ldrfcoizckil
kcmc rjockil ldrfcoizcmc tijlj ul sdod tjfc
si tijlj mds d fs/ mj`jr ercgfjltcrsj jl rjockidljs
kcmc vjz quj sj mivimc ulc rjockil/ js prd`c`oj qujsurhc oc ljkjsimcm mj krjcr ulc rjstrikkil mjiltjrrjockil
kuclmd sj jlkujltrc ulc rjockil kdl cldfcocs mjfdmieikckil/ sj ocs joifilc mivimijlmd oc rjockil jlmds d fs/ kcmc ulc mj ocs kucojs kdltjlmr ul sdodtjfc
7/22/2019 Bases de Datos | UDG 2005
108/185
hcvijrgsNckf,drg3>2
]crjc 2
Ldrfcoizckil
Edrfcs ldrfcojs `sikcs 3LE/ 0LE/ ;LE
Cmikidlcofjltj @KLE/ =LE y :LE
7/22/2019 Bases de Datos | UDG 2005
109/185
hcvijrgsNckf,drg3>9
7/22/2019 Bases de Datos | UDG 2005
110/185
hcvijrgsNckf,drg33>
3=, Ldrfcoizckil sifpojmjpjlmjlkics y mjskdfpdsikil)
7/22/2019 Bases de Datos | UDG 2005
111/185
hcvijrgsNckf,drg 333
ldrfcoizckil
# Mjpjlmjlkic eulkidlco
Fdldvcoucmc Fuotivcoucmc
# Mjskdfpdsikil ^rjsjrvcr ctri`utds Fjldr pjrmimc mj ulidl ^rjsjrvcr mjpjlmjlkic Ld rjmulmclkic
3LE
0LE
;LE
@KLE
=LE
:LE
7/22/2019 Bases de Datos | UDG 2005
112/185
hcvijrgsNckf,drg 330
mjpjlmjlkic eulkidlco
rjstrikkil mj iltjgrimcm pcrc jo fdmjod rjockidlco
mjskri`j ocs rjockidlcojs eulkidlcojs jltrj odsctri`utds mj ulc rjockil
ldtckilY X
Jhjfpod
jo vcodr mjo ctri`utd [cocrymjpjlmj eulkidlcofjltjmjo vcodr ctri`utd Jfpodyjj
Jfpodyjj[cocry
7/22/2019 Bases de Datos | UDG 2005
113/185
hcvijrgsNckf,drg 33;
mjpjlmjlkic eulkidlco
rjockil jltrj uld d fs ctri`utds
gjljrcoizckil mj oc ldkil mj oocvjt3/ t0 r t3t0 t3QAV t0QAV )
ldtckil
jstc mjpjlmjlkic eulkidlco sj vjrieikc jl P
t3/ t
0 r t
3QV 6 t
0QV t
3QV 6 t
0QV )
A js ul spjr oocvj mj P si A PA js ulc spjr oocvj si t3QAV6t0QAV t3QPV6t0QPV js mjkir/ t36t0)
7/22/2019 Bases de Datos | UDG 2005
114/185
hcvijrgsNckf,drg 33=
mjpjlmjlkic eulkidlco
Kdlsimjrclmd8
C @
C K
KG B
KG I
@ B
Ocs mjpjlmjlkics ifpoikcl ogikcfjltj8
C B
C # @K
KG # BI
7/22/2019 Bases de Datos | UDG 2005
115/185
hcvijrgsNckf,drg 33:
3LE
kufpoir kdl oc mjeilikil mj ulc tc`oc
# vcodrjs ctfikds# vcodrjs mj ul ctri`utd mdfilid# kcmc ctri`utd pdsjj ul ldf`rj likd# drmjl mj ods rjgistrds sil ifpdrtclkic# sil tupocs imltikcs oocvj kclmimctc)
[IMCktivimcm Kudtc
[IM Cktivimcm Kudtc
3>> Jsqu 0>>3:> Lctckil :>
37: [qucsb :>
0>> Lctckil :>
cktivimcm
7/22/2019 Bases de Datos | UDG 2005
116/185
hcvijrgsNckf,drg 335
Jstc jl3LE4
stumjlt fctrikuoc/ ldf`rj/ ejkbcTlckifijltd)
7/22/2019 Bases de Datos | UDG 2005
117/185
hcvijrgsNckf,drg 337
0LE
[IM Cktivimcm Kudtc
Cktivimcm Kudtc
Kudtc pcrkicofjltj mjpjlmijltjfisfcs cldfcocs mj fdmieikckil
ulc rjockil jst jl 0LE si tdmds susctri`utds quj ld sdl kocvjs mjpjlmjlpdr kdfpojtd mj oc kocvj
[IM Cktivimcm
3>> Jsqu
3>> Gdoe
3:> Lctckil
37: [qucsb
37: Lctckil
0>> Lctckil
0>> Gdoe
Cktivimcm Kudtc
Jsqu 0>>Gdoe 5:
Lctckil :>
[qucsb :>
[IM Cktivimcm [IM Cktivimcm
Cktivimcm Kudtc
[IM Cktivimcm Kudtc
3>> Jsqu 0>>
3>> Gdoe 5:
3:> Lctckil :>
37: [qucsb :>37: Lctckil :>
0>> Lctckil :>
0>> Gdoe 5:
cktivimcm
7/22/2019 Bases de Datos | UDG 2005
118/185
hcvijrgsNckf,drg 332
0LE jhjrkikid)
^crc oc rjockil8
^PJ[]CFD
" lufTsdkid/ ldf`rjTsdkid/ kdmToi`rd/ ejkTprjst/ jmitdrico/ pcs )
ocs kocvjs kclmimctcs sdl8lufTsdkid/ kdmToi`rd) y ldf`rjTsdkid/ kdmToi`rd)
Kdfd 0LE sj rjprjsjltc8
^PJ[]CFD3 lufTsdkid/ ldf`rjTsdkid/ kdmToi`rd/ ejkTprjst )
OI@PD kdmToi`rd/ jmitdrico/ pcs )
7/22/2019 Bases de Datos | UDG 2005
119/185
hcvijrgsNckf,drg 339
0LE kdlkousil)
ulc rjockil jst jl 0LE si tdmds susctri`utds quj ld sdl kocvjs mjpjlmjl pdrkdfpojtd mj oc kocvj,
ld pujmjl jxistirmjpjlmjlkics pcrkicojs#jl rjockidljs kdl oocvjs kdfpujstcs),
7/22/2019 Bases de Datos | UDG 2005
120/185
hcvijrgsNckf,drg 30>
Jstc jl 0LE4
stumjlt fctrikuoc+/ ldf`rj/ kocvjTkursd+/ kursd)fctrikuoc &< ldf`rjkocvjTkursd &< kursd
[3 "fctrikuoc/ ldf`rj)[0 "kocvjTkursd/ kursd)
[K "fctrikuoc/ kocvjTkursd)
7/22/2019 Bases de Datos | UDG 2005
121/185
hcvijrgsNckf,drg 303
;LE
[IM JmieikidJmieikid Kudtc
[IM Jmieikid Kudtc
3>> Pclmdopb 30>>
3:> Ilgjrsdoo 33>>
0>> Pclmdopb 30>>
0:> ^itail 33>>
;>> Pclmdopb 30>>
vivijlmculc rjockil jst jl ;LE si jstjl 0LE y ld tijlj mjpjlmjlkics]rclsitivcs 8
ods ctri`utds quj ld edrfcl pcrtj mj lilgulckocvj kclmimctc eckioitcl iledrfckil sodckjrkc mj ocs) kocvjs) y ld ckjrkc mj dtrdsctri`utds
[IM Jmieikid
3>> Pclmdopb
3:> Ilgjrsdoo
0>> Pclmdopb
0:> ^itail
;>> Pclmdopb
[IM Jmieikid[IM Jmieikid
Jmieikid Kudtc
Pclmdopb 30>>
Ilgjrsdoo 33>>
^itail 33>>
Jmieikid KudtcJmieikid Kudtc
7/22/2019 Bases de Datos | UDG 2005
122/185
hcvijrgsNckf,drg 300
;LE jhjrkikid)
^PJ[]CFD3" lufTsdkid/ ldf`rjTsdkid/ kdmToi`rd/ ejkTprjst )
OI@PD" kdmToi`rd/ jmitdrico/ pcs )
J[]C JL ;LE 4
[doukil8
OI@PD3 kdmToi`rd/ jmitdrico )
JMI]DPICO jmitdrico/ pcs )
7/22/2019 Bases de Datos | UDG 2005
123/185
hcvijrgsNckf,drg 30;
Jstc jl 0LE/ ;LE4
su`hjkt "kocvjTkursd/ ldf`rj/ ilstruktdr/ deeikj)
kocvjTkursd &< ldf`rj
kocvjTkursd &< ilstruktdrilstruktdr &< deeikj
s "kocvjTkursd/ ldf`rj/ ilstruktdr)ils "ilstruktdr/ deeikj)
7/22/2019 Bases de Datos | UDG 2005
124/185
hcvijrgsNckf,drg 30=
@KLE ul jstumicltj pujmj tjljr ulc d fs jspjkicoimcmjs ulc jspjkicoimcm pujmj tjljr vcrids fijf`rds mj oc eckuotcm kdfd kdlsjhjrds ul fijf`rd mj oc eckuotcm sod ifpcrtj csjsdrc jl ulc rjc mj jspjkicoimcm
[IM Jspjkicoimcm Ldf`rjE
[IM Ldf`rjE Jspjkicoimcm
Ldf`rjE Jspjkicoimcm
jl 3LE4jl 0LE4jl ;LE4jxistjl cldfcocs mj fdmieikckil4
csjsdr
[IM Jspjkicoimcm Ldf`rjE
3>>Fctjftikcs Kcukby
3:> ^sikdodgc Hulg
0>> Fctjftikcs Pijfcll
0:> Fctjftikcs Kcukby
;>> ^sikdodgc ^jros
;>> Fctjftikcs Pijfcll
ulc rjockil jst jl @KLE sikcmc mjtjrfilcltj irrjmuki`ojizq) js ulc kocvj kclmimctc
i,j,
R#C y C ld jstc jl RR js oocvj
K
7/22/2019 Bases de Datos | UDG 2005
125/185
hcvijrgsNckf,drg 30:
@KLE
ulc rjockil jst jl @KLE si kcmc mjtjrfilcltj js ulckocvj kclmimctc
[IM Jspjkicoimcm Ldf`rjE
3>>Fctjftikcs Kcukby
3:> ^sikdodgc Hulg
0>> Fctjftikcs Pijfcll
0:> Fctjftikcs Kcukby
;>> ^sikdodgc ^jros
;>> Fctjftikcs Pijfcll
csjsdr
[IM Jspjkicoimcm Ldf`rjE
[IM Ldf`rjE Jspjkicoimcm
Ldf`rjE Jspjkicoimcm
Ldf`rjE Fctjric
Kcukby FctjftikcsHulg ^sikdodgc
Pijfcll Fctjftikcs
^jros ^sikdodgc
[IM Ldf`rjE
3>> Kcukby
3:> Hulg
0>> Pijfcll
0:> Kcukby
;>> ^jros
;>> Pijfcll
jst&csj
csj&fctjric
;LE @KLE
7/22/2019 Bases de Datos | UDG 2005
126/185
hcvijrgsNckf,drg 305
;LEvs @KLE
Oc fcydrc mj ocs rjockidljs quj jstl jl ;LE jstl tcf`iljl @KLE,Ilerjkujltjfjltj/ ulc rjockil ;LE ld jst jl @KLE y stcsukjmj sdocfjltj si8
c) ocs oocvjs kclmimctcs jl oc rjockil sdl oocvjs kdfpujstcsjs mjkir/ ld sdl ctri`utds sdods)/
`) jxistj fs mj ulc oocvj kclmimctc jl oc rjockil/
k) ocs oocvjs ld sdl mishultcs/ js mjkir/ cogulcs kucoimcmjs jlocs oocvjs sdl kdfuljs,
Jo @KLE mieijrj mj ;LE sdocfjltj kuclmd bcy fcs mj ulcoocvj kclmimctc/ ocs oocvjs sdl kdfpujstcs y trcsocpcmcs,
J t ;LE @KLE4
7/22/2019 Bases de Datos | UDG 2005
127/185
hcvijrgsNckf,drg 307
Jstc jl ;LE/ @KLE4jlrdo "sld/ slcfj/ kld/ klcfj/ mctj&jlrdoojm)
Oocvjs kclmimctcs8
"sld/ kld)"sld/ klcfj)
"slcfj/ kld)"slcfj/ klcfj)
^rd`ojfcs8
sld &< slcfjkld &< klcfj
[doukidl8
sld/ slcfj)kld/ klcfj)
sld/ kld/ mctj&de&jlrdofjlt)
7/22/2019 Bases de Datos | UDG 2005
128/185
7/22/2019 Bases de Datos | UDG 2005
129/185
7/22/2019 Bases de Datos | UDG 2005
130/185
7/22/2019 Bases de Datos | UDG 2005
131/185
7/22/2019 Bases de Datos | UDG 2005
132/185
7/22/2019 Bases de Datos | UDG 2005
133/185
7/22/2019 Bases de Datos | UDG 2005
134/185
7/22/2019 Bases de Datos | UDG 2005
135/185
7/22/2019 Bases de Datos | UDG 2005
136/185
7/22/2019 Bases de Datos | UDG 2005
137/185
7/22/2019 Bases de Datos | UDG 2005
138/185
7/22/2019 Bases de Datos | UDG 2005
139/185
7/22/2019 Bases de Datos | UDG 2005
140/185
7/22/2019 Bases de Datos | UDG 2005
141/185
7/22/2019 Bases de Datos | UDG 2005
142/185
7/22/2019 Bases de Datos | UDG 2005
143/185
7/22/2019 Bases de Datos | UDG 2005
144/185
7/22/2019 Bases de Datos | UDG 2005
145/185
7/22/2019 Bases de Datos | UDG 2005
146/185
7/22/2019 Bases de Datos | UDG 2005
147/185
7/22/2019 Bases de Datos | UDG 2005
148/185
7/22/2019 Bases de Datos | UDG 2005
149/185
7/22/2019 Bases de Datos | UDG 2005
150/185
7/22/2019 Bases de Datos | UDG 2005
151/185
7/22/2019 Bases de Datos | UDG 2005
152/185
7/22/2019 Bases de Datos | UDG 2005
153/185
7/22/2019 Bases de Datos | UDG 2005
154/185
7/22/2019 Bases de Datos | UDG 2005
155/185
7/22/2019 Bases de Datos | UDG 2005
156/185
7/22/2019 Bases de Datos | UDG 2005
157/185
7/22/2019 Bases de Datos | UDG 2005
158/185
7/22/2019 Bases de Datos | UDG 2005
159/185
7/22/2019 Bases de Datos | UDG 2005
160/185
7/22/2019 Bases de Datos | UDG 2005
161/185
7/22/2019 Bases de Datos | UDG 2005
162/185
7/22/2019 Bases de Datos | UDG 2005
163/185
7/22/2019 Bases de Datos | UDG 2005
164/185
7/22/2019 Bases de Datos | UDG 2005
165/185
7/22/2019 Bases de Datos | UDG 2005
166/185
7/22/2019 Bases de Datos | UDG 2005
167/185
7/22/2019 Bases de Datos | UDG 2005
168/185
7/22/2019 Bases de Datos | UDG 2005
169/185
7/22/2019 Bases de Datos | UDG 2005
170/185
7/22/2019 Bases de Datos | UDG 2005
171/185
7/22/2019 Bases de Datos | UDG 2005
172/185
7/22/2019 Bases de Datos | UDG 2005
173/185
7/22/2019 Bases de Datos | UDG 2005
174/185
7/22/2019 Bases de Datos | UDG 2005
175/185
7/22/2019 Bases de Datos | UDG 2005
176/185
7/22/2019 Bases de Datos | UDG 2005
177/185
7/22/2019 Bases de Datos | UDG 2005
178/185
7/22/2019 Bases de Datos | UDG 2005
179/185
7/22/2019 Bases de Datos | UDG 2005
180/185
7/22/2019 Bases de Datos | UDG 2005
181/185
7/22/2019 Bases de Datos | UDG 2005
182/185
7/22/2019 Bases de Datos | UDG 2005
183/185
7/22/2019 Bases de Datos | UDG 2005
184/185
7/22/2019 Bases de Datos | UDG 2005
185/185