SQL. martes 4 de octubre de B. García Simontti.

(1)

(2)

B. García Simontti.

Introduccion

• SQL es un leguaje declarativo.

• Lenguaje de cuarta generación.

• Estrictamente relacionado con BD.

• Ansi e ISO.

(3)

Componentes.

• Agente SQL.

• Implementación SQL.

• Cliente SQL.

(4)

Modos de ejecución

• Ejecución directa (Sql interactivo).

• Ejecución incrustada o embebida.

• Clientes gráficos.

• Ejecución dinámica.

(5)

Proceso.

• Se analiza la instrucción. (sintaxis)

• Se comprueba el diccionario de datos.

• Se optimiza.

• Se ejecuta la sentencia y se muestra el resultado al

(6)

Elementos.

• Comandos

• DML.

• DQL.

• DDL.

• DCL.

• Clausulas.

• Operaciones.

• Funciones.

• Literales.

• Metadatos.

martes 4 de octubre de 2011

(7)

Normas de escritura.

• No se distinguen entre mayúsculas y minúsculas.

• Las instrucciones finalizan con el signo punto y

coma.

• Se pueden tabular las lineas para facilitar la

lectura.

(8)

DDL

Lenguaje de definición de datos.

(9)

Introducción.

• Es la parte de SQL que se encarga de la

definición de datos del SGBD.

• Creación, modificación y eliminación de los

objetos de una BD.

• Cada usuario posee un esquema.

• Ninguna instrucción DDL puede ser

(10)

Creación de BD.

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!'

!"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' '

!"#$

17,$8&9+#:+' ;7<' +;' =<;$>+' 8?+&?' -#&' >&;+' %+' %&:<;' ;$' ;+' :$+#+#' =?$@$*+,$<;'

4AB'!

**!"#"$"%&'()*+,+%#-"#.-/**

'!

-.-/01'

+#'+'8&;<'%+'C?&8+)3'

D*' 8<9&#%<' /01' %+' 8?+&8$7#' %+' -#&' >&;+' %+' %&:<;' +;'

234154' /15101-4

3'

D;:+'8<9&#%<'8?+&'-#&'>&;+'%+'%&:<;'8<#'+'#<9>?+'E-+';+'$#%$E-+3'D.+9=<F'

!"#$%#&'$%$($)#

!"#$%&'(!

G+?<'#<?9&9+#:+';+'$#%$8&#'9H;'=&?H9+:?<;3'D.+9=<'!=&?H9+:?<;'%+'C?&8*+)F'

!"#$%#&'$%$($)#

!"#$%&'!!

!

+,-.#&

"#$%&')*+,!

!

**/$0+,-.#)&**

-.!

!

/$0.1)%$1!#)&

/0!

!

**$"!2.3#*+,&**

!

!2$"$!%#"&)#%&

123/-/4!

!

**1$%.+1$*&!2$"$!%#"&)#%&**

5678!

!

**'$%$-.*#&**

"#$%&'/)9&:!

$4%+#0%#1'&+1

!

/$0).5#

!.00;<(!

!"#$#%&

'()+',-.-/0-(0,-.-.0+',-/+,I#' <;' +;:H#%&?+;' &8:-&+;J' -#&' >&;+' %+' %&:<;' +;' -#' 8<#.-#:<' %+' <>.+:<;'

=+#;&%<;'=&?&',+;:$<#&?'%&:<;3'D;:<;'<>.+:<;'+;:H#'8<#:+#$%<;'+#'

$!67$%&!

J'*<;'

+;E-+9&;';-++#'+;:&?'&;<8$&%<;'&'=+?K$'%+'-#'-;-&?$<'+#'=&?:$8-&?3''

D#'+'+;:H#%&?'/01'+L$;:+'+'8<#8+=:<'%+'

8&#9:)()

'E-+';$?@+'=&?&'&*9&8+#&?'

+;E-+9&;3'B;M'+'#<9>?+'8<9=+:<'%+'-#'<>.+:<'@+#%?M&'%&%<'=<?F'

='>?*+,+

6 %@A$%B'

6 +&C%>+!

/$' #<' ;+' $#%$8&' +' 8&:H<,<' ;+' :<9&' +' 8&:H<,<' =<?' %+K+8:<3' /$' #<' ;+' $#%$8&' +*'

+;E-+9&' ;+' +#:$+#%+' E-+' +' <>.+:<' +;:H' +#' +' +;E-+9&' &8:-&3' D#' C?&8+J'

8-&#%<';+'8?+&'-#'-;-&?$<J';+'8?+&'-#'+;E-+9&'8-5<'#<9>?+'+;'+'%+'-;-&?$<3'

!"#$#$&

**1201345-.-+0(/0,-**

5'6(2-.-/0,-+0(/0,-4+>+#' 8-9=$?' &;' ;$,-$+#:+;' ?+,&;' !?+,&;' %+' C?&8*+J' +#' <:?<;' /NA4' =<%?M&#'

8&9>$&?)F'

i

4+>+#'8<9+#O&?'8<#'-#&'*+:?&'

i

P<'%+>+#':+#+?'9H;'%+'(Q'8&?&8:+?+;'

i

/7<';+'=+?9$:+#'-:$$O&?'+:?&;'%+'&K&>+:<'!$#,R;)J'#I9+?<;'<'+*';$,#<'%+'

;->?&5&%<'!:&9>$R#'+*';$,#<'

;

'5'

<

J'=+?<'+;<;';+'-:$$O&#'%+'9&#+?&'+;=+8$&'

=<?'*<'E-+'#<';<#'?+8<9+#%&%<;)'

i

P<' =-+%+' S&>+?' %<;' :&>&;' 8<#' +' 9$;9<' #<9>?+' =&?&' +*' 9$;9<' +;E-+9&'

!=-+%+#'8<$#8$%$?'*<;'#<9>?+;';$'+;:H#'+#'%$;:$#:<;'+;E-+9&;)'

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!'

!"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' '

!"#$

17,$8&9+#:+' ;7*<' +;' =<;$>*+' 8?+&?' -#&' >&;+' %+' %&:<;' ;$' ;+' :$+#+#' =?$@$*+,$<;' 4AB'!!"#"$"%&'()*+,+%#-"#.-/'!-.-/01'+#'+*'8&;<'%+'C?&8*+)3'

D*' 8<9&#%<' /01' %+' 8?+&8$7#' %+' -#&' >&;+' %+' %&:<;' +;' 234154' /15101-43' D;:+'8<9&#%<'8?+&'-#&'>&;+'%+'%&:<;'8<#'+*'#<9>?+'E-+';+'$#%$E-+3'D.+9=*<F' !"#$%#&'$%$($)#!"#$%&'(! G+?<'#<?9&*9+#:+';+'$#%$8&#'9H;'=&?H9+:?<;3'D.+9=*<'!=&?H9+:?<;'%+'C?&8*+)F' !"#$%#&'$%$($)#!"#$%&'!! ! *+,-.*#&"#$%&')*+,! ! /$0*+,-.*#)&-.! ! /$0.1)%$1!#)&/0! ! $"!2.3#*+,& ! !2$"$!%#"&)#%&123/-/4! ! 1$%.+1$*&!2$"$!%#"&)#%&5678!

! '$%$-.*#&"#$%&'/)9&:!$4%+#0%#1'&+1!/$0).5#!.00;<(!

!"#$#%&

'()*+',-.*-/0-(0,*-.*-.0+',-/+,I#' *<;' +;:H#%&?+;' &8:-&*+;J' -#&' >&;+' %+' %&:<;' +;' -#' 8<#.-#:<' %+' <>.+:<;' =+#;&%<;'=&?&',+;:$<#&?'%&:<;3'D;:<;'<>.+:<;'+;:H#'8<#:+#$%<;'+#'$!67$%&!J'*<;' +;E-+9&;';-+*+#'+;:&?'&;<8$&%<;'&*'=+?K$*'%+'-#'-;-&?$<'+#'=&?:$8-*&?3''

D#'+*'+;:H#%&?'/01'+L$;:+'+*'8<#8+=:<'%+'8&#9:)()'E-+';$?@+'=&?&'&*9&8+#&?' +;E-+9&;3'B;M'+*'#<9>?+'8<9=*+:<'%+'-#'<>.+:<'@+#%?M&'%&%<'=<?F'

='>?*+,+6%@A$%B'6+&C%>+!

/$' #<' ;+' $#%$8&' +*' 8&:H*<,<' ;+' :<9&' +*' 8&:H*<,<' =<?' %+K+8:<3' /$' #<' ;+' $#%$8&' +*' +;E-+9&' ;+' +#:$+#%+' E-+' +*' <>.+:<' +;:H' +#' +*' +;E-+9&' &8:-&*3' D#' C?&8*+J' 8-&#%<';+'8?+&'-#'-;-&?$<J';+'8?+&'-#'+;E-+9&'8-5<'#<9>?+'+;'+*'%+*'-;-&?$<3'

!"#$#$&

12*01345-.*-+0(/0,-

5'6(2*-.*-/0,-+0(/0,-4+>+#' 8-9=*$?' *&;' ;$,-$+#:+;' ?+,*&;' !?+,*&;' %+' C?&8*+J' +#' <:?<;' /NA4' =<%?M&#' 8&9>$&?)F'

i

4+>+#'8<9+#O&?'8<#'-#&'*+:?&'

i

P<'%+>+#':+#+?'9H;'%+'(Q'8&?&8:+?+;'

i

/7*<';+'=+?9$:+#'-:$*$O&?'*+:?&;'%+*'&*K&>+:<'!$#,*R;)J'#I9+?<;'<'+*';$,#<'%+' ;->?&5&%<'!:&9>$R#'+*';$,#<';'5'<J'=+?<'+;<;';+'-:$*$O&#'%+'9&#+?&'+;=+8$&*' =<?'*<'E-+'#<';<#'?+8<9+#%&%<;)'

i

P<' =-+%+' S&>+?' %<;' :&>*&;' 8<#' +*' 9$;9<' #<9>?+' =&?&' +*' 9$;9<' +;E-+9&' !=-+%+#'8<$#8$%$?'*<;'#<9>?+;';$'+;:H#'+#'%$;:$#:<;'+;E-+9&;)'

(11)

Creación de tablas

• Nombres:

• Deben comenzar con una letra.

• No deben tener más de 30 caracteres.

• Solo se permiten letras del alfabeto, números o el underscore.

• No puede haber dos tablas con el mismo nombre en el mismo

esquema.

(12)

CREATE TABLE.

• Es la orden SQL que permite crear una Tabla.

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#'

!"#$

i

5$' 6"7' .$8-.878%' .$-' 9' -$:;%' 7' "-!' 6!9!;%!' %4*%<!7!' +=>' ?6$%'

3:69$'-$'4'6"7*'99!:!%'

345467

'!'"-!'#!;9!@'

i

A-' 9' .!4$' 7' B"' 9' -$:;%' #-)!' 46!.8$4' -' ;9!-.$' $' .!%!.#%4'

-!.8$-!94' ?6%:8#87$' 4C9$' -' !9)"-!4' ;!44' 7' 7!#$4@D' -#$-.4' 4' 4"9'

-#%.$:899!%' .$-' .$:899!4' 7$;942' A-' 9' 4#,-7!%' +=>' EE' ?%46*#!7$' 6$%'

F%!.9@'4'6"7-'"#8980!%'.$:899!4'7$;94'!9'6$-%'9'-$:;%'7*'9!'#!;9!'!'

G8-'7'/!.%9!'4-48;9'!'9!4':!HI4."9!4'?4'78G%*-.8!%,'-#%'

´)$&785$6µ

H'´)DFWXUDVµ@'

**!"#$%&'()+)&+,-)&**

A4'9!'$%7-'+=>'B"'6%:8#'.%!%'"-!'#!;9!2'J$%'7G*.#$'4%,'!9:!.-!7!'-'9'

46!.8$'H'4B":!'79'"4"!%8$'B"'.%!'9!'#!;9!2'+8-#!K84&'

!"#$%#&%$'(#

&

)!"#$!%&

*

+

&

'(%)*!+!,&)-&!

.

,

**'(%)*!+!/&0(-$%'&1.234(+!+&2(".)**

-

&*+.**

/

&

A3*:69$&'

!"#$%#&%$'(#

.4(5!!6(!".

,

'(%)*!.

0$"!1$",

78 ../

.

L%!'"-!'#!;9!'.$-'"-'4$9$'.!:6$'7'#86$'

89:6;9:<!

+C9$'4'6$7%,'.%!%'9!'#!;9!'48'*9'"4"!%8$'6$4**'9$4'6%:84$4'-.*4!%8$4'6!%!'

99$2' +8' 9!' #!;9!' 6%#-.*' !' $#%$' 4B":!' ?4"6$-8-7$' B"' 9' "4"!%8$' #-)!'

6%:84$'6!%!')%!;!%'#!;9!4'-'4'$#%$'4B":!@D'4'!-#6$-'!9'-$:;%'7*'9!'

#!;9!'D'9'-$:;%'79'4B"*:!&'

!"#$%#&%$'(#

.(2(9"$&3(:4(5!!6(!".

,

'(%)*!.

0$"!1$",

78 ../

.

./01023

456!7&#$&#84!7&

M' 9!' /$%!' 7' .%!%' #!;9!4D' /!H' B"' 8-78.!%' 9' #86$' 7' 7!#$4' 7' .!7!' .!:6$2'

5.48#!:$4'6"4'.$-$.%'9$4'784#8-#$4'#86$4'7*'7!#$42'A4#$4'4$-&'

**=*'$&->$-0.!!**

7->('!4'/2.)+&!3?5!

**@&+$A*!3?5!**

**7*B/(!**

NK#$'7'

!-./"%!'G83!'

6;9:9674:C

_6;9:C

_!

_D

_!

!

D!

6;9:C

!

D!

NK#$'7'

!-./"%!'

<!%8!;9*'

6;9:9674:!89:EFGHC

!

D!

89:6;9:!C

!

D

!

89:6;9:"C

!

D!

NK#$'7'

!-./"%!'G83!'

6!%!'

.!%!.#%4'

-!.8$-!9*4'

G97F@G95!6;9:9674:C

!

D!

G97F@G95!6;9:C

!

D!

G6;9:C

!

D

!

G6;9:C

!

D!

(13)

Tipos de datos

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#' !"#$

i

5$' 6"*7*' .$8-.878%' .$-' *9' -$:;%*' 7*' "-!' 6!9!;%!' %*4*%<!7!' +=>' ?6$%' *3*:69$'-$'4*'6"*7*'99!:!%'345467'!'"-!'#!;9!@'

i

A-' *9' .!4$' 7*' B"*' *9' -$:;%*' #*-)!' *46!.8$4' *-' ;9!-.$' $' .!%!.#*%*4' -!.8$-!9*4' ?6*%:8#87$' 4C9$' *-' !9)"-!4' ;!4*4' 7*' 7!#$4@D' *-#$-.*4' 4*' 4"*9*' *-#%*.$:899!%' .$-' .$:899!4' 7$;9*42' A-' *9' *4#,-7!%' +=>' EE' ?%*46*#!7$' 6$%' F%!.9*@'4*'6"*7*-'"#8980!%'.$:899!4'7$;9*4'!9'6$-*%'*9'-$:;%*'7*'9!'#!;9!'!' G8-'7*'/!.*%9!'4*-48;9*'!'9!4':!HI4."9!4'?4*'78G*%*-.8!%,'*-#%*'´)$&785$6µ H'´)DFWXUDVµ@' !"#$%&'()*+)&+*,-)& A4'9!'$%7*-'+=>'B"*'6*%:8#*'.%*!%'"-!'#!;9!2'J$%'7*G*.#$'4*%,'!9:!.*-!7!'*-'*9' *46!.8$'H'*4B"*:!'7*9'"4"!%8$'B"*'.%*!'9!'#!;9!2'+8-#!K84&'

!"#$%#&%$'(#&)!"#$!%&*+&'(%)*!+!,&)-&! . ,'(%)*!+!/&0(-$%'&1.234(+!+&2(".)-&***+./& A3*:69$&' !"#$%#&%$'(#.4*(5!!6(*!".,'(%)*!.0$"!1$",78../. L%*!'"-!'#!;9!'.$-'"-'4$9$'.!:6$'7*'#86$'89:6;9:<! +C9$'4*'6$7%,'.%*!%'9!'#!;9!'48'*9'"4"!%8$'6$4**'9$4'6*%:84$4'-*.*4!%8$4'6!%!' *99$2' +8' 9!' #!;9!' 6*%#*-*.*' !' $#%$' *4B"*:!' ?4"6$-8*-7$' B"*' *9' "4"!%8$' #*-)!' 6*%:84$'6!%!')%!;!%'#!;9!4'*-'*4*'$#%$'*4B"*:!@D'4*'!-#*6$-*'!9'-$:;%*'7*'9!' #!;9!'D'*9'-$:;%*'7*9'*4B"*:!&' !"#$%#&%$'(#.(2*(9"$&*3(:4*(5!!6(*!".,'(%)*!.0$"!1$",78../.

./01023

456!7&#$&#84!7&

M' 9!' /$%!' 7*' .%*!%' #!;9!4D' /!H' B"*' 8-78.!%' *9' #86$' 7*' 7!#$4' 7*' .!7!' .!:6$2' 5*.*48#!:$4'6"*4'.$-$.*%'9$4'784#8-#$4'#86$4'7*'7!#$42'A4#$4'4$-&'

=*'$&->$-0.!! 7->('!4'/2.)+&!3?5! @&+$A*!3?5!

7*B/(! N*K#$'7*' !-./"%!'G83!' 6;9:9674:C_6;9:C_!_D_! !D! 6;9:C!D! N*K#$'7*' !-./"%!' <!%8!;9*' 6;9:9674:!89:EFGHC!D! 89:6;9:!C!D! 89:6;9:"C!D! N*K#$'7*' !-./"%!'G83!' 6!%!' .!%!.#*%*4' -!.8$-!9*4' G97F@G95!6;9:9674:C!D! G97F@G95!6;9:C!D! G6;9:C!D! G6;9:C!D! !"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' ' -$!.*"/."01'' 2"/)!'3!#41+&*'567' 8*&.9$'567' 7+89:'%+' &#;<-=&' >&=$&?*+'@&=&' ;&=&;9+=+A' #&;$:#&*+A' :;2<8:;7'=>;?;=23?' @;?A<:BC!D' :;2<8:;7'=>;?'@;?A<:BC!D' :=>;?'@;?A<:BC!D' :@;?=>;?EC!D' :F%$*)!' B#9+=:A' @+C-+D:A'' !E'?59+A)' 5G;77<:2' ' B#9+=:A' #:=F&*+A' !G'?59+A)' <:23B3?' <:2' ' B#9+=:A'*&=,:A' !H'?59+A)' H<B<:2_{!+#'=+&*$%&%'#:'+A'+A9I#%&=J'@+=:'}' +A'F-5'-9$*$K&%:'+#'F-;<&A'?&A+A' %+'%&9:A)' ' B#9+=:A'' @=+;$A$L#' %+;$F&*' ' :IGH3?C!D' 4+;$F&*'%+' ;:F&'>&=$&?*+' J78;2'_-8IH73' -8IH73'K?3=<55<8:' ?3;7' :IGH3?' 4+;$F&*'%+' ;:F&'M$.&' :IG3?<=C"#$D' -3=<G;7C"#$D' :IGH3?C"#$D' J$.L&!' N+;<&A' -;23' -;23' N+;<&'5'<:=&' 2<G352;GK' 2<G352;GK' 2#9+=>&*:A' <:23?@;7' <:23?@;7' H))9$&1)!'M',"1&*")!' 1L,$;:A' H8873;:' H887' ' O$#&=$:A'' H<2' H<2'@;?A<:BC!D' @;?H<2C!D' ' ' ' ' martes 4 de octubre de 2011

(14)

Tipos de datos.

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' ' !"#$ -$!.*"/."01'' 2"/)!'3!#41+&*'567' 8*&.9$'567' 7+89:'%+' &#;<-=&' >&=$&?*+'@&=&' ;&=&;9+=+A' #&;$:#&*+A' :;2<8:;7'=>;?;=23?' @;?A<:BC!D' :;2<8:;7'=>;?'@;?A<:BC!D' :=>;?'@;?A<:BC!D' :@;?=>;?EC!D' :F%$*)!' B#9+=:A' @+C-+D:A'' !E'?59+A)' 5G;77<:2' ' B#9+=:A' #:=F&*+A' !G'?59+A)' <:23B3?' <:2' ' B#9+=:A'*&=,:A' !H'?59+A)' H<B<:2_{!+#'=+&*$%&%'#:'+A'+A9I#%&=J'@+=:'}' +A'F-5'-9$*$K&%:'+#'F-;<&A'?&A+A' %+'%&9:A)' ' B#9+=:A'' @=+;$A$L#' %+;$F&*' ' :IGH3?C!D' 4+;$F&*'%+' ;:F&'>&=$&?*+' J78;2'_-8IH73' -8IH73'K?3=<55<8:' ?3;7' :IGH3?' 4+;$F&*'%+'

;:F&'M$.&' :IG3?<=C"#$D'_-3=<G;7C"#$D_' :IGH3?C"#$D'

J$.L&!' N+;<&A' -;23' -;23' N+;<&'5'<:=&' 2<G352;GK' 2<G352;GK' 2#9+=>&*:A' <:23?@;7' <:23?@;7' H))9$&1)!'M',"1&*")!' 1L,$;:A' H8873;:' H887' ' O$#&=$:A'' H<2' H<2'@;?A<:BC!D' @;?H<2C!D' ' ' ' ' martes 4 de octubre de 2011

(15)

Tipos de datos.

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' ' -$!.*"/."01'' 2"/)!'3!#41+&*'567' 8*&.9$'567' 7+89:'%+' &#;<-=&' >&=$&?*+'@&=&' ;&=&;9+=+A' #&;$:#&*+A' :;2<8:;7'=>;?;=23?' @;?A<:BC!D' :;2<8:;7'=>;?'@;?A<:BC!D' :=>;?'@;?A<:BC!D' :@;?=>;?EC!D' :F%$*)!' B#9+=:A' @+C-+D:A'' !E'?59+A)' 5G;77<:2' ' B#9+=:A' #:=F&*+A' !G'?59+A)' <:23B3?' <:2' ' B#9+=:A'*&=,:A' !H'?59+A)' H<B<:2_{!+#'=+&*$%&%'#:'+A'+A9I#%&=J'@+=:'}' +A'F-5'-9$*$K&%:'+#'F-;<&A'?&A+A' %+'%&9:A)' ' B#9+=:A'' @=+;$A$L#' %+;$F&*' ' :IGH3?C!D' 4+;$F&*'%+' ;:F&'>&=$&?*+' J78;2'_-8IH73' -8IH73'K?3=<55<8:' ?3;7' :IGH3?' 4+;$F&*'%+' ;:F&'M$.&' :IG3?<=C"#$D' -3=<G;7C"#$D' :IGH3?C"#$D' J$.L&!' N+;<&A' -;23' -;23' N+;<&'5'<:=&' 2<G352;GK' 2<G352;GK' 2#9+=>&*:A' <:23?@;7' <:23?@;7' H))9$&1)!'M',"1&*")!' 1L,$;:A' H8873;:' H887' ' O$#&=$:A'' H<2' H<2'@;?A<:BC!D' @;?H<2C!D' '

'

(16)

Tipos de datos.

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#'

!"#$

'

**3*'$&-4$-0.!!**

5-4('!6'/2.)+&!789!

**:&+$;*!789!**

**3+/('!)*!<&+.!/+,+=(!**

5*6#$')%!-'

7$-)8#"9'

>?@A@>56A!9@AB6!:CD6>5'

_>9:C

_!

9:EB!

_>9:C!

:-'94"4$;

!!!

<8-!%8$'9*'

)%!-'7$-)8#"9'

CFE@AG!9@AB6!:CD6>5'

C9:C

!

A@H

':-'94"4$;

!

9:EB!A@H!

:-'94"4$;

!

C9:C!

="%!-#'7'%4#$'97'>!-"!7'4'/!%,'%?*%-.8!'4@7$'!'7$4'#8A$4'B%!.72'

!"#!$%&

C!%!'7$4'#6#$4'984A$->$4'9'7$4'48)"8-#4'#8A$4':B%!.7;&'

i

I@A>?@A! J

' C!%!' #6#$4' 9' 7$-)8#"9' D!%8!E72' +"' #!>!F$' 9A*-9' 9' 7!'

E!4' 9' 9!#$4' :-' B%!.7' 4' 9' GHHH;2' I-' B%!.7' 4' 77!>!'

I@A>?@A"

J'

A%$'4'A$48E7'4)"8%'"#8780!-9$'KLMNOLM2'

i

>?@AJ

'C!%!'#6#$4'9'7$-)8#"9'?83!':-'B%!.7'/!4#!'PHHH'.!%!.#%4;2''

i

E>?@AJ

'C!%!'7'!7>!.-!>8-#$'9'.!%!.#%4'-!.8$-!74'9'#*6#$'?83$'

i

EI@A>?@AJ

!

C!%!' 7' !7>!.-!>8-#$' 9' .!%!.#%4' -!.8$-!74' 9'

7$-)8#"9'D!%8!E72'I-'B%!.7'4*'77!>!'

EI@A>?@A"

2'

I-'#$9$4'4#$4'#8A$4'4'8-98.!-'7$4'#!>!F$4'-#%'A!%Q-#484'#%!4'7'-$>E%'97'

#8A$2' N$-D8-' A$-%' 4"?8.8-#' 4A!.8$' A!%!' !7>!.-!%' 7$4' D!7$%42' I-' *7' .!4$'

9'7$4'KLMNOLMPJ'-$'4'>!7)!4#!'4A!.8$'A$%'A$-%'>,4'4A!.8$'97'94!9$'R!'

S"'48'7'#6#$'4'>,4'AS"F$'S"'7'#!>!F$'8-98.!9$J'7'%4#$'97'4A!.8$'4*'

$."A!2'

**'()"*$%&**

I-'4#'.!AT#"7$'4'6A78.!-'7$4'#8A$4'-">Q%8.$4'A!%!'7'484#>!'B%!.7*U'A!%!'+VW'

4#,-9!%'.$-4"7#!%'7!'#!E7!'9'#8A$4'9*'9!#$42'

I-' B%!.7J' 7' #8A$'

EKLC6A

' 4' "-' ?$%>!#$' D%4,#87' S"' A%>8#' %A%4-#!%'

#$9$'#8A$'9'-X>%$42'+"'%!-)$'%.$)'-X>%$4'9'-#%'YH

ZY[H

'R'\J\\\\\\\\\\\'

]'YH

YP^

2'_"%!'9'4#$4'%!-)$4'B%!.7'9D"7D'"-'%%$%2'

W$4'-X>%$4'9.8>!74':-X>%$4'9'.$>!'?83!;'4'8-98.!-'.$-'

EKLC6AM

!

N

"

O

J'

9$-9' !" 4' 7!' A%.848@-' >,68>!' R' #" 4' 7!' 4.!7!' :-X>%$' 9' 9.8>!74' !' 7!'*

9%./!' 9' 7!' .$>!;2' C$%' 3>A7$J' `ab<IM' :^J[;' 8-98.!' S"' 4' %A%4-#!-'

-X>%$4'9'$./$'.8?%!4'9'A%.848@-'R'#%4'9.8>!742'W$4'9.8>!74'-'B%!.7'4'

**A%4-#!'.$-'*7'4%./(!P!.(!$(.!;+!$(,+J'**

C!%!'-X>%$4'-#%$4'4'8-98.!'

EKLC6AM

!

O

'9$-9'!"4'7'-X>%$'9'9T)8#$42'*

I4$'4'S"8D!7-#'!'`ab<IM:!JH;2'

C!%!'-X>%$4'9'.$>!'?7$#!-#':S"8D!7-#4'!'7$4'

1;(+/

!$'

)(%Q;*

'9*'>"./$4'

7-)"!34' 9' A%$)%!>!.8@-;' 48>A7>*-#' 4' 8-98.!' 7' #6#$'

EKLC6A

' 48-'

A%.848@-'-8'4.!7!2'

(17)

Restricciones

• PRIMARY KEY.

• NOT NULL.

• FOREIGN KEY.

(18)

Restricciones.

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!'

!"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' '

!""#

!"#$%&#!'"$!"#$%&'#(!!"#$%&()"*+,&")$*#!#-+$.#!+/0!

!"#$%&!'!()$*+%#'(

789:';+<=$9+'>&=?$&<'+*'#:=?<+'%+'-#&'>:*-=#&3'/$#9&@$8'

!"#$%&#!'"$&+,-.')/#.0#!!

%$,!+$&()"*+,&+,-.')1+%23&,!#)!+,-.')4&)5,! 7.+=;*:A'

!"#$%&#!'"$!"#$%&'#(!%$,!+$&()"*+,!")$*#!#)!")$*#6*,'#0& ,'*$!(-$!(."/")0$(

B' >&%&' >:*-=#&' 8+' *+' ;-+%+' &8$,#&<' -#' C&*:<' ;:<' %+D+>9:' %-<&#9+' 8-' ><+&>$E#' =+%$&#9+' *&' ;<:;$+%&%' -./01233' /+' ;-+%+' ;:#+<' +89&' ;<:;$+%&%' %-<&#9+' *&' ><+&>$E#':'=:%$D$>&>$E#'%+'*&'9&?*&F'&G&%$+#%:'*&';&*&?<&'-./0123'9<&8'+*'9$;:' %+'%&9:8'%+*'>&=;:'5'>:*:>&#%:'%+9<H8'+*'C&*:<'I-+'8+'%+8+&';:<'%+D+>9:3' 7.+=;*:A' (%$!#$&#!'"$!#'%2$&0,!1$,7!,*+'$%1829!+,-.')!!3!%(4!%51:;29! <')$2,!,*+'$%1==9:2&6$7!*"#!>?;20! 1&';&*&?<&'47JB"1K'8+';-+%+'&G&%$<'%-<&#9+'*&'><+&>$E#':'*&'=:%$D$>&>$E#'%+'*&' 9&?*&'!>:=&#%:'023.4'3052.)'

12343256

!"70!8))8$#"7(

"#&' <+89<$>>$E#' +8' -#&' >:#%$>$E#' %+' :?*$,&%:' >-=;*$=$+#9:' ;&<&' -#&' :' =H8' >:*-=#&8'%+'*&'9&?*&3'B'>&%&'<+89<$>>$E#'8+'*+';:#+'-#'#:=?<+F'+#'+*'>&8:'%+'#:' ;:#+<'-#'#:=?<+'!&*,:';:>:'<+>:=+#%&?*+)'+#9:#>+8'+*';<:;$:'L<&>*+'*+'>:*:>&' +*'#:=?<+'I-+'+8'-#'=#+=:9M>#$>:'>:#'+*'#:=?<+'%+'9&?*&F'>:*-=#&'5'9$;:'%+' <+89<$>>$E#3'

/-'8$#9&@$8',+#+<&*'+8A'

8(%$!#$&#!'"$&+,-.')/#.0#&9&&

&!"#$%&#!'"$&+,-.')/#.0#&8!66&9&+)6-7:;;& 1$#-<,!%2<,@)@#%,(!<<',<2)7#7)(=&&&

&&<<(),.#%!-,#&+,-.')A)(%'2$$2B+!==!%2<,A)(%'2$$2B+!1$,0&-+#(2& &<9(23&2)+%)C#-<,«=&

<>(),.#%!-,#&+,-.')A)(%'2$$2B+!%2<,A)(%'2$$2B+!1$,0&-+#(2&???2&

1&8'<+89<$>>$:#+8'9$+#+#'-#'#:=?<+F'8+';-+%+'N&>+<'I-+'8+&'*&'?&8+'%+'%&9:8'*&' I-+'*+8';:#,&'#:=?<+F';+<:'+#9:#>+8'8+<O&'><O;9$>:3'P:<'+8:'+8'=+.:<';:#+<*+'-#' #:=?<+'#:8:9<:8';&<&'I-+'8+&'=H8'DH>$*'%+'<+>:<%&<3''

1:8' #:=?<+8' %+' <+89<$>>$E#' #:' 8+' ;-+%+#' <+;+9$<' ;&<&' +*' =$8=:' +8I-+=&F' %+?+=:8' %+' ?-8>&<' #:=?<+8' Q#$>:83' 78' ?-+#&' $%+&' $#>*-$<' %+' &*,Q#' =:%:' +*'

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#'

!"#$

-$56%' 7' 8!' #!68!9' 8$4' .!5:$4' ;-<$8".%!7$4' =' 8' #;:$' 7' %4#%;..;>-' -' *8'

-$56%'7'8!'5;45!2'?$%'35:8$'

!"#$%&"'&!()

:$7%@!';-7;.!%'A"'8'.!5:$'

"')

7'8!'#!68!'!"#$%'#;-'"-!'.8!<':%;-.;:!8'B

3 CDEFCG'

4 HGI2'

J47' 8!' 5:%4!' K%!.8' 4' !.$-43!' 8!' 4;)";-#' %)8!' !' 8!' /$%!' 7' :$-%'

-$56%'!'8!4'%4#%;..;$-*4&'

i

L%4'8#%!4':!%!'8'-$56%'7*'8!'#!68!'

i

M!%,.#%'7'4"6%!=!7$'

i

L%4'8#%!4'.$-'8!'.$8"5-!'!N.#!7!':$%'8!'%4#%;..;>-'

i

M!%,.#%'7'4"6%!=!7$'

i

J$4' 8#%!4' .$-' 8!' !6%<;!#"%!' 78' #;:$' 7' %4#%;..;>-2' O!' !6%<;!#"%!' :"7'

4*%&'

x

55 2'PKL'PQOO2'

x

34 2'?CDEFCG'RHG'

x

64 2'QPDSQH'

x

74 2'TKCHDUP'RHG'

x

849 'MVHMR'B<!8;7!.;>-I'

?$%'35:8$':!%!'/!.%'A"'8!'.8!<':%;-.;:!8'7'8!'#!68!'

+,-./0'4!'*8'12'"3/)

**'#+)%+,-./9'8'-$56%'7'8!'%4#%;..;>-':$7%@!'4*%&'**

!"#$%&'$()*

**!"#$%&%"'()*#+'**

O!' %*4#%;..;>-'

5:;! 56<<

' :%5;#' :%$/;6;%' 8$4' -"8$4' -' "-!' 7#*%5;-!7!' #!68!2'

H4$'$68;)!'!'A"'8!'.$8"5-!'#-)!'A"'#-%'$68;)!#$%;!5-#'"-'<!8$%':!%!'A"'

4!'!85!.-!7$'8'%);4#%$2'

+':"7*'.$8$.!%'7"%!-#'8!'.%!.;>-' B$'5$7;N;.!.;>-I'78'.!5:$'!W!7;-7$'

8!':!8!6%!'PKL'PQOO'#%!4'*8'#;:$&'

!"#$%#&%$'(#

*%"+,-.,

)

'-+*

*$"!+$",)

/

-&./%&.0((-1

*

H-'4'.!4$'8'-$56%'8'.$8$.!'8!':%$:;!'6!4'7'7!#$4'B-'8'.!4$'7'K%!.8'8'

-$56%'4%@!'!8)$'.$5$'

**4566789:':$%'35:8$I2'P$'4'%.$5-7!68'-$':$-*%'**

-$56%'!'8!4'%4#%;..;$-4':!%!'.$-#%$8!%8!4'53$%2''

'

(19)

Restricciones

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#'

!"#$

-$56%' 7' 8!' #!68!9' 8$4' .!5:$4' ;-<$8".%!7$4' =' 8' #;:$' 7' %4#%;..;>-' -' *8'

-$56%'7'8!'5;45!2'?$%'35:8$'

!"#$%&"'&!()

:$7%@!';-7;.!%'A"'8'.!5:$'

"')

7*'8!'#!68!'

!"#$%

'#;-'"-!'.8!<*':%;-.;:!8'B

3 CDEFCG'

4 HGI2'

J47' 8!' 5:%4!' K%!.8' 4' !.$-43!' 8!' 4;)";-#' %)8!' !' 8!' /$%!' 7' :$-%'

-$56%'!'8!4'%4#%;..;$-*4&'

i

L%4'8#%!4':!%!'8'-$56%'7*'8!'#!68!'

i

M!%,.#%'7'4"6%!=!7$'

i

L%4'8#%!4'.$-'8!'.$8"5-!'!N.#!7!':$%'8!'%4#%;..;>-'

i

M!%,.#%'7'4"6%!=!7$'

i

J$4' 8#%!4' .$-' 8!' !6%<;!#"%!' 78' #;:$' 7' %4#%;..;>-2' O!' !6%<;!#"%!' :"7'

4*%&'

x

55 2'PKL'PQOO2'

x

34 2'?CDEFCG'RHG'

x

64 2'QPDSQH'

x

74 2'TKCHDUP'RHG'

x

849 'MVHMR'B<!8;7!.;>-I'

?$%'35:8$':!%!'/!.%'A"'8!'.8!<':%;-.;:!8'7'8!'#!68!'

*+,-./0

'4!'8'

12'"3/)

'#+)%+,-./

9'8'-$56%'7'8!'%4#%;..;>-':$7%@!'4*%&'

!"#$%&'$()*

**!"#$%&%"'()*#+'**

O!' %*4#%;..;>-'

5:;! 56<<

' :%5;#' :%$/;6;%' 8$4' -"8$4' -' "-!' 7#*%5;-!7!' #!68!2'

H4$'$68;)!'!'A"'8!'.$8"5-!'#-)!'A"'#-%'$68;)!#$%;!5-#'"-'<!8$%':!%!'A"'

4!'!85!.-!7$'8'%);4#%$2'

+':"7*'.$8$.!%'7"%!-#'8!'.%!.;>-' B$'5$7;N;.!.;>-I'78'.!5:$'!W!7;-7$'

8!':!8!6%!'PKL'PQOO'#%!4'*8'#;:$&'

!"#$%#&%$'(#

*%"+,-.,

)

'-+*

*$"!+$",)

/

-&./%&.0((-1

*

H-'4'.!4$'8'-$56%'8'.$8$.!'8!':%$:;!'6!4'7'7!#$4'B-'8'.!4$'7'K%!.8'8'

-$56%'4%@!'!8)$'.$5$'

4566789:

':$%'35:8$I2'P$'4'%.$5-7!68'-$':$-*%'

-$56%'!'8!4'%4#%;..;$-4':!%!'.$-#%$8!%8!4'53$%2''

'

rut

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' '

7&8&'9:#+8'+*'#:;<8+'=+'-=&>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-

!

!./0%"$1/%

!"#$(&$&&!

/.%&/2((-3

!

1&'8+=?8$@@$A#'

-./'-011'

+='&'B#$@&'C-+'=A:'=+'9-+%+'9:#+8'=+,-$%&'&*'#:;<8+'

%+' &' @:-;#&' &' &' C-+' =+' &9$@&' !*&' 8&DA#' +=' C-+'

-./' -011

' =A*:' =+' 9-+%+'

&9$@&8'&'-#'@&;9:'&'&'E+D)'

**!"#$%&'()*+,$'(**

1&=' 8+=?8$@@$:#+=' %+' ?$9:' "F20"G' :<$,&#' &' C-+' +' @:#?+#$%:' %+' -#&' :' ;H='

@:-;#&='#:'9-+%&#'8+9+?$8'E&:8+=3'F-+E&;+#?+'I&5'%:='J:8;&='%+'@:*:@&8'+=?&'

8+=?8$@@$A#>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-&2/142#-3&

G#'+=+'@&=:'+'#:;<8+'%+'&'8+=?8$@@$A#'&'@::@&'+*'=$=?+;&3'K?8&'J:8;&'+=>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-&&

& &

&

!./0%"$1/%

!(&$*+!

2/142#-3

!

G=?&'J:8;&'9+8;$?+'9:#+8'-#'#:;<8+'&'&'8+=?8$@@$A#3'/$'&'8+9+?$@$A#'%+'E&*:8+='

=+'8+J$+8+'&'E&8$:='@&;9:=L'*&'J:8;&'=+8M&>'

!"#$%#&%$'(#

!,#-+$#%.

)

(&$!

*$"!+$",)

)

-

/!!

! !

"0(*1%#$"+#,!

/25'#")

2 -

/!!

! !

!./0%"$1/%

!,#-+$#%.*+3!

2/142#)

(&$/"0(*1%#$"+#,

-&3

!

1&' @:;&' ?8&=' &' %+J$#$@$A#' %+' @&;9:'

!"#$%&'(!)'*

' I&@+' C-+' *&' 8+=?8$@@$A#' =+&'

$#%+9+#%$+#?+'%+'+=+'@&;9:3'G=:':<$,&'&'C-+L'?8&='"F20"G'=+'$#%$C-+'&'*$=?&'%+'

@&;9:=3'2#@-=:'9&8&'-#'=::'@&;9:'=+'9-+%+'@::@&8'&'8+=?8$@@$A#'&'J$#&'%+'*&'

$=?&'+#'-,&8'%+'%+J$#$8:'&'@:#?$#-&@$A#'%+'#:;<8+'5'?$9:'%+'&'@:-;#&3'

1&='@*&E+='@&#%$%&?&='%+<+#'**+E&8'8+=?8$@@$:#+='

0-2304

'5'

-./'-011'

,#"!&(-%+."%+"(

1&' @&E+' 98$;&8$&' %+' -#&' ?&<&' &' J:8;&#' &=' @:*-;#&=' C-+' $#%$@&#' &' @&%&'

8+,$=?8:'%+'&';$=;&3'1&'@&E+'98$;&8$&'I&@+'C-+':='@&;9:='C-+'&'J:8;&#'=+&#'

FKN'F"11'!=$#'9:=$<$$%&%'%+'C-+%&8'E&@M:=)'5'C-+':='E&:8+='%+':='@&;9:='=+&#'

%+'?$9:'"F20"G'!=$#'9:=$<$*$%&%'%+'8+9+?$@$A#)3'

/$'&'@&E+'+=?H'J:8;&%&'9:8'-#'=:*:'@&;9:'<&=?&'@:#>'

!"#$%#&%$'(#

!"#$%&'%

)

!

! (&$!

*$"!+$")

)

-

!

6"15$"7&8#7

/!

! &045.%!

*$"!+$")

26 --&3&

'

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' '

!"#$

7&8&'9:#+8'+*'#:;<8+'=+'-=&>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-

!

!./0%"$1/%

!"#$(&$&&!

/.%&/2((-3

!

1&'8+=?8$@@$A#'

-./'-011'

+='&'B#$@&'C-+'=A:'=+'9-+%+'9:#+8'=+,-$%&'&*'#:;<8+'

%+' &' @:-;#&' &' &' C-+' =+' &9$@&' !*&' 8&DA#' +=' C-+'

-./' -011

' =A*:' =+' 9-+%+'

&9$@&8'&'-#'@&;9:'&'&'E+D)'

**!"#$%&'()*+,$'(**

1&=' 8+=?8$@@$:#+=' %+' ?$9:' "F20"G' :<$,&#' &' C-+' +' @:#?+#$%:' %+' -#&' :' ;H='

@:-;#&='#:'9-+%&#'8+9+?$8'E&:8+=3'F-+E&;+#?+'I&5'%:='J:8;&='%+'@:*:@&8'+=?&'

8+=?8$@@$A#>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-&2/142#-3&

G#'+=+'@&=:'+'#:;<8+'%+'&'8+=?8$@@$A#'&'@::@&'+*'=$=?+;&3'K?8&'J:8;&'+=>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-&&

& &

&

!./0%"$1/%

!(&$*+!

2/142#-3

!

G=?&'J:8;&'9+8;$?+'9:#+8'-#'#:;<8+'&'&'8+=?8$@@$A#3'/$'&'8+9+?$@$A#'%+'E&*:8+='

=+'8+J$+8+'&'E&8$:='@&;9:=L'*&'J:8;&'=+8M&>'

!"#$%#&%$'(#

!,#-+$#%.

)

(&$!

*$"!+$",)

)

-

/!!

! !

"0(*1%#$"+#,!

/25'#")

2 -

/!!

! !

!./0%"$1/%

!,#-+$#%.*+3!

2/142#)

(&$/"0(*1%#$"+#,

-&3

!

1&' @:;&' ?8&=' &' %+J$#$@$A#' %+' @&;9:'

!"#$%&'(!)'*

' I&@+' C-+' *&' 8+=?8$@@$A#' =+&'

$#%+9+#%$+#?+'%+'+=+'@&;9:3'G=:':<$,&'&'C-+L'?8&='"F20"G'=+'$#%$C-+'&'*$=?&'%+'

@&;9:=3'2#@-=:'9&8&'-#'=::'@&;9:'=+'9-+%+'@::@&8'&'8+=?8$@@$A#'&'J$#&'%+'*&'

$=?&'+#'-,&8'%+'%+J$#$8:'&'@:#?$#-&@$A#'%+'#:;<8+'5'?$9:'%+'&'@:-;#&3'

1&='@*&E+='@&#%$%&?&='%+<+#'**+E&8'8+=?8$@@$:#+='

0-2304

'5'

-./'-011'

,#"!&(-%+."%+"(

1&' @&E+' 98$;&8$&' %+' -#&' ?&<&' &' J:8;&#' &=' @:*-;#&=' C-+' $#%$@&#' &' @&%&'

8+,$=?8:'%+'&';$=;&3'1&'@&E+'98$;&8$&'I&@+'C-+':='@&;9:='C-+'&'J:8;&#'=+&#'

FKN'F"11'!=$#'9:=$<$$%&%'%+'C-+%&8'E&@M:=)'5'C-+':='E&:8+='%+':='@&;9:='=+&#'

%+'?$9:'"F20"G'!=$#'9:=$<$*$%&%'%+'8+9+?$@$A#)3'

/$'&'@&E+'+=?H'J:8;&%&'9:8'-#'=:*:'@&;9:'<&=?&'@:#>'

!"#$%#&%$'(#

!"#$%&'%

)

!

! (&$!

*$"!+$")

)

-

!

6"15$"7&8#7

/!

! &045.%!

*$"!+$")

26 --&3&

'

rut

(20)

Restricciones

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' '

!"#$

7&8&'9:#+8'+*'#:;<8+'=+'-=&>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-

!

!./0%"$1/%

!"#$(&$&&!

/.%&/2((-3

!

1&'8+=?8$@@$A#'

-./'-011'

+='&'B#$@&'C-+'=A:'=+'9-+%+'9:#+8'=+,-$%&'&*'#:;<8+'

%+' &' @:-;#&' &' &' C-+' =+' &9$@&' !*&' 8&DA#' +=' C-+'

-./' -011

' =A*:' =+' 9-+%+'

&9$@&8'&'-#'@&;9:'&'&'E+D)'

**!"#$%&'()*+,$'(**

1&=' 8+=?8$@@$:#+=' %+' ?$9:' "F20"G' :<$,&#' &' C-+' +' @:#?+#$%:' %+' -#&' :' ;H='

@:-;#&='#:'9-+%&#'8+9+?$8'E&:8+=3'F-+E&;+#?+'I&5'%:='J:8;&='%+'@:*:@&8'+=?&'

8+=?8$@@$A#>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-&2/142#-3&

G#'+=+'@&=:'+'#:;<8+'%+'&'8+=?8$@@$A#'&'@::@&'+*'=$=?+;&3'K?8&'J:8;&'+=>'

!"#$%#&%$'(#

!"#$%&'%

)

(&$!

*$"!+$",)

)

-&&

& &

&

!./0%"$1/%

!(&$*+!

2/142#-3

!

G=?&'J:8;&'9+8;$?+'9:#+8'-#'#:;<8+'&'&'8+=?8$@@$A#3'/$'&'8+9+?$@$A#'%+'E&*:8+='

=+'8+J$+8+'&'E&8$:='@&;9:=L'*&'J:8;&'=+8M&>'

!"#$%#&%$'(#

!,#-+$#%.

)

(&$!

*$"!+$",)

)

-

/!!

! !

"0(*1%#$"+#,!

/25'#")

2 -

/!!

! !

!./0%"$1/%

!,#-+$#%.*+3!

2/142#)

(&$/"0(*1%#$"+#,

-&3

!

1&' @:;&' ?8&=' &' %+J$#$@$A#' %+' @&;9:'

!"#$%&'(!)'*

' I&@+' C-+' *&' 8+=?8$@@$A#' =+&'

$#%+9+#%$+#?+'%+'+=+'@&;9:3'G=:':<$,&'&'C-+L'?8&='"F20"G'=+'$#%$C-+'&'*$=?&'%+'

@&;9:=3'2#@-=:'9&8&'-#'=::'@&;9:'=+'9-+%+'@::@&8'&'8+=?8$@@$A#'&'J$#&'%+'*&'

$=?&'+#'-,&8'%+'%+J$#$8:'&'@:#?$#-&@$A#'%+'#:;<8+'5'?$9:'%+'&'@:-;#&3'

1&='@*&E+='@&#%$%&?&='%+<+#'**+E&8'8+=?8$@@$:#+='

0-2304

'5'

-./'-011'

,#"!&(-%+."%+"(

1&' @&E+' 98$;&8$&' %+' -#&' ?&<&' &' J:8;&#' &=' @:*-;#&=' C-+' $#%$@&#' &' @&%&'

8+,$=?8:'%+'&';$=;&3'1&'@&E+'98$;&8$&'I&@+'C-+':='@&;9:='C-+'&'J:8;&#'=+&#'

FKN'F"11'!=$#'9:=$<$$%&%'%+'C-+%&8'E&@M:=)'5'C-+':='E&:8+='%+':='@&;9:='=+&#'

%+'?$9:'"F20"G'!=$#'9:=$<$*$%&%'%+'8+9+?$@$A#)3'

/$'&'@&E+'+=?H'J:8;&%&'9:8'-#'=:*:'@&;9:'<&=?&'@:#>'

!"#$%#&%$'(#

!"#$%&'%

)

!

! (&$!

*$"!+$")

)

-

!

6"15$"7&8#7

/!

! &045.%!

*$"!+$")

26 --&3&

'

rut

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#' !"#$ 56'7$-8*-9$'"-'-$:;%*'!'<!'%*4#%8..8=-&'

!"#$%#&%$'(#!"#$%&'%)&

! (&$!*$"!+$")),&!-./%"$0.%!"#$%&'%*+,!1"02$"3&4#3-! ! &./01%!*$"!+$")23,,&5& +8'<!'.<!>*'*4#,'?$%:!9!'7$%':,4'9*'"-'.!:7$&' ' !"#$%#&%$'(#!4#56$#%1)(&$!*$"!+$")),-!! ! ! ".(*+%#$"6#4!.62'#")2,-!! ! ! !-./%"$0.%!4#56$#%1*+,!! ! ! ! 1"02$"3!4#3)(&$-".(*+%#$"6#4,,&5! !"#$%&'%!()*#+,#&-&.-+/)%#& @-!' .<!>*' 4*."-9!%8!' $' ?$%,-*!6' *4' "-$' $' :,4' .!:7$4' 9*' "-!' #!;<!' A"*' *4#,-' %*<!.8$-!9$4' .$-' <!' .<!>*' 7%8-.87!<' B$' 8-.<"4$' .$-' "-!' .<!>*' .!-989!#!C' 9*' $#%!' #!;<!2'' D!' ?$%:!' 9*' 8-98.!%' "-!' .<!>*' ?$%,-*!' B!7<8.!-9$' "-!' %*4#%8..8=-' 9*' 8-#*)%89!9'%*?*%*-.8!<C'*4&' 789:;9!;:<=9!4#56$#%1>! (&$!?:87@:8A>)B!!-./%"$0.%&789:;<&"#=#"#.!#/&>?9@8A@B)789,C& ! ".(*+%#$"6#4!CDE<98>2B!!-./%"$0.%&D@?9>E?F:;<&&

& & & & & & "#=#"#.!#/&D@?9>E?FB)>G7,C&

!!7FCG;8:HC;!4#56$#%1*+,!I8HE:8J!K9J>(&$-".(*+%#$"6#4B! BL! +8)-8?8.!' *4#!' 8-4#%"..8=-' B*-' ."!-#$' !' .<!>*4' ?$%,-*!4C' A"*' *<' .!:7$' !"#' 4*' %*<!.8$-!'.$-'<!'.$<":-!'!"#'9*'<!'#!;<!'$%#&"'&(2)) +8' *<'.!:7$'!<'A"*' 4*' /!.*'%*?*%*-.8!'*4'<!'.<!>*'7%8-.87!<6'4*'7"*9*'$;>8!%'*<' -$:;%*'9*<'.!:7$&' 789:;9!;:<=9!4#56$#%1>! (&$!?:87@:8A>)B!!-./%"$0.%&789:;<&"#=#"#.!#/&>?9@8A@BC& ! ".(*+%#$"6#4!CDE<98>2B!!-./%"$0.%&D@?9>E?F:;<&& & & "#=#"#.!#/&D@?9>E?FBC&

!!7FCG;8:HC;!4#56$#%1*+,!I8HE:8J!K9J>(&$-".(*+%#$"6#4B! BL! E-' *4#*' .!4$' 4*' *-#8*-9*' A"*' <$4' .!:7$4' /!.*-' %*?*%*-.8!' !' <!4' .<!>*4' 7%8-.87!<*4'9*'<!4'#!;<!4'%*?*%*-.8!9!4'B48'<!'%*<!.8=-'<!'?$%:!':,4'"-'.!:7$6'*<' $%9*-'9*'<$4'.!:7$4'9*;*'9*'4*%'*<':84:$C2' E4#$' ?$%:!' "-!' %*<!.8=-' *-#%*' 98./!4' #!;<!46' A"*' !9*:,4' $;<8)!' !<' .":7<8:8*-#$' 9*' <!' -./*3&-)+)! &*1*&*.$-+45' E4#!' 8-#*)%89!9' $;<8)!' !' A"*' ."!<A"8*%'!"#'8-.<"89$'*-''<!'#!;<!'*%+,#%&-'#*-)!'A"*'*4#!%'$;<8)!#$%8!:*-#*'*-' <!' #!;<!' 9*' .<8*-#*42' F*' -$' 4*%' !4G' *<' %*)84#%$' -$' 4*%,' 8-4*%#!9$' *-' <!' #!;<!' B$."%%8%,'"-'*%%$%C2'

rut

(21)

Restricciones

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('!

!"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#'

56'7$-8-9$'"-'-$:;%'!'<!'%*4#%8..8=-&'

!"#$%#&%$'(#

!"#$%&'%

)&

! (&$!

*$"!+$")

)

,&!-./%"$0.%

!"#$%&'%*+,!

1"02$"3&4#3

-!

! &./01%!

*$"!+$")

23 ,,&5&

+8'<!'.<!>'4#,'?$%:!9!'7$%':,4'9*'"-'.!:7$&'

'

!"#$%#&%$'(#

!4#56$#%1

)

(&$!

*$"!+$")

)

,

-!!

! !

".(*+%#$"6#4!

.62'#")

2 ,

-!!

! !

!-./%"$0.%

!4#56$#%1*+,!!

! !

!

1"02$"3

!

4#3)

(&$-".(*+%#$"6#4

,,&5

!

**!"#$%&'%!()*#+,#&-&.-+/)%#&**

@-!' .<!>' 4."-9!%8!' $' ?$%,-!6' 4' "-$' $' :,4' .!:7$4' 9' "-!' #!;<!' A"' *4#,-'

%<!.8$-!9$4' .$-' <!' .<!>' 7%8-.87!<' B$' 8-.<"4$' .$-' "-!' .<!>' .!-989!#!C' 9' $#%!'

#!;<!2''

D!' ?$%:!' 9' 8-98.!%' "-!' .<!>' ?$%,-!' B!7<8.!-9$' "-!' %4#%8..8=-' 9*'

8-#)%89!9'%?*%-.8!<C'4&'

789:;9!;:<=9!4#56$#%1>! (&$!?:87@:8A>)B!!-./%"$0.%&789:;<&"#=#"#.!#/&>?9@8A@B)789,C& ! ".(*+%#$"6#4!CDE<98>2B!!-./%"$0.%&D@?9>E?F:;<&&

& & & & & & "#=#"#.!#/&D@?9>E?FB)>G7,C&

!!7FCG;8:HC;!4#56$#%1*+,!I8HE:8J!K9J>(&$-".(*+%#$"6#4B! BL!

+8)-8?8.!' 4#!' 8-4#%"..8=-' B-' ."!-#$' !' .<!>4' ?$%,-!4C' A"' <' .!:7$'

!"#

' 4*'

%*<!.8$-!'.$-'<!'.$<":-!'

!"#

'9*'<!'#!;<!'

$%#&"'&(

2 ))

+8' <'.!:7$'!<'A"' 4' /!.'%?%-.8!'4'<!'.<!>'7%8-.87!<6'4'7"9'$;>8!%'*<'

-$:;%'9<'.!:7$&'

789:;9!;:<=9!4#56$#%1>!

(&$!?:87@:8A>)B!

!-./%"$0.%&789:;<&"#=#"#.!#/&>?9@8A@BC&

!

".(*+%#$"6#4!CDE<98>2B!

!-./%"$0.%&D@?9>E?F:;<&&

&

"#=#"#.!#/&D@?9>E?FBC&

!!7FCG;8:HC;!4#56$#%1+,!I8HE:8J!K9J>(&$-".(+%#$"6#4B!

BL!

E-' 4#' .!4$' 4' -#8-9' A"' <$4' .!:7$4' /!.-' %?%-.8!' !' <!4' .<!>4'

7%8-.87!<4'9'<!4'#!;<!4'%?%*-.8!9!4'B48'<!'%<!.8=-'<!'?$%:!':,4'"-'.!:7$6'<'

$%9-'9'<$4'.!:7$4'9;'9'4%'*<':84:$C2'

E4#$' ?$%:!' "-!' %<!.8=-' -#%' 98./!4' #!;<!46' A"' !9*:,4' $;<8)!' !<'

.":7<8:8-#$' 9' <!'

**-./3&-)+)! &1&.$-+45**

' E4#!' 8-#)%89!9' $;<8)!' !' A"'

rut rut),

(rut,

rut

(22)

Restricciones

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' '

!"#$

789&':;9<&'%+'=9+&9'=&>+?':;9@#+&?'!A8$'B&9&'=*&>+?':;9<&%&?'B;9'<@?'%+'-#'

=&<B;)'+?C'

!"#$%#&%$'(#&)*+,-)./+0,1&

& -+23&!4$"51678&

& 93:);3&<=>'#"1?78&

& .@0;90/).&<=>'#"1A7&

& /0.-+:0:&<=>'#"1B78&

**!"#$%&'(#%)+,-.-/-01)2"&3(4#)5367.,89:/9;<9=))**

)

**&323&3#!3$)8,*>?@:)**

**!"#$%&'(#%)+,-A?<-01)2"&3(4#)5367A-?</?BA=))**

)

**&323&3#!3$)?</?BA@:)**

& !C<D%"$E<%&)*+@2F&G"E>$"H&I#H1-+23893:);38.@0;90/).7&

7J&

/$'&'%+:$#$=$D#'%+'=&>+'?+=-#%&9$&'?+'B;#+'&':$#&' E&=+':&8&'=;;=&9'+*'8+F8;'

G7HI2JK' LIM' B&9&' $#%$=&9' +#' N-O' =&<B;?' ?+' =;;=&' &' 9+?89$==$D#' %+' =*&>+'

:;9@#+&3' I#' +' +.+<B;' &#8+9$;9' +?' &P?;-8&<+#8+' #+=+?&9$;' N-+' &' =*&>+'

B9$#=$B&' %+' &' 8&P&' B$+Q&?' &' &' N-+' E&=+' 9+:+9+#=$&' &' =&>+' &' :;9<+#' &?'

=;*-<#&?'

!"#$

'5'

%$&'($

'5'+#'N-+'+?8O#'+#'+?+';9%+#3'

1&' $#8+,9$%&%' 9+:+9+#=$&' +?' -#&' E+99&<$+#8&' $<B9+?=$#%$P+' %+' *&?' P&?+?' %+'

%&8;?'9+&=$;#&+?3'R+9;'B9;>;=&'>&9$;?'B9;P+<&?3'R;9'+.+<B;S'?$'P;99&<;?'-#'

9+,$?89;' +#' &' 8&P&' B9$#=$B&' N-+' +?8@' 9+&=$;#&%;' =;#' -#;' ;' >&9$;?' %+' *&'

?+=-#%&9$&';=-99$9@'-#'+99;9S'5&'N-+'%+'B+9<$8T9?+#;?'P;99&9'+*'9+,$?89;';=-99$9@'

:&**;' %+' $#8+,9$%&%' !E&P9@' =&>+?' ?+=-#%&9$;?' 9+:$9$O#%;?+' &' -#&' =&>+' B9$#=$B&*'

N-+'5&'#;'+F$?8+)3''

R;9'+**;'?+'#;?'B-+%+#';:9+=+9'?;-=$;#+?'&'&U&%$9'89&?'&'=@-?-&'

-./.-.01.2

3'

/;#C'

i

30' 4.5.6.' 2.6' 07558

' V;;=&' #-;?' 8;%&?' &?' =&>+?' ?+=-#%&9$&?'

9+&=$;#&%&?'=;#'&'P;99&%&3'

i

30'4.5.6.'192194.8

'W;99&'8;%;?';?'9+,$?89;?'=-5&'=&>+'?+=-#%&9$&'+?'

$,-&'N-+'&'=&>+'%+'9+,$?89;'P;99&%;3'

i

30'4.5.6.'2.6'4./97568

'V;;=&'+#'+'9+,$?89;'9+&=$;#&%;'+'>&*;9'B;9'

%+:+=8;'+#'&'=;-<#&'9+*&=$;#&%&'

i

30'4.5.6.'036:;0<8

'K;'E&=+'#&%&3'

I#' +' =&?;' +FB$=&%;' ?+' &B$=&9T&#' &?' =@-?-&?' =-&#%;' ?+' +$<$#+#' :$&?' %+' *&'

=&>+'B9$#=$B&'9+&=$;#&%&'=;#'&'=&>+'?+=-#%&9$&3'I#'+?&?'=-&89;'=@-?-*&?'?+'

B;%9T&' ?-?8$8-$9' &' B&&P9&' 4I1IXI' B;9' &' B&&P9&'

7=496.

S' E&=$+#%;' N-+' +*'

:-#=$;#&<$+#8;'?+'9+:$+9&'&'=-&#%;'?+'<;%$:$=&'-#'9+,$?89;'%+'&'8&P&'B9$#=$B&*Y'

+#' <-=E&?' P&?+?' %+' %&8;?' ?+' &%<$8+' +*' -?;' 8' %+' 7K' 4I1IXI' =;<;' %+' 7K'

"R4ZXI3''

'

(23)

Foreign Key

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#' 5-'6!'7!4*'8*'8!#$4'9%!.6*'4:6$'4*';*%<=#*'"#=6=0!%'34!567686!968!4:77'"'34! 567686!;<9;<562'>$'4*'!8<=#*'*6'"4$'8*'34!:=5<86'*-'-=-)?-'.!4$2' @!'4=-#!A=4'.$<;6*#!';!%!'!B!8=%'.6!C*4'D$%,-*!4'*4&' !"#$%#&%$'(#&!"#$")$%&!"'()'*"+,-&.

. . !*+,%"$-+%&/-+#0)1)&!0%**%-/..*"#-/+&0#1&)$%&!"2"+,-&2. . . . "#.#"#+!#,&!"#$")*$"3)40%/*%,"$1)$"*%-/"("2&

& & & 3*+&4#(#%#&E&*+&564$%#&&

& & & & 3,#%&+5((&7&!$,!$4#&7&4#.$5(%8.

29& +='*4'8*'"-'4$6$'.!<;$'*A=4#*'*4#!'!6#*%-!#=C!&' !"#$%#&%$'(#&!"#$")$%&!"'()'*"+,-&.!%,-&.,0-,%)("()&5. . . /-+#0)2"+,-2$"3)6)*7/("0%".! ! ! ! !*+,%"$-+%&/-+#0)1)&!0%**%-/.. . . . . "#.#"#+!#,&!"#$")*$"3)40%/*%,"$1)$"*%-/"("2& & & & 3*+&4#(#%#&E&*+&564$%#&&

& & & & 3,#%&+5((&7&!$,!$4#&7&4#.$5(%8.

29& 53*<;6$&' !"#$%#&%$'(#&"$87%$)0)(/%.:$"!;$")925.. . . *-(',)$%*7$".+5<'#"):25.. . . !*+,%"$-+%&"$87%$)0',;.6"-<$"1&0#1)(/%5*-(',)$%*7$"25. . . !*+,%"$-+%.(/%'<;.=>[email protected]?D.E(/%2&

& & & "#.#"#+!#,.*$%)/!)&)(/%2..

. . . . *+&4#(#%#&,#%&+5((5..

. . !*+,%"$-+%.,)$%*7$"'<;..*"#-/+&0#1&)*-(',)$%*7$"2& & & & "#.#"#+!#,.,)$%*7$"&)*-(2..

. . . . *+&4#(#%#&!$,!$4#& 29& !"#$!%&&%'("#)*")+,-%*,&%.() +$-'%*4#%=..=$-*4'F"*'8=.#!-'"-!'.$-8=.=:-'F"*'8*7*-'."<;6=%'6$4'.$-#*-=8$4'8*' "-!' .$6"<-!2' G-!' <=4<!' .$6"<-!' ;"*8*' #*-*%' <?6#=;6*4' ;>6;?9' *-' 4"' 8*D=-=.=:-'H4*';$-8%I!-'C!%=$4';3498@<A48'4*)"=8$4J'4=-'.$<!4K2'' 53*<;6$&'

!"#$%#&%$'(#&%/F0)&-&)*-(.+5<'#"):2&6"-<$"1&0#15. . *-/*),!-.:$"!;$"=)GH2&+*%&+5((5. . %+,-0!).+5<'#")II5J2&!*+,%"$-+%&%+,-0!)'+%/. . . . !;#!0&)%+,-0!)KH2. . . !*+,%"$-+%&%+,-0!)'+"L. . . . !;#!0&)%+,-0!)MNHHH2&&&&&&&29& ! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#' 5-'6!'7!4*'8*'8!#$4'9%!.6*'4:6$'4*';*%<=#*'"#=6=0!%'34!567686!968!4:77'"'34! 567686!;<9;<562'>$'4*'!8<=#*'*6'"4$'8*'34!:=5<86'*-'-=-)?-'.!4$2' @!'4=-#!A=4'.$<;6*#!';!%!'!B!8=%'.6!C*4'D$%,-*!4'*4&' !"#$%#&%$'(#&!"#$")$%&!"'()'*"+,-&.

. . !*+,%"$-+%&/-+#0)1)&!0%**%-/..*"#-/+&0#1&)$%&!"2"+,-&2. . . . "#.#"#+!#,&!"#$")*$"3)40%/*%,"$1)$"*%-/"("2&

& & & 3*+&4#(#%#&E&*+&564$%#&&

& & & & 3,#%&+5((&7&!$,!$4#&7&4#.$5(%8.

29& +='*4'8*'"-'4$6$'.!<;$'*A=4#*'*4#!'!6#*%-!#=C!&' !"#$%#&%$'(#&!"#$")$%&!"'()'*"+,-&.!%,-&.,0-,%)("()&5. . . /-+#0)2"+,-2$"3)6)*7/("0%".! ! ! ! !*+,%"$-+%&/-+#0)1)&!0%**%-/.. . . . . "#.#"#+!#,&!"#$")*$"3)40%/*%,"$1)$"*%-/"("2& & & & 3*+&4#(#%#&E&*+&564$%#&&

& & & & 3,#%&+5((&7&!$,!$4#&7&4#.$5(%8.

29& 53*<;6$&' !"#$%#&%$'(#&"$87%$)0)(/%.:$"!;$")925.. . . *-(',)$%*7$".+5<'#"):25.. . . !*+,%"$-+%&"$87%$)0',;.6"-<$"1&0#1)(/%5*-(',)$%*7$"25. . . !*+,%"$-+%.(/%'<;.=>[email protected]?D.E(/%2&

& & & "#.#"#+!#,.*$%)/!)&)(/%2..

. . . . *+&4#(#%#&,#%&+5((5..

. . !*+,%"$-+%.,)$%*7$"'<;..*"#-/+&0#1&)*-(',)$%*7$"2&

& & & "#.#"#+!#,.,)$%*7$"&)*-(2..

. . . . *+&4#(#%#&!$,!$4#& 29& !"#$!%&&%'("#)*")+,-%*,&%.() +$-'%*4#%=..=$-*4'F"*'8=.#!-'"-!'.$-8=.=:-'F"*'8*7*-'."<;6=%'6$4'.$-#*-=8$4'8*' "-!' .$6"<-!2' G-!' <=4<!' .$6"<-!' ;"*8*' #*-*%' <?6#=;6*4' ;>6;?9' *-' 4"' 8*D=-=.=:-'H4*';$-8%I!-'C!%=$4';3498@<A48'4*)"=8$4J'4=-'.$<!4K2'' 53*<;6$&'

!"#$%#&%$'(#&%/F0)&-&)*-(.+5<'#"):2&6"-<$"1&0#15.

(24)

Validación

! "#!$%&'(!)*!+),-.-'/&+$-0.!)*!'-'/*,+'!-.1(&,2/-$('! !"#$%&'($%)*'+,-./*0'²'11123$%)*4!-./*02-*#'

!"#$

5-'6!'7!4'8'8!#$4'9%!.6'4:6$'4';%<=#'"#=6=0!%'

34!567686!968!4:77

'"'

34!

567686!;<9;<56

2'>$'4'!8<=#'6'"4$'8'

34!:=5<86

'*-'-=-)?-'.!4$2'

@!'4=-#!A=4'.$<;6#!';!%!'!B!8=%'.6!C4'D$%,-!4'4&'

!"#$%#&%$'(#&

!"#$"

)

$%&!"'()'*"+,-&

.

. . !*+,%"$-+%&

/-+#0)1)&!0%**%-/

..*"#-/+&0#1&)

$%&!"2"+,-&

2. . . . "#.#"#+!#,&

!"#$"

)

$"3)40%/%,"$1)$"*%-/"("

2&

& & & 3*+&4#(#%#&

E

&*+&564$%#&&

& & & & 3,#%&+5((&7&!$,!$4#&7&4#.$5(%8.

29&

+='4'8'"-'4$6$'.!<;$'A=4#'4#!'!6#%-!#=C!&'

!"#$%#&%$'(#&

!"#$"

)

$%&!"'()'*"+,-&.!%,-&.,0-,%)("()&5

.

. .

/-+#0)2"+,-2$"3)6)*7/("0%".

! ! ! ! !*+,%"$-+%&

/-+#0)1)&!0%**%-/

.. . . . . "#.#"#+!#,&

!"#$"

)

$"3)40%/%,"$1)$"*%-/"("

2& & & & 3*+&4#(#%#&

E

&*+&564$%#&&

& & & & 3,#%&+5((&7&!$,!$4#&7&4#.$5(%8.

29&

53*<;6$&'

!"#$%#&%$'(#&

"$87%$)0

)

(/%.

:$"!;$")

9

2

5.. . . *-(',)$%*7$".

+5<'#")

:

2

5.. . . !*+,%"$-+%&"$87%$)0',;.6"-<$"1&0#1)(/%5*-(',)$%*7$"25. . .

**!*+,%"$-+%**

.(/%'<;.=>[email protected]?D.E(/%

2&

& &

&

"#.#"#+!#,

.*$%)/!)&

)

(/%

2

..

. . . .

*+&4#(#%#&,#%&+5((

5..

. .

**!*+,%"$-+%**

.,)$%*7$"'<;.

**.*"#-/+&0#1&)**

*-(',)$%*7$"

2&

& &

&

"#.#"#+!#,

.,)$%*7$"&

)

*-(

2

..

. . . .

*+&4#(#%#&!$,!$4#&

29&

**!"#$!%&&%'("#)")+,-%,&%.()**

+$-'%4#%=..=$-4'F"'8=.#!-'"-!'.$-8=.=:-'F"'87-'."<;6=%'6$4'.$-#-=8$4'8'

"-!' .$6"<-!2' G-!' <=4<!' .$6"<-!' ;"8' #-%' <?6#=;6*4'

;>6;?9

' *-' 4"'

8D=-=.=:-'H4';$-8%I!-'C!%=$4'

;3498@<A48

'4*)"=8$4J'4=-'.$<!4K2''

53*<;6$&'

!"#$%#&%$'(#&

%/F0)&-&

)

*-(.

+5<'#")

:

2&6"-<$"1&0#1

5. . -/),!-.

:$"!;$"=)

GH

**2&+*%&+5((**

5. . %+,-0!).

+5<'#")

II5J

**2&!*+,%"$-+%&**

%+,-0!)'+%/.

. .

.

!;#!0&)

%+,-0!)KH

2 .

. .

**!*+,%"$-+%&**

%+,-0!)'+"L.

. .

.

!;#!0&)

%+,-0!)MNHHH

2&&&&&&&29&

!"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' ' !"#$ 7#'+89+':&8;'*&'<=7<>'?@;ABC+'&D&%$@'%&9;8':-5;'$E?;@9+'#;'+89F'+#9@+'G'5'HGGG' I&@&'?;%+@'A&:+@'@+J+@+#:$&'&';9@&8':;*-E#&8'A&5'K-+':;#89@-$@'*&'@+89@$::$L#' %+'J;@E&'$#%+?+#%$+#9+'&'*&':;*-E#&'!+8'%+:$@'&*'J$#&*'%+'*&'9&C*&)M'

!"#$%#&%$'(#&!"#$%&'&)(')**+,'#")+-&."/,$"0&1#02* * ('"(%,-'*3$"!4$"5)./-&*6%&*+((0* ********!1,'$-%2134**+,'#")5506-0* * !1,'$-%*789:;<=5506-0** ********!6*7%"$/*%*!1,'$-%2134!1'** ***************!4#!1*)!1,'$-%>!1,'$-%2134-* -8& !"!#$%&%'()%$**$+,'(& 78'?;8$C*+'K-+@+@'&D&%$@'@+89@$::$;#+8'9@&8'A&C+@':@+&%;'*&'9&C*&3'7#'+8+':&8;'8+' -9$*$N&'*&'8$,-$+#9+'8$#9&O$8M' $(%#"&%$'(#&-3?@3!&

$99&:!6*7%"$/*%&"'1?$%;&-!,'A%<%&-$!((!B")('@C1"3&-8&

!"#$%&'!("))"*+' +8' +*' 9+O9;' -./-0P' 1234526' 0/6' ;' 782/39:' 0/63' 1&8' @+89@$::$;#+8' :8;' :<==' %+C+#' $#%$:&@8+' E+%$&#9+' 5=;/2' ;5>=/' 33' 48?376' :;*;:&#%;':8;':<=='+#'+*':&E?;'K-+'8+'E;%$J$:&3'

-+%%!%&%'()%$**$+,'(&

/$#9&O$8M'

$(%#"&%$'(#&-3?@3!!

& 9"6.&<."/,$"0&1#0&=&+*/>+#)(31,'&-&=&&

& & !6*7%"$/*%&"'1?$%<%&-$!((!B"!:!$7!$9#;?&

1&' ;?:$L#'1234526' 0/6' +*$E$#&' -#&' :*&Q+' ?@$#:$?&*' !9&EC$F#' K-$9&@R' +*' B#%$:+'

<:3@</'8;C@+'*&8':&E?;8'K-+'J;@E&C&#'*&':*&Q+3'<:3@</'+*$E$#&'B#%$:+8'S#$:;83' 1&';?:$L#'-8:A;253:;'+*$E$#&'*&'@+89@$::$L#'$#%$:&%&3'

1&' ;?:$L#' -5A-5?/' A&:+' K-+' 8+' +*$E$#+#' +#' :&8:&%&' *&8' @+89@$::$;#+8' %+' $#9+,@$%&%'K-+'%+?+#%+#'%+'*&'@+89@$::$L#'+*$E$#&%&3'' I;@'+.+E?*;'+#M' !"#$%#&%$'(#*(C$&')* * (')2(C$&'*!4$")D-&."/,$"0&1#00* * E%(F32!"!(!'*9$%#0* * E%(F32E!"*9$%#0* * -!-C@'*3$"!4$"5)G/-0* * (')2&!#C!%"-%(C$&'*!4$")D-0* * !6*7%"$/*%*E%(F32(H*!4#!1)E%(F32E!"IE%(F32!"!(!'-0*

* !6*7%"$/*%*(')2&-%2EH*@6"#/A*&1#0)(')2&!#C!%"-%(C$&'-*

* * "#@#"#*!#7*(C$&'*6*&9#(#%#&7#%&*+((-8* !"!#$%&!'($!#)*$!'+$',&!$!'+$'+&#)!' !"#$%&%'()'*+#,-&.+'/01'!2)3'441'5'461' ' !"#$ 7#'+89+':&8;'*&'<=7<>'?@;ABC+'&D&%$@'%&9;8':-5;'$E?;@9+'#;'+89F'+#9@+'G'5'HGGG' I&@&'?;%+@'A&:+@'@+J+@+#:$&'&';9@&8':;*-E#&8'A&5'K-+':;#89@-$@'*&'@+89@$::$L#' %+'J;@E&'$#%+?+#%$+#9+'&'*&':;*-E#&'!+8'%+:$@'&*'J$#&*'%+'*&'9&C*&)M'

!"#$%#&%$'(#&!"#$%&'&)(')**+,'#")+-&."/,$"0&1#02* * ('"(%,-'*3$"!4$"5)./-&*6%&*+((0* ********!1,'$-%2134**+,'#")5506-0* * !1,'$-%*789:;<=5506-0** ********!6*7%"$/*%*!1,'$-%2134!1'** ***************!4#!1*)!1,'$-%>!1,'$-%2134-* -8& !"!#$%&%'()%$**$+,'(& 78'?;8$C*+'K-+@+@'&D&%$@'@+89@$::$;#+8'9@&8'A&C+@':@+&%;'*&'9&C*&3'7#'+8+':&8;'8+' -9$*$N&'*&'8$,-$+#9+'8$#9&O$8M' $(%#"&%$'(#&-3?@3!&

$99&:!6*7%"$/*%&"'1?$%;&-!,'A%<%&-$!((!B")('@C1"3&-8&

!"#$%&'!("))"*+' +8' +*' 9+O9;' -./-0P' 1234526' 0/6' ;' 782/39:' 0/63' 1&8' @+89@$::$;#+8' :8;' :<==' %+C+#' $#%$:&@8+' E+%$&#9+' 5=;/2' ;5>=/' 33' 48?376' :;*;:&#%;':8;':<=='+#'+*':&E?;'K-+'8+'E;%$J$:&3'

-+%%!%&%'()%$**$+,'(&

/$#9&O$8M'

$(%#"&%$'(#&-3?@3!!

& 9"6.&<."/,$"0&1#0&=&+*/>+#)(31,'&-&=&&

& & !6*7%"$/*%&"'1?$%<%&-$!((!B"!:!$7!$9#;?&

1&' ;?:$L#'1234526' 0/6' +*$E$#&' -#&' :*&Q+' ?@$#:$?&*' !9&EC$F#' K-$9&@R' +*' B#%$:+' <:3@</'8;C@+'*&8':&E?;8'K-+'J;@E&C&#'*&':*&Q+3'<:3@</'+*$E$#&'B#%$:+8'S#$:;83' 1&';?:$L#'-8:A;253:;'+*$E$#&'*&'@+89@$::$L#'$#%$:&%&3'

1&' ;?:$L#' -5A-5?/' A&:+' K-+' 8+' +*$E$#+#' +#' :&8:&%&' *&8' @+89@$::$;#+8' %+' $#9+,@$%&%'K-+'%+?+#%+#'%+'*&'@+89@$::$L#'+*$E$#&%&3'' I;@'+.+E?*;'+#M' !"#$%#&%$'(#*(C$&')* * (')2(C$&'*!4$")D-&."/,$"0&1#00* * E%(F32!"!(!'*9$%#0* * E%(F32E!"*9$%#0* * -!-C@'*3$"!4$"5)G/-0* * (')2&!#C!%"-%(C$&'*!4$")D-0* * !6*7%"$/*%*E%(F32(H*!4#!1)E%(F32E!"IE%(F32!"!(!'-0*

* !6*7%"$/*%*(')2&-%2EH*@6"#/A*&1#0)(')2&!#C!%"-%(C$&'-* * * "#@#"#*!#7*(C$&'*6*&9#(#%#&7#%&*+((-8*