Top 150 câu hỏi trắc nghiệm ôn tập môn cơ sở dữ liệu
Không nhất quán dữ liệu là gì?Phép chiếu trên một quan hệ là gì? Tài liệu giúp bạn tham khảo, ôn tập và đạt kết quả cao trong các kì thi sắp tới
100
50 lượt tải
Tải xuống
Môn: Cơ sở dữ liệu và giải thuật
Trường: Đại học Kinh Doanh và Công Nghệ Hà Nội
Thông tin:
20 trang
3 tháng trước
Tác giả:
lOMoARcPSD|45022245
!""#$ %
&'($)*
& +",-& "$(.$/0$'.
1$203$!4$(#$5$("#67$(
80 9#$+:
;
<&")$=5 2> $(?"@2/,
A*
& <&")$=5 2> $(*
8 B@ $(*
C2 $(*+:
; 2>&2(4
D$?E%$($?=%?=F$&0$?!42>?.$0$G$,.$0$
!$(!""2$( &$)H2$( >$(B@*
IJ!KL$
MN'"#$(7$(E$
N!$(=!O,!*
& NP7$($/ $=P7$(2$=Q$
R0$ $!$($SP /$*
C7$(-$TU$7$(E$?*+:&
VC7$($/ $(.W
7$(E$X$(!Y"$($$($P $."
P $
& 7$(E$P7$(Y$($!"=)$
P7$(! $!$(Z
7$(E$ !Y"$(P $>!""$"$
2$(/$
+:
lOMoARcPSD|45022245
[8)$2$=Q$!0&022S"
7$7$!$(
\8]S!$( ]2$(7.$P%$
<]$(2?]/$$?]2$(
^_("#6`$(K,$`=2/,5$,$
a<7.$$(2$$(7$(E$O$") $.$
$("#67$(
b<7.$2$(7.$"=9c,$
=c &Kd$eN")>$("=9<7.$2$(
&Kd$f"$(]$
<7E#&02!0)$!
;g$(&<Y/$( SK
I<7$(E$P-2 &0$(72$("#$(
h&0$(7,$
MRi%#$/$Z
/$?2$(!(> $#2$(i%?P7$(
2>& ( '(Y$($2$(Z
& /$?2$(!(> P7$($#2$(i
%Z
/$j$(=)1$%P
j$(Z
C7$(0 /$$#2$(& &KPZ+:
MRk$2$(/$g
k$ &Kl$- $mRik$Z
k$Y=& !Y$2!
;
lOMoARcPSD|45022245
/$Z
& 7$/$P /$j$(Z
k$Y&=& !Y&$2!/$
Z
C7$(X=)& &KPZ
+:
Vn$( !5P$2$(k&2 $?2(?>$(
[R%)$h#$/$!"K
\Co$(!'$$27
^pE#$!5:2$(2 7(4 /,A
R0$->?(F$(qF$("$(r?&AO
a n,A0$->2$(E#$
!5 :2$(;bn,A
F$("$(2$(E#$!5:2$(;n,A&AO
2$(E#$!5:2$(
;;_%:stu=:st.
;I_%:stu?ust?stN 7$( E#$!5:2$(.
;M_%:stu.:stu=:st$2!" 7$(
I
lOMoARcPSD|45022245
;[_%:st=vstN.:vstN$2!" 7$(
Ib8:Bwx:stu?usth?uhstvy? 7$( E#$!5:<e8gz_{
:stv?ustv
& :stv?hstv
ustv?hstv
ustv?vst:
I8:Bwx:stu?sth?ustvy? 7$( E#$!5:<e8gz_{
:stv?:sth
& :stv?stv
ustv?stv
ustv?vst:
I;8:Bwx:stu?sth?ustvy8)$|:}~w
II8:Bwx:stu?sth?ustv?:stNy?8)$|:}~
IM8:Bwx:stu?sth?ustv?:stNy?8)$|}~w
IV8:Bwx:stu?sth?ustv?vstNy?8)$|u}~
w
I[8:Bwx:stu?sth?ustv?:stNy?8)$|h}~w
I\8:Bwx:stu?sth?ustv?:stNy?8)$|:u}~
w
I^8:Bwx:stu?sth?ustv?:stNy?8)$|u}~
M
lOMoARcPSD|45022245
w
Mb8:Bwx:stu?sth?ustv?:stNy8.P2 M;8:Bwx:stu?
sth?ustv?Nst:y8.P2
MI8:Bwx:stu?sth?ustN?:stNy,P2
MM8:Bwx:stu?sth?ustv?ust:y8.P2
MV8:Bwx:stu?sth?ustv?stN8)$|}~
M[<Y$Y$#&2$(/$gq=??2?r=)=??2
PK@-=PK$&@k$$$2W
•_e€g8qg?=w•b•?w•$(,@$=$:$•?2w•;•?Mr&•_e€g8
qg?=wb?w•$(,@$=$:$•?2w;?Mr•_e€g8q=w•b•?w•$(,@$
=$:$•?2w•;•?Mr•_e€g8qg?=w•b•?w•$(,@$=$:$•?2w•;•r
M\C%/0•_e€g8q#&r"#$((‚,$22/$
P&)!"#=2W
Zu#=2P7$(X=)"!4/$2")qrZ
& <Y( 'Y1$$ƒ$(2%$( '
1$!q;rZ
{ 'P2 &)K( '!32$(/$$("
qIrZ !" #$$%
Ma8.&2!$(=)gq:?u??N?€?{r=Bwx:ut?:stN€?stu{?
Nst€{y
&'(
Vb2/$gq:uNr=7Bwx:stu?:tNyR‚$„$
gq:r?g;quNrp #$&022$7$(E$,P7$(W
)*+",,-*+.
V
lOMoARcPSD|45022245
V 2/$gq:uNr=7Bwx:stu?:tNyR‚$„
$gq:ur?g;q:Nrp #$&022$7$(E$,
P7$(W",,-*+.
V;_ )$x<p2N2$?
_(,p2N2$?<p$(?e22$(?N2${?8$8@$?82$(8@$y
$%>2$/$2$(eN=>$(&
P7$(W/
VI2"!4pz:Nz_q<:p:_{?<:Cp?ez…z_{?
Nz_{•:?8p:_p8•€_rp "!4#$>$(L$$2W
)*+012+*3-,
VM2/$gqevNr=) 7BwxNstv?=vstyh
!'$>$(L$gW)*+012+*3-,
VV+K-2 &0$(P7$(O$%P eN?2$(en67$(
$$2W
456789:;:(
V[2"!4/$gq8pge{r=)R7YK{wxs
t8?pgst?est{=pestgyp g>$(L$$2W2nf
V\2"!4/$g=7Bwx:ust€?:{st•?u€st•?€s
t{?{•stpyR7$2")!‚, gW
(
V^_ )$x<p2N2$?
_(,p2N2$?<p$(?e22$(?N2${?8$8@$?82$(8@$y$%>2
$/$2$(eN.&'=>$(&"fN2
!$#$ $,/$2$
<=:>5:
Va_ )$x<p2N2$?
[
lOMoARcPSD|45022245
_(,p2N2$?<p$(?e22$(?N2${?8$8@$?82$(8@$y$%>2
$/$2$(eN.&'=>$(&"f8
K $;/2$=))$"$(]$(
55:!?55::(@7655:5:(A8:%
AA855:!?55:?:(B57=5:(5:(A:
A8:%
[b2"!4/$gq:uN€{pr=7Bwxust:?:stuN€?
:ust{p?:uNst€y8.&2!$()$|:}
{ABDECGH}
[2"!4/$gq:uN€{pr=7
Bwxust:?:stuN€?:ust{p?:uNst€y8.PgW
2 khúa: A và B
[;2/$pz:Nz_qp2N2$•N?_(,p2N2$?
p$88$82$?e2$(2<p$(?82$(8@$?
_$†@$g@‡?Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N? 8@$e$R? N2$†8$?
_e$hr 2 &% Y /$ ( pz:Nz_ =
p•8•€8pz:Nz_7CDEFGCDH*I
[I2/$pz:Nz_qp2N2$•N?_(,p2N2$?
p$88$82$?e2$(2<p$(?82$(8@$?
_$†@$g@‡?Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?8$8@$?
e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?_e$hr2&%
Y/$(p•8•€8pz:Nz_=N<e:_Rp:<
7CDEFGCDH*IJ
[M8#L$!K"!4/$g>$(L$_B(.W
,-K$LCMNLOP,+4#M*Q*R$+SPT+UDVJW
\
lOMoARcPSD|45022245
[V<"!4/$>$(L$;_BP$2W
:XN012+*3:YZ-XL[C*K\*]*+]*,$^4
**K*-L#U#^Z-,]*,$*S*JW
[[<"!4/$>$(L$I_BP$2W
:N012+*3:YZ-L[C*K\*]*+]*,$^4G-]*+
**K*-LZ-,]*,$*S*JW
[\<"!4/$g>$(L$u_BP$2W
*,"PD4]*+*K*_G-LK]*,$^4J
[^8.P2 /$
p:_{‰pz:q<e<p?8€_‰p:_{?ez‰…z_{r=)
7
Bwx<eppst@$‰$(?2‰2$(ˆ@$‰$(ste2‰2$(y
)*`?B?
[a8.P2 /$gq?•?N?u?C?B??<?{r=) 7
Bwxst•N:CB?Nstu?Cst•?Cst?st<{yW
)*`
\b8.P2 gq:?u??Nr†)•‡wx:ust?:ustN?tuyW
)*`
\8.P2 gq:?u??N?<?_?R?nr†)
Bw|:<st_uˆu_st?:stR?RNst<?Rst:ˆNstn?Rst_}W )*` J
:<Z
& :<R
P7$(! $!$(Z
1J:NR
\;8.P2 gq_?<?R?n?g?8?…?Šr†)
Bw|<stŠˆ<gst8?8stg?ngst8?<st…ˆ<8stR?_Rstn}W
)*`?4: MNT
J?4:J
^
lOMoARcPSD|45022245
& <gn
<8R
<gR
\I8.P2 gq:?u??N?€?B?{?p?•?‹r=)Bwx:ust?uNt€B?:Nst{p?:st•?ps
t‹yW
)*`
\M2gq:?u??N?
€?B?{?p?•?‹r†)•‡wx:ust?:stN€?ustB?Bst{p?Nst•‹yC2 /$
#$
)*`
\V2gq:?u??N?€?B?{?p?•?‹r†)•‡wx:ust?:stN€?ustB?Bt{p?Nst•‹yu2
!$(hw:NW
&'8Aa
\\2gq:uŠ8r?Bwq:ustŠ?Šst8?8Šst:ur7$220gW
Šst:8:&
:stŠ:s
tŠ8
:8stŠu
\^2"!4/$= 7Bwx:ut€?:{st•?u€st•?
€st{?{•stpyR7$220gW:ust{p&{pst€uups
t:u
:stup
\a2"!4/$= 7Bwx:ut€?:{st•?u€st•?
€st{?{•stpy 7$220gk$! $!$(
$W:ust{p?:{st{p&:{st{p{pst:u
a
lOMoARcPSD|45022245
:ustup
^b2"!4/$= 7Bwx:ut?ustN?Ns
t€?€st{p?{st:yR7$220g2! $!$($W
:ust€?:ust{&:ust{{pst:
:ust€
^2"!4/$= 7Bwx:ut?ustN?Ns
t€?€st{p?{st:yR7$220g2! $!$($W
:ust{&{€st:uustNp
€stN
^;2"!4/$gq:?u??N?€?{?pr= 7
Bwx:ust?ustN?Nst€?€st{p?{st:yR7$220g2
! $!$($W:ust€&:st{€st:Nst:u
^I2gq:?:;?:I?:M?:V?:[?:\?:^r
Bwx::;st:I:M:V:[:\:^?:[st:\:^?:;st:M?:st:Iyg>$(L$
$2Wk$! $!$($3nf
^M2"!4/$
gq?•?N?u?C?B??<?{r= 7
Bwxst•N:CB?Nstu?Cst•y
g>$(L$$2Wk$! $!$($
4]*+012+*3-,
^V2"!4/$gqe:r=) 7Bwxest:?:sty
"!4#$>$(L$$2Wk$! $!$($
:Y
^[2"!4gqe:N<r= 7Bwxe:s
tN?eNst<yg>$(L$$2Wk$! $!$($
b
lOMoARcPSD|45022245
:Y
^\2"!4/$gqu:•Rr=) 7Bwxu:stR=•st:y
g>$(L$$2Wk$! $!$($
:Y
^^2gqe{r=) 7Bwxest{yg>$(L$$2W
k$! $!$($
J4012+*3 :YJW
& g>$(L$;_BZ
g>$(L$_BZ
gP7$(>$(L$$2Z
^a2gq8pger=) 7Bwxst8?pgst?8pstg?pes
tgyg>$(L$$2Wk$! $!$($:Y
ab 2gq:?u??Nr†) ‡wx:ust?:ustN?stuyg >$(L$$2W
k$! $!$($J4012+*3 :YJW
& g>$(L$;_BZ
g>$(L$_BZ
gP7$(>$(L$$2
a2"!4/$gq?P?#$$(?WW$(?2$( rˆ
†)P)$"!4/$?PP#$P%g
>$(L$$2Wk$! $!$($Ko ở chuẩn nào
a;2gq:?u??N?€?B?{?p?•?‹r
Bwx:ust?:stN€?ustB?Bst{p?Nst•ygL$2$L$,W
1NF (khúa AB)
aI2gq:?u??N?€?B?{?p?•?‹r
Bwx:ust?:stN€?ustB?Bst{p?Nst•ygL$2$L$$2W
g>$(L$M_BZ
& g>$(L$;_BZ
lOMoARcPSD|45022245
g>$(L$_BZ
:YJW
aMn$_$‰†@$q„Y?k#$?!'cr2$(!„YP
)$L$2$_$‰†@$L$$2W
3nf
aVn$pz:Nz$qp2N2$•N?_(,?<p$(?
e22$(?N2${?8$8@$?82$(8@$r20L$$2W
)*+0*3-,
a[n$pz:Nz$qp2N2$•N?_(,?<p$(?
e22$(?N2${?8$8@$?82$(8@$r=>L$$2W†.2
Vi phạm chuẩn 1nf (MaHang là thuộc tớnh đa trị)
a\n$pz:Nz$qp2N2$•N?_(,?<p$(?e22$(?N2${?
8$8@$?82$(8@$r? )$$2=>)$!$'
MaHang, Soluong, DonGia, ThanhTien
a^2/$g(4 )$CŒ„#&2?8u#$#&2?
eN8Y!$2>?N!>ck$‚$en!$(!‚,P)$
•$( #&2S$(#$#_(kp
WB8785=:!b%Y45?4c848'd7D:+e-dW
aan$pz:Nz$qp2N2$•N?_(,?<p$(?e22$(?N2${?
8$8@$?82$(8@$r"20L$eN8$#$ $ /$
$2W
HOADON(HoaDonID, NgayLap, TongTien)
HANG( HoaDonID, MaHang ,DonGia,Soluong,Thanh7en)
bb2/$
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
;
C7$(! $!$(Z
lOMoARcPSD|45022245
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?
_e$hr
2$(&ŽŽ<j2 !$„2 !$,$=P7$(S$(
=)&P2 !$$2P ••PK$(&
Kiểu RBTV: Liên bộ
b2/$
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?
_e$hr
2&%&Y0$$(&ŽŽ<j2 !$„2 !$,
$=P7$(S$(=)&P2 !$$2P ••
HOADON
b;2/$
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?
_e$hr
2&%&Y0$$(&ŽŽ82$(j2 !$?•$(E5$&ƒ$(•$(
$E5$ 2 !$E%S$(„2 !$••
u2$pz:Nz_?p•8•€8pz:Nz_
bI2/$
I
lOMoARcPSD|45022245
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?
_e$hr
2$(&ŽŽ82$(j2 !$?•$(E5$&ƒ$(•$( $E5$
2 !$E%S$(„2 !$••
g$(&#$2>$(&
Kiểu RBTV: Liên thuộc tớnh - liên quan hệ
bM2/$
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?
_e$hr
2&%$(&2>$(&(.Ž<j„0$L2$(
2 !$E%02$($70$L••
Kiểu RBTV: tham chiếu (phô thuộc,tồn tại)
bV2/$
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2q<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
$#&c!"S$/$$2W
AA855:
b[2/$
M
lOMoARcPSD|45022245
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?_e$hr
2&%&Y0$$(&ŽŽeY$(2>•$(
wY&E%2 !$S$(„2 !$••
uz•:_ppz:Nz_?p•8•€8pz:Nz_
b\2/$
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?
_e$hr
g$(&2>ŽŽeY$(2>•$(wY&E%2 !$
S$(„2 !$••
Kiểu RBTV: tham chiếu (phô thuộc,tồn tại)
b^2/$
pz:Nz_qp2N2$•N?_(,p2N2$?p$88$82$?
e2$(2<p$(?82$(8@$?_$†@$g@‡?
Cp$(g@‡rˆ
p•8•€8pz:Nz_q8@p2N2$•N?e22$(?N2${?
8$8@$?e$Rg@‡?p2N2$BPrˆ
N<e:_Rp:<qe$R•N?8@$e$R?N2$†8$?
_e$hr
V
lOMoARcPSD|45022245
g$(&2>ŽŽ8$E5$2$(jE%2 !$&ƒ$()
Y"$(=!$( S$(E%2 !$!••
Kiểu RBTV: Liên thuộc tớnh
ba2"!4/$gqe:r=) 7Bwxest:?:sty
L$2 "!4/$#$!" /$
4!%f4!B%
b2"!4gqe:uN<_r= 7Bwxe:tuN?est<?:s
t_yL$"!4/$g$ "!4/$
R1(SM); R2(AN); R3(SABD )
2"!4/$gqu:•Rnr=) 7Bwx:stuR=us
t•?:Rstnyg>$(L$$2W
2NF
;2gqe{•r=) 7Bwxst{e?{t•yg>$(
L$$2Wk$! $!$($J4012+*3 :YJW
& g>$(L$;_BZ
g>$(L$_BZ
gP7$(>$(L$$2
I2gq8pgr=) 7Bwxst8?
pgst?8pstgy
4012+*3 :YJW
M 2gq:?u??Nr†) ‡wx:ust?:ustN?st€yg=>L$
$2WVi phạm chuẩn: 3NF
Khúa AB thiếu thuộc tớnh E
V2gq:?u??N?€r†)‡wx:ust?:ustN?st€yL$"!4g
$ "!4/$R1(CE) và R2(ABCD)
[‘P2 gq_?<?R?n?g?8?…?Šr†)Bw|<stŠˆ<gt8?8stg?ngst8?<s
t…ˆ<8stR?_Rstn}W
[
lOMoARcPSD|45022245
Khúa: MNT,MNR
\CP02 !$& $?$("#%P%!"7$(
E$&2(4„!$?$(,?k#$P $(?!'cP $(?
!$2>P $(?„Y%P $(?YP20$P $(?
.$]$2 $!$?#$0$L?!$=')$?Y"$(?!$
( ?$E5$?•$(E5$?k#$$‚$=#$& $$(8@2&>$?$("#%
P%$#$ 7$(E$#$$&2$#$
E5$!52=-‚,S$(&0$($,
4!Lg*N#h+-U G*N#hD*iZCD*_**R
**,$j+.M%
4!LgkV*X*eD]*##kV]%
4 !Lg*N#hLgkV*XDk#ZkG#h+C$*-*.M%
^CP02 !$& $?$("#%P%!"7$(
E$&2(4„!$?$(,?k#$P $(?!'cP $(?
!$2>P $(?„Y%P $(?YP20$P $(?
.$]$2 $!$?#$0$L?!$=')$?Y"$(?!$
( ?$E5$?•$(E5$?k#$$‚$=#$& $$( 7$(E$$2
!"!"=2&0$(Ž•$7P $(••
4!LgkV*X*eD]*##kV]%J
a8uBwx:stu?sth?ustvyR7$2!",d$
fBust:&st:
stv)*+`#$$#`+
;b2&%9$(’!2>$"$(.$@@@$$(
B2$(Š@@wŽ•-$••2@&,@$$(@đưa ra danh
sách các tên hàng cú màu xanh từ bảng cung cấp và ds được sắp xếp
giảm dần theo tên hàng
;2&%9$(’!2>$"$(.$
@@&?2@?@$?P=?2$?,?2‡2$$@
“2$@2$&w@&
\
I$
lOMoARcPSD|45022245
lọc ra thông 7n gồm: số báo danh, họ đệm, tên, khu vực, toán, lý,
húa từ bảng điểm và bảng ds ;;p$!O,!7$(E$$$(
$=#$w^
=$=2[ $(Y$F2$(&0$(e†q?=?$(??E$r67$(
$$2W
Select * from sv where dt=8 and month(ngs)>=6 ;I 2 $
2$(•e€€8sBgz<sŠp€g€
;V8]S!$(2$(‚$e€€8
B878Y45?c848(45=6@lA:(5484@W
;[8.P2 /$gq?•?N?u?C?B??<?{r=) 7
Bwxst•NuCB?Nstu?Cst•?Cst?st<{yW
)*` C
;\8.P2 gq:?u??Nr†)•‡wx:ust?:ustN?tuyW
)*`
;^8.P2 gq_?<?R?n?g?8?…?Šr†)
Bw|<stŠˆ<gst8?8stg?ngst8?<st…ˆ<8stR?_Rstn}W)*` MNR,MNT
;a2/$qu?u;?uI?uM?uV?u[r?u=)wx?;?I?M?V?[y
)$?u?u;P2 7
u?u;sstuI?uM?uV?u[ˆu;sstuM?uV8 /$
!"/$$2W
R1(B2,B4,B5 ); R2( B1,B2,B3,B6 )
Ib2/$q:?:;?:I?:M?:V?:[r?:=)wx?;?I?M?V?[y
)$?:P2 7
:sst:;?:I?:M?:V?:[ˆ:Isst:M?:V8 /$
!"/$$2W
^
lOMoARcPSD|45022245
R1( A3,A4,A5 ), R 2( A1,A2,A3,A6 )
Ip/$P0g=g;
I;p/$g=g;
IM2"!4/$nq{?<?†?_?p?Rr= 7Bwx{s
t<?{st_?{stp?{stR?<st†?_pRst<y
n$#$!>L$$2W
2nf ( Khúa: G )
IV2"!4/$nq:?u??N?€?•r= 7Bw
x:Nst€u•?€st:Nyn>$(L$$2W
chuẩn bcnf ( Khúa là ACD, CE )
I[2"!4/$gq:?u??Nr= 7Bwx:ust
N?Nstyh !'$L$2$"!4/$gW
chuẩn 3nf ( Khúa là abc ) . 3nf
I\2"!4/$nq:?u??Nr= 7Bwx:ustˆ
ustNˆust:yn$n!>L$$2W
đạt 1nf ( Khúa là ab, bc )
I^2/$gq:?u??NrP)$:n$g>$(L$
;_B$"$(P7$(!>L$I_BR7$2(‚,=>I_BW
Iah"!4/$gq8?†?h?R?Cr=)7Bwx8†sthˆhRs
tCˆhst8ˆCstRyu2!$(
hwx8†Cyl)6
Mb2"!4/$nq:?u??N?€?•r= 7Bwx:Ns
t€u•?€st:NyC/$n8
M2"!4/$gq:?u??Nr?BwxNstu?st:?ust:Nyg>$(
L$$2W
a
lOMoARcPSD|45022245
2NF (khúa B và D)
M;2"!4/$gq:?u??Nr=)Bwx:Nstu?ust:?Nsty8.
P"!4#$WAD và BD
MI2"!4/$gq€?u??N?€?pr=Bwxust€?Nt:?st:?:€stN?
u€stpyP/$W
BC và BE
MM2"!4/$gq€?u??N?€?pr=Bwxust€?Nt:?st:?:€stN?
u€stpP/$W
BC và BE
MV2"!4/$gq€?u??N?€?pr=Bwxust€?Nt:?st:?:€stN?
u€stpyP/$WBC và BE
M[2"!4/$gq:?u??N?€r=)Bwx:ust?Nst€?ust:y?‘
P/$W
M\2/$gq:?u??N?€r=Bwx:€stu?stN?:stu€y?‘P
/$W
M^2/$gq:?u??N?€?pr=)Bwx:ust?Nst€?€st:?Nstp?ps
tuCgy
Ma2/$gq:?u??N?€?pr=)Bwx:ust?Nst€?€st:?Nstp?ps
tu )$Pg
Vb2/$gq:?u??N?€?{r=)Bwx:st?ustN€?
Nst€?:st€N?:ust{y8.P/$W
;b
Bấm Tải xuống để xem toàn bộ.