Bài tập SQLSERVER có đáp án
Bạn đang xem bản rút gọn của tài liệu. Xem và tải ngay bản đầy đủ của tài liệu tại đây (133.38 KB, 15 trang )
Bài tập thực hành cơ sở dữ liệu SQL SERVER
1. Nội dung
!"#
$#"%&'(
)
$*+,+-./0%*1*2%
$*+
,+-3 !3
$*+,4"
2. File cơ sở dữ liệu
5(#"67%89#:
:666;"";"<=>?@AB"5CDE;2
FG=
5(#%"%89+"HIJKLI
%+%:
sql server management studio.
3. Quan hệ giữa các bảng
Bài tập SQL SERVER
Bài tập SQL SERVER
4. Đề bài
;$*+
,8J
M;5".NOPL!Q!R("!+) !
*!&)STL,J(P
LU;
>;V).,J(PLR("W
89+) Tiền vệ.
B;5"!*!&)
S!
&"#
L
,
J
(
,
*
+;
@;V.
,
J
(
PL
IR)
X4
#
Y%%
YHDZ8;
A;5"
O
R!
Q
!*!&)
S
++)
L
(
P
L
&
[CVY
\X]UIR)^Y_`;
Bài tập SQL SERVER
?;V
)
.,
J
(
PL
&&,
"4
#
4
^E"
1`;
W;5"I
J
Na1$b1X!Xc1d$D!$eXC1X!
$eX5EYM!$eX5EY>!e$0f1T(g
&,+h>L
ij>==<;
k;5"
O,*
+!Q!*!&)
S!
+h+5EY&
+L(,
*+IR)^X`
<;E,*B4#&",+hB
j>==<
M=;5"O,*
+!Q!*!&)
S!+h+5EY&+4
#&
&
9
SYDZ8;
;5(3"(
M;$RRZlPLLm4#;
>;$RRZlPLZ-"NIR
)
XTLm4
#
;
B;5"
O4#!4#!4+g
&!&)S+RZlP
L
Z
-"NIR
)(XTZ8nL(4#
'8>
PL
Z-";
@;5"S!RZl
PL
&&,
9+) '&#""(4
#
&)
S
&I
J
K
A;5"4#!S5EY&
&o9+) "
,
L
J
#
+
hB!j>==<;
;5("(4"
M
;5"
,*+&p
+) "4#
Z
R&
"
#;
>;E
(,*+IR
Việt
Nam Z.(,*
#
,
q
4#
";
B
;E
(PL&&,"(4
#
n#9
+hBj>==<-
8?
"r
s8B;
@;5"
((g&,NXc1d$D!
$eXC1X!$eX5EYM!$eX5EY>!e$0f1TL
4#
N5EYT&
#
"
,
&
+hB
j>==<;
5. Đáp án
a. Truy vấn cơ bản
M;
5".NOPL!Q!R("!+)
!*!&)STL,J(P
LU;
SQL:
CeEe5$tubva51f$Vfw
>;V).,J(PLR("W
89+) Tiền vệ.
SQL:
CeEe5$tubva51f$VfxVebey$byGXz$'+z
CvGzWzw
B;5"!*!&)
S!
&"#
L
,
J
(
,
*
+;
SQL:CeEe5$
$eXVE!Xc1dCyXV!Dy15Vy!DyeX$Vv1y{"
Vf1XEfdeXyeX;
@;
V.
,
J
(
PL
IR)
X4
#
Y%%
YHDZ8
SQL:
CeEe5$a15$!Vv$eX!y$by!Xc1dCyXV!Dy15Vy!Cv
ubva51f$Vf!0fv5cy1!51fE15Yv
xVebe51f$Vf;a10cG0fv5cy1;a10c
1XD51f$Vf;a15EYG51fE15Yv;a15EY
1XD$eX0cGXzXz
1XD$eX5EYGXzY%%YHDZ8zw
A;
5"
O
R!
Q
!*!&)
S
++)
L
(
PL
&
[CVY
\X]U
IR)^Y_`
CeEe5$a15$!Vv$eX!Xc1dCyXV!Dy15Vy!Cv
ubva51f$Vf!51fE15Yv!0fv5cy1
xVebe51f$Vf;a15EYG51fE15Yv;a15EY
1XD51f$Vf;a10cG0fv5cy1;a10c
1XD51fE15Yv;$eX5EYGXzCVY\X]z
1XD0fv5cy1;$eX0cGzY2zw
?;
V
)
.,
J
(
PL
&&,
"4
#
4
^E"
1`
CeEe5$a15$!Vv$eX!Xc1dCyXV!51f$Vf;Dy15Vy!
Cv
ubva51f$Vf!51fE15Yv!C1XD
xVebe51f$Vf;a15EYG51fE15Yv;a15EY
1XD51fE15Yv;a1C1XGC1XD;a1C1X
1XD$eXC1XGXzE"1zw
W;5"I
J
Na1$b1X!Xc1d$D!$eXC1X!
$eX5EYM!$eX5EY>!e$0f1T(g
&,+h>
Lij>==<;
CeEe5$
a1$b1X!Xc1d$D!C1XD;$eXC1X!;$eX5EY!;$eX
5EY!e$0f1
ubva$b1XD1f!C1XD!51fE15Yv!
51fE15Yv
xVebe$b1XD1f;a1C1XGC1XD;a1C1X
1XD$b1XD1f;a15EYMG;a15EY
1XD$b1XD1f;a15EY>G;a15EY
1XDX1aGz>==<z
1XDvXcGz>zw
k;
5"
O,*
+!Q!*!
&)
S!
+h+5EY&
+L(
,*+IR)^X`;
CeEe5$VE;a1VE!VE;$eXVE!Xc1dCyXV!
Dy15Vy!1y$bv!$eX5EY
ubvaVE|5EY!0fv5cy1!Vf1XEfdeXyeX1C
VE!51fE15Yv
xVebe0fv5cy1;a10cGVE;a10c
1XDVE;a1VEGVE|5EY;a1VE
1XDVE|5EY;a15EYG51fE15Yv;a15EY
1XD0fv5cy1;$eX0cGXzXzw
<;E,*B4#&",+hB
j>==<;
CeEe5$$v}B$eX5EY
ubvaY1Xc~V!51fE15Yv
xVebeY1Xc~V;a15EYG51fE15Yv;a15EY
1XDvXcGzBz
vbDebYdDyea%w
M=;
5"O,*
+!Q!*!
&)S!+h+5EY&+4
#
&&
9
SYDZ8
CeEe5$
Vf1XEfdeXyeX;a1VE!$eXVE!Dy15Vy!Xc1dCyX
V!1y$bv!$eX5EY
ubvaVf1XEfdeXyeX!VE|5EY!51fE15Yv!
$yXV
xVebe
Vf1XEfdeXyeX;a1VEGVE|5EY;a1VE
1XDVE|5EY;a15EYG51fE15Yv;a15EY
1XD51fE15Yv;a1$yXVG$yXV;a1$yXV
1XD$eX$yXVGXzYHDZ8zw
b. Các phép toán trên nhóm
M;$RRZlPLLm4#
CeEe5$$eX5EY!5vfX$N$eX5EYT
ubva51f$Vf!51fE15Yv
xVebe51fE15Yv;a15EYG51f$Vf;a15EY
cbvf}Yd$eX5EYw
>;$RRZlPLZ-"NIR
)
XTLm4
#
;
CeEe5$$eX5EY!5vfX$NVv$eXT
ubva51f$Vf!51fE15Yv!0fv5cy1
xVebe51fE15Yv;a15EYG51f$Vf;a15EY
1XD51f$Vf;a10cG0fv5cy1;a10c
1XD$eX0c•GXzXz
cbvf}Yd$eX5EY
B;
5"
O4#!4#!4+g
&!&)S+RZlP
L
Z
-"N
IR)(XTZ8nL(4
#'8>
PL
Z-";
@;
5"S!RZl
PL
&
&,9+) '&#""(4
#
&)
S
&I
J
K;
CeEe5$$eX$yXV!5vfX$NVv$eXT
ubva$yXV!51f$Vf!51fE15Yv
xVebe51fE15Yv;a1$yXVG$yXV;a1$yXV
1XD51f$Vf;a15EYG51fE15Yv;a15EY
1XDy$byGXz$'&#"z
cbvf}Yd$eX$yXV
A;5"4#!S5EY&
&o9+) "
,
L
J
#
+
hB!j>==<;
CeEe5$$eX5EY!$eX$yXV
ubva51fE15Yv!$yXV!Y1Xc~V
xVebe51fE15Yv;a1$yXVG$yXV;a1$yXV
1XDY1Xc~V;a15EYG51fE15Yv;a15EY
1XDX1aGz>==<z
1XDvXcGzBz
1XDV1XcGzMz
;5("(4"
M;
5"
,*+&p
+) "4#
Z
R
&"
#
CeEe5$$eXVE
ubvaVf1XEfdeXyeX!VE|5EY
xVebeVf1XEfdeXyeX;a1VEG
VE|5EY;a1VE
1XDDyeX$Vv1yyCXfEE
>;
E
(,*+IR
Việt
Nam Z.(,*
#
,
q
4#
"
CeEe5$$eXVE
ubvaVf1XEfdeXyeX!0fv5cy1
xVebe
Vf1XEfdeXyeX;a10cG0fv5cy1;a10c
1XD$eX0cGXzXz
1XDa1VEXv$yXN
CeEe5$a1VE
ubvaVE|5EY
xVebeVf1XEfdeXyeX;a1VEG
VE|5EY;a1VET
B;
E
(PL&&,"(4
#
n#9
+hBj>==<-
8?
"r
s8B;
CeEe5$Vv$eX
ubva51fE15Yv!51f$Vf
xVebe51f$Vf;a15EYG51fE15Yv;a15EY
cbvf}Yd51fE15Yv;a15EY!Vv$eX
V1yXc51fE15Yv;a15EYyXN
CeEe5$a15EY
ubvaY1Xc~V
xVebe51fE15Yv;a15EYGY1Xc~V;a15EY
1XDvXcGzBzX1aGz>==<z
1XDV1Xc€?"V1Xc•BT
@;
5"
((g&,NXc1d$D!
$eXC1X!$eX5EYM!$eX5EY>!e$0f1TL
4#
N5EYT&
#
"
,
&
+h
Bj>==<;
54*/"(fXyvX1EE&>g
J(Z‚""R;X
(#(JL>gJ
(H/fXyvX1EEƒ8+H
"(fXyvX"ƒ
"#s(JR;„4*
*+,H(g4Z-L&
n#",&fXyvX+-4*
+,H(g4(L&n#"
,;
CeEe5$DyC$yX5$Xc1d$D!$eXC1X!1;$eX5EY
5X!Y;$eX5EYD"!e$0f1
ubva$b1XD1f!C1XD!51fE15Yv1!51fE15YvY
xVebe$b1XD1f;a1C1XGC1XD;a1C1X
1XD$b1XD1f;a15EYMG1;a15EY
1XD$b1XD1f;a15EY>GY;a15EY
1XD$b1XD1f;vXc•GzBz
1XDa15EYMyXN
CeEe5$a15EY
ubvaY1Xc~V
xVebeV1XcGzMzvXcGzBzT
fXyvX1EE
CeEe5$DyC$yX5$Xc1d$D!$eXC1X!1;$eX5EY
5X!Y;$eX5EYD"!e$0f1
ubva$b1XD1f!C1XD!51fE15Yv1!51fE15YvY
xVebe$b1XD1f;a1C1XGC1XD;a1C1X
1XD$b1XD1f;a15EYMG1;a15EY
1XD$b1XD1f;a15EY>GY;a15EY
1XD$b1XD1f;vXc•GzBz
1XDa15EY>yXN
CeEe5$a15EY
ubvaY1Xc~V
xVebeV1XcGzMzvXcGzBzT
