;F
~
1
'8)
~
,
~
~
' :,
B~ cU'o'ngon thi mon Co' so'dfi'li~u nang cao
I: Co' so'du'lieu qua" he
,
~ Cae bll'O'cxay 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{ICbuO'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 nghia cO'So'dlt li~u phan tan, cac d~c tnmg clm cO'So'duoli~u phan tan so vO'
. Sl)'(iU' Ii~u t~p trung.
V2) Hay trinh bay c;;lCki~u phan do<;tndlt li~u
/3) Trang su6t phan t;;lnvericac lmg d~ng'chi dQc
J4) Trang sut)t phan tan vericac lrng d~ng C?Pnh?t
~/5) Cac,bu~c thi~t k€mQt cO'So'dlt li~u phan t{m
6) Thiet ke phan do<;tncO'So'dlt li~u
7) '1'hi6t k€ djnh vi cO'So'dlt Ii~u
() Cae bi~n ci{)itmmg <.1uO'ngd{)ivO'id<;tisf) quan h~

DOCTOR I = SLDEPT="SURGERY"DOCTOR
DOCTO R2 = SLDEPT~"PEDIATRICS"DOCTOR
DOCTOR3 = SLDEPT;t"SURGERY"AND DEPT;t "PEDiATRICS" DOCTOR
PA TIENTI = SLDEPT="SURGERY"ANDTREAT="IN'~ENsrvE"PA TIENT
PAT! ENT2 = SLDEPT="SURGERY"ANDTREAT;t"INTENSIVE"PA TIENT
PA TIENT3 = SLDEPTc,t"SURGERY"PA TIENT
CAREl = CARE SJ PNuM=PNuMPATIENTI
CARE2 = CARE S.JPNUM = PNUMPA TIENT2
CARE3 =CARE S.JPNUM =PNUMP ATIENT3
Hay chuy6n cac truy vc1ntoim qle sau day thanh cac truy v~n do<;tnva Slfd\)ng cac tieu
chu§n hI' I den 6 d~ dan gif1nch(mg. Su d\,mgd~i sf) quan h~ lwn ch~ khi dieu do ddn d~n v
lo<;tib6 cae do~mkhong duQ'ctruy v~n yeu duo
a) Li~t kc cae b~nh nhan Sll'd\)ng aspirin trong <.1i€utri
PJNAMdPATIENT NJN SLDRUG="ASPIRIN"CARE)
b) Lic;tkc dc bac SIda kc dan aspirin cho ciICbc;nh nhan dang bi di~l1tri tich CIJC
PJNAMESLDRUG="ASPIRIN"ANDTREAT=" INTENSIVE,,(DOCTOR JNDNUM=DNUMPATIENT t'{JN
CA~E)
c) Lic;tkc s6 lUQ'ngtrung binh aspirin duQ'cke dan cho cae b~nh nhan dang duQ'ccham ~
tich qre e6 aspirin trong dan thu6e ClIahq
GBAVG(QUAN)SLDRUG="ASPIRIN"(CARE NJN SLTREAT="INTENSIVE"PA TIENT)
d) Li~tke luang trung binh cua cac bac SIke dan aspirin nh6m theo khoa
GBDEPTNUM,AVG(SALjSLDRUG="ASPITIN,,(DOCTORIN DNUM=DNUMPATIENT N.JN CARE)
,
\.
' =