!"#$!%& "$(!)*+) (+%*,-#.*#& /!% %*,+)&% 0$%,&/ /! #*!.#*&" .&,$)&%!" 1 2&,!23,*#&" 4&"!" /! /&,+" * 5 /6768 .9: ;
"# $%&'()*+ ,-./+ '0, 12$345617$8 96743648 :+' ;'<+./0 /+'0=(->0' =-> *> +?+@&'- &0/0 =0:0 *>0A B# 20/0 '-, '(C+/0'+, D0# E D.# =->,(:+/+ '0 ,(<*(+>C+ /+'0=(F>G H0C+/(0'+, 6IH0C+/(0' H4"BL H4"BM 79BQL H5MLQ H4QMP
7-@./+
2/+=(-
5+@+>C- 9'0>=O(+//- 3-C-/ 4/+>0 R(>0 U0.'->+, /-?-, W(>=
8C-=J
MN LP QS BN QN
"BN QM ST "N LP
2/-K++:-/ 2+>C2'+% H+C/-, V-*E 20'0:X>
0# $,=/(.0 '0 ,+>C+>=(0 +> ;'<+./0 /+'0=(->0' )*+ @*+,C/+ '0 (>R-/@0=(F> :+ H0C+/(0'+, =*E-, &/+=(-, ,+ +>=*+>C/+> +>C/+ YQN E YMM E )*+ C+><0> @;, :+ MN *>(:0:+, +> +%(,C+>=(0A $,=/(.0 +' /+,*'C0:- :+ '0 -&+/0=(F>A .# 90,0:- +> +' /+,*'C0:- )*+ ,+ @*+,C/0Z +,=/(.0 '0 ,+>C+>=(0 +> ;'<+./0 /+'0=(->0' )*+ <+>+/0 :(=[- /+,*'C0:-A 6IH0C+/(0'
8C-=J
2/-K++:-/
H4"BL
"BN
2+>C-
H4QMP
LP
20'0:X>
Q# 5->,(:+/+ +' ,(<*(+>C+ +,)*+@0 :+ *>0 .0,+ :+ :0C-, )*+ =->,+/K0 '0 (>R-/@0=(F> 0=+/=0 :+ K(0?+, :+ >+<-=(-, E ,*, <0,C-, 0,-=(0:-,Z &-/ =0:0 +@&'+0:-G $@&'+0:-D6:$@&Z 7-@./+Z 6:I+&0/C0@+>C-Z 6:I+&0/C0@+>C-Z U(C*'-2*+,C-Z U(C*'-2*+,C-Z 80'0/(-# \(0?+D6:Z 5(*:0:20/C(:0Z 5(*:0:I+,C(>-Z O+=[020/C(:0Z O+=[03++,-Z 6:$@ ]0,C-,D6:\(0?+Z 5->=+&C-Z O+=[0Z 50>C(:0:# 3+0'(=+ =-@0>:-, :+ ;'<+./0 /+'0=(->0' )*+ &+/@(C0>G 0# H-,C/0/ '-, >-@./+, :+ '-, +@&'+0:-, E ,*, =0/<-,Z ,(+@&/+ E =*0>:-Z ,X +,C;> 0,(<>0:-, 0 *> :+&0/C0@+>C- E >- [0> >+<-=(0:- 0^> ,* ,*+':-A .# H-,C/0/ '-, =F:(<-, :+ '-, +@&'+0:-, )*+ &0/C(+/-> +> K(0?+, :+,:+ _->:/+, - 9+/'X> E )*+ ''+<0/-> 0 =(*:0:+, )*+ =-@(+>`0> =-> '0, '+C/0, ] - aA =# H-,C/0/ '-, =->=+&C-, E =0>C(:0:+, :+ <0,C-, )*+ -,=('0> +>C/+ YMNNN E Y"NNNN E )*+ =-//+,&->:+> 0' ,+<*>:- ,+@+,C/+ :+' &/+,+>C+ 0b-A _*+<-Z /+0'(=+ =-@0>:-, +> 8a_ )*+ /+,*+'K0> =0:0 '(C+/0' +,&+=(R(=0:- 0>C+/(-/@+>C+A L# _0, ,(<*(+>C+, C0.'0, R-/@0> &0/C+ :+ *>0 .0,+ :+ :0C-, +> *> 8]9I /+'0=(->0'A V-C+' 3--@ 9--J(>< ]*+,C
D[-C+'7-Z [-C+'70@+Z =(CE# D/--@7-Z [-C+'7-Z CE&+Z &/(=+# D[-C+'7-Z <*+,C7-Z :0C+O/-@Z :0C+U-Z /--@7-# D<*+,C7-Z <*+,C70@+Z <*+,C4::/+,,#
V-C+' =->C(+>+ :+C0''+, :+ '-, [-C+'+, E [-C+'7- +, '0 ='0K+ &/(@0/(0A
3--@ =->C(+>+ :+C0''+, :+ '0, [0.(C0=(->+, &0/0 =0:0 [-C+' E D/--@7-Z [-C+'7-# R-/@0> '0 ='0K+ &/(@0/(0A 9--J(>< =->C(+>+ &0/0 +' /+<(,C/- E D[-C+'7-Z <*+,C7-Z :0C+O/-@# R-/@0> '0 ='0K+ &/(@0/(0A ]*+,C =->C(+>+ :+C0''+, :+ '-, [*c,&+:+, E <*+,C7- +, '0 ='0K+ &/(@0/(0A $,&+=(R()*+Z +> +' (:(-@0 +,&0b-'Z =*;' +, '0 0==(F> )*+ ,+ :+,+0 /+0'(`0/ =-> =0:0 (>,C/*==(F> :+ 0'<+./0 /+'0=(->0'G
(Room) ) D.# "type=‘S’ price < 20(Room) D=# !guestName, guestAddress (Guest) D0# !hotelNo ("price
50
>
#
$,&+=(R()*+Z +> +' (:(-@0 +,&0b-'Z =*;' +, '0 0==(F> )*+ ,+ :+,+0 /+0'(`0/ =-> =0:0 (>,C/*==(F> :+ 8a_G D:# SELECT * FROM Hotel WHERE city = ‘London’ D+# SELECT * FROM Booking WHERE dateTo IS NULL DR# SELECT * FROM Room WHERE price < 40 AND (type = ‘D’ OR type = ‘S’) 4[-/0 ,+ '+ [0 ,-'(=(C0:- )*+ (>K+,C(<*+ =(+/C-, 0,&+=C-, D&0/0 '- =*0' C(+>+ )*+ +'0.-/0/ '0, /+,&+=C(K0, =->,*'C0, 8a_#G <# U-:-, '-, [-C+'+, =-> ,*, [0.(C0=(->+, @0C/(@->(0'+,Z :-.'+, E C/(&'+,Z =*E- &/+=(R'*=C^+ +>C/+ YSN E Y"BNZ -/:+>0:0, &-/ &/+=(- D:+,:+ '0 @;, =0/0 [0,C0 '0 @;, +=->F@(=0#A [# _-, >-@./+, E :(/+==(->+, :+ '-, [*c,&+:+, =*E- >-@./+ C+/@(>0 +> *>0 K-=0' =+//0:0 D:c.('# E =*E0 :(/+==(F> -/(<(>0' +, *>0 =(*:0:+'0 - */.0>(`0=(F> D=->,(:+/+ '0, 0./+K(0C*/0, !"#$% ' ()*%#A M# $> *> ,(,C+@0 =->C0.'+ ,+ C(+>+> '0, ,(<*(+>C+, /+'0=(->+,G +',*)-.-!/-01$2D=-:(<-Z >*@+/-Z >-@./+Z =*+>C020:/+# 3$#"'2.-!/-01$2D=-:(<-Z ,0':-Z R+=[0# 4)$02$556'0-2D=-:(<-Z >*@+/-Z =*+>C06IZ R+=[0Z K0'-/Z C(&-Z <'-,0# _0 /+'0=(F> +',*)-.-!/-01$2 (>:(=0 +' =F:(<-Z +' >^@+/- =-//+,&->:(+>C+ +> +' =0C;'-<:+ =*+>C0,Z +' >-@./+ :+,=/(&C(K- :+ '0 @(,@0 E =*;' +, +' =F:(<- :+ '0 =*+>C0 &0:/+A _0 /+'0=(F> 3$#"'2.-!/-01$2 (>:(=0 +' =F:(<- :+ '0 =*+>C0 =->C0.'+ E ,* ,0':- +> '0 R+=[0 =-//+,&->:(+>C+A _0 /+'0=(F> 4)$02$556'0-2 (>:(=0 '-, 0,(+>C-, =->C0.'+, =-> ,* /+,&+=C(K=F:(<-Z >*@+/0=(F>Z =F:(<- :+ =*+>C0 =->C0.'+ 0R+=C0:0Z R+=[0 :+ '0 C/0>,0==(F>Z K0'-/Z ,( +, :+.+ - [0.+/ E <'-,0A 5->,(:+/+ '-, ,(<*(+>C+, +?+@&'-, :+ C*&'0,G +',*)-.-!/-01$2D"Z ""N"N"N"NN"Z d50?0 E 90>=-,eZ B# 3$#"'2.-!/-01$2D"Z BNNNZ dNTf?*'fBN"Be# 4)$02$556'0-2D"Z d4NNN"eZ "Z dN"f?*>fBN"BeZ QNNZ dIeZ d\+>C0 0 8*&+/@0%(e# 4)$02$556'0-2D"Z d4NNNBeZ SZ dN"f?*>fBN"BeZ QNNZ dVeZ d\+>C0 0 8*&+/@0%(e# 8+ '+ ,-'(=(C0 )*+G 0# $,&+=(R()*+ '0, (>,C/*==(->+, :+ 8a_ &0/0G (# H-,C/0/ '-, >-@./+, :+ '0, =*+>C0, =->C0.'+, )*+ >- C(+>+> =*+>C0 &0:/+A ((# I+C+/@(>0/ +' =F:(<- :+ '0, =*+>C0, =->C0.'+, 0R+=C0:0, &-/ *> K0'-/ )*+ +%=+:0 Y"NNN E R*+/-> /+0'(`0:0, +' ^'C(@- :X0 :+ +,C+ @+,A .# H*+,C/+ +' >-@./+ :+ '0 =*+>C0 =->C0.'+ )*+ ,+ [0 K(,C- 0R+=C0:0 =-> +' K0'-/ @;%(@-A
P# 5->,(:+/+ +' ,(<*(+>C+ @-:+'- /+'0=(->0' :+ .0,+ :+ :0C-,Z )*+ :+,=/(.+ '-, :(R+/+>C+, C(&-, :+ @-K(@(+>C-, :+ '0, =*+>C0, )*+ C(+>+> '-, ='(+>C+, +> *> .0>=- )*+ C(+>+ K0/(0, ,*=*/,0'+,G CUENTAS CLIENTES id Cedula Nombre Apel li do Fech_Nac Telefono Direccion
in t nchar(10) char(25) char(25) smalldatetime char(20) char(30)
id numero
Cliente_id FK_CUENTAS_REFERENCE_CLIENTES Saldo Tipo_Cuenta
in t in t in t float char(1)
FK_MOVIMIEN_REFERENCE_CUENTAS
SUCURSALES
id Descripcion MOVIMIENTOS FK_MOVIMIEN_REFERENCE_SUCURSAL Ciudad Telefono Move_id int Direccion id int Cod int Cuenta_id int Tipo_Movimiento FK_MOVIMIEN_REFERENCE_TIPO_MOV TipoMove_id int Cod int Valor float Descripcion char(20) Sucursal int fecha smalldatetime
in t char(20) char(30) char(15) char(30)
8+ '+ ,-'(=(C0 )*+G 0# H*+,C/+ '-, >-@./+, :+ C-:0, '0, ,*=*/,0'+, -/:+>0:0, 0'R0.cC(=0@+>C+ &-/ =(*:0: E :+,=/(&=(F>A .# H*+,C/+ '-, >-@./+, E 0&+''(:-, :+ '-, ='(+>C+, )*+ >0=(+/-> +> +' 0b- "ggLA =# H*+,C/+ C-:0 '0 (>R-/@0=(F> :+ '-, ='(+>C+, =*E- >-@./+ +@&(+`0 =-> K-=0' &+/- ,* 0&+''(:- +@&(+`0 =-> =->,->0>C+A :# H*+,C/+ =*;'+, =*+>C0, =-//(+>C+, +,C;> ,-./+<(/0:0, D=-> ,0':- >+<0C(K-# E )*+ =-//+,&->:0> 0 ='(+>C+, :+ '-, =*0'+, >- ,+ =->-=+ ,* :(/+==(F> - ,* C+'cR->-A +# H*+,C/+ '0 =0>C(:0: :+ ='(+>C+, )*+ C(+>+> C+'cR->- =+'*'0/A _-, C/+, =0/0=C+/+, (>(=(0'+, /+&/+,+>C0> +' =F:(<- :+ ;/+0 hMgQi R# H*+,C/+ =*;>C-, @-K(@(+>C-, [0> ,(:- /+0'(`0:-, +> '0, C/+, &/(>=(&0'+, =(*:0:+, :+' &0X,G ]*0E0)*('Z a*(C- - 5*+>=0A <# H*+,C/+ =*;>C- :(>+/- +,C; :+&-,(C0:- +> +' .0>=-Z 0' =->,(:+/0/ C-:0, ,*, =*+>C0,A [# H*+,C/+ +' K0'-/ &/-@+:(- :+ '-, @-K(@(+>C-, :+ '0 =*+>C0 "NBBQNMNgPA (# H*+,C/+ &-/ =0:0 ='(+>C+ '-, >^@+/-, E C(&-, :+ =*+>C0 )*+ &-,++A ?# H*+,C/+ =*;>C- :(>+/- &-,++ =0:0 ='(+>C+ 0' =->,(:+/0/ C-:0, ,*, =*+>C0,A J# H*+,C/+ &-/ =0:0 ,*=*/,0' E C(&- :+ @-K(@(+>C-Z '0 =0>C(:0: :+ :(>+/- )*+ ,+ [0 &/-=+,0:-A