;F
B~ cU'o'ngon thi mon Co' so' dfi'li~u nang cao
I: Co' so' du'lieu qua" he
,
~ Cae bll'O'c xay d~mg cO' So' dft Ii~u theo PhuO'ng PhaP top-down.
.
;( 2) C~ch ?ay ~~rngcO'~~duoI,i~u~heop,hu~n~yhap bottom- tp &r~
~
/ !
K3) Cac van de trong VIyCquan tn cO' sO' du hyu.
d4) C{tCphuO'ng phap Iuu tru cac file cO',so'duoli~u €::::: ~A-
.
5) Trinh bay C{IC
buO'c xlr ly mQt truy van trong h~ quan tri cO'So'du li~u quan h~
6) Cae phuO'ng phap t6i uu truy v~n ( t6i uu theo gia, bi~n d6i tuO'ng duO'ng, theo ngu
nghTa)
II. Co' so' dii' lieu ph:}" tan,
;>(1). Djnh nghiat~p trung. li~u phan tan, cac d~c tnmg
cO'So'dlt clm cO'So'duoli~u phan tan so vO
Sl)' (iU' Ii~u
~ V2) Hay trinh bay c;;lCki~u phan do
,
Truy c~p cO's6 da li~u truac khi t~p hqp cac dff li~u tll' dfiu cu6i.
2) Hay vi~t mQt lmg d\)ng 6 muc trong su6t 2 tren CO's6 dff li~u vi d\) ( xem bai giang)
chuy~n nhil cung c~p 157 tu "SF" to "LA". ( Chll Y xem ca thong tin SUPPL Y,Slr d\)ng ng~
ngCi'SQL)
4) Xet c(lc luq'c d6 ph an do