Đăng ký Đăng nhập
Trang chủ Công nghệ thông tin Cơ sở dữ liệu Đáp án một số bài tập mẫu môn cơ sở dữ liệu (phần 2)...

Tài liệu Đáp án một số bài tập mẫu môn cơ sở dữ liệu (phần 2)

.PDF
4
2036
126

Mô tả:

Đ N ÁN !"#$%!&$'()*$#("+$ (,-$ !./$0%12$ $ $ '345$67$$ !"#$%&'(#)"*# +,-#./01# 8(/98!($: 388;$#<=88;$1>=953?$ /8(/@*A/$: 3/@;$#<=/@?$ 8!(1!/$: 381;$/B3C81;$ 3/@?$ 0#81$: 381;$ 30#;$ 388;$%>2D>=B?$ $ 6767$@5$L5# 7!?"# ;/@7# !/A39B# CD?47# 8/E39# F"/3!# ."4# 5/63# G# +"-0"39#H#,"3ID/B#J?47#K0/L#!D?M3#7!N#9"*;#O/P#QQR#S?T3#QQ#U/A#7"M39#F"/3!#."4#5/63B# # %A2A0#$KK7N3KK;$F<=KK;$ODN:O>PD>=BQR>=B53?$$(%$ROL3=$ ST! $K3=BK>3$KK;$K>3R>=$KR;$GFKR$$GF$ $$$$U8ATA$KK7N3KKVGF7N3KK$$ $$$$$$$$$(/1$KR7N3KRVGF7N3KR$$ $$$$$$$$$$$$$$(/1$WA(T:=B3CKR?VXYYZ$ $$$$$$$$$$$$$$$$$$$9T!-+$'W$KK7N3KK;$F<=KK$ $$$$$$$$$$$$$$$$$$$$$$$$$!T1AT$'W$%- :O>PD>=BQR>=B53?$ # 52#V!/T3#UD?T3#U/A# ."4# $%&'39#!"6/#)&3#5/63#78"39#7!/639#=>#3/:;#<==>#F"#!"'# W!0'# 78/6(!B# S!"T39# 7D3#9"*;1#O/P# VXR#S?T3#VXR#+"4# $%&'39# !"6/# )&3#W!0'# 78/6(!R# ./YW# Z?4W# 7!?"# ."4# $%&'39#9D/L;#F/*3B# # %A2A0#$=[7N3=[;F<==[;$G>D=F:N3KR?$(%$O>\PD>=B\KR\L3=$ ST! $=K3=[5<=$=[;K>3R>=$KR$ $$$$$U8ATA$=[7N3=[VKR7N3=[$$ $$$$$$$$$$(/1$WA(T:=B3CKR?VXYYZ$(/1$ !/#8:=B3CKR?VYZ$ $$$$$$$$$$$$$$$$$9T!-+$'W$=[7N3=[;F<==[$ $$$$$$$$$$$$$$$$$$$$$$$$!T1AT$'W$0!-/#:N3KR?$1A%0$ # (2# Q/A39#!"6/#("6# )&3#9D/6# $&63#3!/47# $/A# !/A39#!"6/# 3/A"[# V?40# ("6# 3!D?*0#;/@7#!/A39# 3!%# 7!?4R#\?47#K0/L#./YW#Z?4W#7!?"#S?T3#QQB# # %A2A0#$887 (88;$#A/88$ST! $8(/98!($88$ $$$$$$U8ATA$1!/9*(V:%A2A0#$ (]:1!/9*(?$ST! $8(/98!(?$ $$$$$$$$$$$$!T1AT$'W$#A/88$ Dap an Bai tap mon CSDL trang 1 8>3GM$ %A2A0#$887 (88;$#A/88$ST! $8(/98!($88$ $$$$$$U8ATA$1!/9*($^V$(22$:%A2A0#1!/9*($ST! $8(/98!(?$ $$$$$$$$$$$$!T1AT$'W$#A/88$ # F2#,/3!#./6(!#3!/T3#UD?T3#(!%/#7%A39#W!0'#78/6(!#5/63#;"]7#!"6/#)&3#3/A"#(/LB# # %A2A0#$/@7 (/@;$#A//@$$ $$$ST! $/8(/@*A/$/@$ $$$$$$$U8ATA$ (/@$/!#$*/$:%A2A0#$1*%#*/0#$ (/@$ST! $8!(1!/?$ $ # ?2# S"M39# F"/3!# ."4# 5/63# 78"39# 7!/639# =>^<==># (0L/# ;/@7# !/A39# ("6# 7?T3# _D`QaVb# cIdB# CD?47#8/E39#F"/3!#."4#5/63#G#+"-0"39#H#,"3ID/B#S!"T39#7D3#9"*;1#S?3QQR#S"39,+B# # %A2A0#$ 388;$#<=88;$%- :%!2-!/9Q1!/9*(?$(%$1%'(/$ $$$$$ST! $0#81$0#;$8(/98!($88;$8!(1!/$81$ $$$$$$$$$$U8ATA$817 (81V0#7 (81$$ $$$$$$$$$$$$$$$$(/1$0#7 (88V887 (88$$ $$$$$$$$$$$$$$$$$$$(/1$#A/88V_5+8!/A$`9_$$ $$$$$$$$$$$$$$$$$$$$$$$$(/1$WA(T:/9(W81?VXYYZ$(/1$ !/#8:/9(W81?VYZ$ $$$$$$$$$$$$$$$$$$$$$$$$$$$$$9T!-+$'W$0#7 (88;$#<=88$ $ $ $ $ $ $ # e2#,"/3!#."4#5/63#78"39#(/6(#!"6/#)&3#F"#3!/T3#UD?T3#("6#7?T3#_f0g3!#Q0"39d#W!0'#78/6(!B# S!"T39#7D3#9"*;1#O/Q,R#V9/gQ,R#,"/3!#."4B#J?47#K0/L# ./YW#Z?4W#7!?"#F"/3!#."4# 9D/L;# F/*3B# # %A2A0#$817 (81;$/9(W81;$%- :%!2-!/9Q1!/9*(?$(%$1%'(/$ $$$$$$$ST! $8!(1!/$81;$0#81$0#;$/8(/@*A/$/@;$8(/98!($88$ $$$$$$$$$$$$$$$U8ATA$817 (81V0#7 (81$$ $$$$$$$$$$$$$$$$$$$(/1$0#7 (88V887 (88$ $$$$$$$$$$$$$$$$$$$$$$(/1$/@7 (/@V817 (/@$ $$$$$$$$$$$$$$$$$$$$$$$$$(/1$#A//@V_JDC=K$8D>=B_$ $$$$$$$$$$$$$$$$$$$$$$$$$$$9T!-+$'W$817 (81;$/9(W81$ $ $ $ $ # # $ 92#,/3!#./6(!#3!/T3#UD?T3#\!"T39#W!0'#78/6(!#!"6/#)&3#3/A"#78"39#7!/639#=>^<==>B# # %A2A0#$/@7 (/@;$#A//@$$ $$ST! $/8(/@*A/$/@$ $$$$$$$U8ATA$ (/@$/!#$*/$$ $$$$$$$$$$$$:%A2A0#$1*%#*/0#$ (/@$ST! $8!(1!/$$ $$$$$$$$$$$$$$$$$U8ATA$WA(T:/9(W81?VXYYZ$(/1$ !/#8:/9(W81?VYZ?$$ Dap an Bai tap mon CSDL trang 2 # !2#,/3!#./6(!#!/A39#!"6/#(!%/#7%A39#)%&'(#5/63B# # %A2A0#$887 (88;$#A/88$$ $$$$$$$$ST! $8(/98!($88$$ $$$$$$$$$$$$$U8ATA$ (88$/!#$*/$:%A2A0#$ (88$ST! $0#81?$ # 67X7$ @5E$ eD3=$ K h (HOADON h> h TENHH=’sua’ (HANGHOA h> h CTHD))) ## 67`7$ @5E$ eD3=$ K h (CTHD h> h NGAYHD=’31/12/2007’ HOADON)) # '345$XM$g3HG$ch=K$iKDd$FKD>fG$K34N7$$ X767$ !"#$%&'(#)"*#K0/3#!?]#fklC ,bIQ2#U/A#7/]W#(/6(#W!0'#7!0"](#!/A;# m#G#n# lC#à# # # C#à#,# # ,#à#b# b#à#IQ# # I#à#l# o# `!0'#7!0"](#!/A;#CI#à#b#("6#)%&'(#.0g#8/#7%A#m#\!"T39[# !%639#;D3!B# $ Sp3!#5/"#)"639#kCI2q#G#CI,l bQ#É#bB#X/]g#CI#à#b#)%&'(#.0g#8/#7%A#m# $ $ X7X7$ !"#$%&'(#)"*#K0/3#!?]#fk#rsJ-OVa2#U/A#7/]W#(/6(#W!0'#7!0"](#!/A;# m#G#n# rs#à#J# # # # s#à#-## # # J-#à#O# # JO#à#Va# # # Và#r## o# `!0'#7!0"](#!/A;#sV#à#O#("6#)%&'(#.0g#8/#7%A#m#\!"T39[# !%639#;D3!B# # Sp3!#ksV2qGsV-rJOa#É#O#3?T3#sVàO#)%&'(#.0g#7%A#m# $ Dap an Bai tap mon CSDL trang 3 '345$`M$g3HG$ch=K$R3d=B$GKD3a=$GDj3$PbkdG$c>l$eD3=$K - Xem thêm -