Luận án Nghiên cứu cài đặt một hệ cơ sở dữ liệu phân tán phục vụ việc quản lí dân cư thành phố Hồ Chí Minh

d(1t1I1(1th~CSDL phuntanphl;lCV(lcliovi~cqudnli duncll TP HCM 3.1.1.3Mo hinhh6nhop Phtiong-Ouan-Thanh pho' TP Ql ! \'\ 1*11PY II .~-......... """-"" --~Q2 PI P2 .Uu : Ne tnlnhcaekhuyetditim2mqhlnhtren .Khuyet: ~Vancothtiunde dukhaBangnho ~£)oihoinghi~pvl,Ixli'19eao 3.1.1.4Bai toanlaplich TrL(oekhichQI1l~(amohlnhketnoitoiUU.tadn chitielhoabailoanl~pnch chovi~etruyentrencaemodemgiUacaenode.No c69nghTatrangvi~cchQnII/a m6hlnhnaototnhat. 1.Mo hlnhPht({fng-Ouan-Thanhpho' Gia sli'toedQmodem:::::3MB I giG. Bangcachtfnhdph5ntruoe:::::200KB/ngay/phuang MQtqu~ntrungblnhc6 ::::: 15phl(ang,nhuthe 1ngayqu~nnh~ndO'li~u3 MB Gia slYthanhphoc6 4 line truyendu li~u, thllich duQcl~pthanh2 phcin: ~Qu~n gdi tMnh pho ~Phuanggdiqu~n '-Ouan gdi thanh pho': Trang34 Thai gian Qun Ngay trang 1,4,7... 2,5.8... thang:3,6,9... 8h-9h Q 1...Q4 9h19- lOb10 Qs ...Q8 QlIn Tpl1o 101120- 111120 Q9...QI2 Tpho xl'r19 Tpho Qun 1h30- 2h30 Q13...QI6 2h40- 3h40 Q 17...Q20 3hsO- 4h50 Q21 ...Q24 NJ:hienCllucui (1(11m(JIhf CSDL phUnIanph1:lcV1:lchovifc qudnIi dunCIITP HCM . Phuongdiquan Tu2Ijchtrentanh~nthaychukyla3ngay, nghTala moibie'nd6it<;1iphudngdn 3ngaysaumdic~pnh~t~ithanhrho. 2.Mo hlnh Phuon!!- Thanhph6- Ouan Thanhpho'co4line,moiphuongdn 30'.moingaythanhpho'nh~n6ca V~y:4*6*2=48phuong(moica:60')/ngay Toanthanhg6m303phuong, v~ythanhpho'nh~n£11phuonghe't6ngay Trllngbinhthanhpho'dn 3ngayxuIyvavaingaygaive T6ng~ 12ngay Nell laychukyc~pnMt la thudcdochinh,tathaymohinhPhuong- Thanhpho'- Qu~nuuthe'bon. 3 Mo hlnhh6nhdp Vantht!chit%nIjehke'tnoinhutrennhungthaigianehomoiIanit l~i.Nguyen nhanla dophuonglammjnkhfiuxu ly d€ phfinho~chr5 rangcacphie'unaGdn truyenchoqu~nhaythanhrhO'. De thay,thaigiantruyendn ~ 10',bhngly lu~ntuongtt!tatinhduQcchuky khoang3ngay.Tuynhien,dotinhphuct~pmamohinhnaykhongduQcchQn D€ dongianhoamavandambaathaigiannhenhat,tachQnphuongan : Phuong-ThanhphO'- Qu~n. 3.1.1.5Thli hi giiii (JUye'tcaephie'u: Khi I noi (qu~nhaythanhpho') nh~ncaetile truyentu phuong, dli lit%use dtc(jcXlC Iy thee16.Trinh t~Cgiai qllyct de lo~iphicuco y nghTaldn vi lien trinh dy ra khaenhallvavi<;ehQnphieunaotrudesauseco kef quanhunhau. Vi dB: ./NgtcoiA dangky kef hont;;liphuongB athdi di€n 1.1.1998(*) ./NgtcoiA dang ky chuy€n di kheithanhphoa thaididm2.1.1998(**) Neu XlCIy (**) taCdethilUec~pnMt tinhtr~nghonnMn A , se khongtImthayA do(**) <.15lamA khongconco sadli lit%uhit%nt<;1i. Trang35 Thdi gian Phudng Ngay trong 2,5,8... 3,6,9... thang:1,4,7... 8h- 9h PI, P2,P3 9h10- lOh10 P4, ...,P6 lOh20- 11h20 P7, ..., P9 P Q Qun xuly QP 1h30- 2h30 PlO,...,P12 2h40- 3h40 Pl3, ..., P16 3h50- 4h50 Q vaTP NRhienCL~1Icdi d(ItnU)1h? CSDL phlin fanphl;lCV(lchovi~cqllanIi dancII TP HCM Bang ly lu~ntuongHftaehQnphLeongaocangiaiquye'ttneGe? . Huanggiaiquye't: Xua'tphattVnh~nxetye'utothaigianxayratrenmoiphie'u1ftquanu'Qng. Moi phuong,ngoaicaefile bie'ndQnggoi len thanhpho,qu~ndn kemthee1 file tZll11ehobie'ttdnht~ethaigiancaelo~iphie'u. File nayeocall truenhusau: Field MS Phie'u Qu~n Phuong Ngay Gio Loai Char Char Char Date Time Thanhphosaukhinh~ncaelo~ifile t~msetr(>nl~ivasapxe'ptheethut~ thaigian.Vi~egiiiiquye'tcaephie'utheedungtrlnht~saukhid5.sapxe'p. 3.1.2Mo hlnhke'tnoimang Ta bie'trangeosodG'li~uphantanla 1h~thongmadG'li~uduQe~airatren nhi~umaytinhkhaenhauvamoenoithongquam~ngthongtindG'li~u. .M<Hsocauhlnhcoth~cotrongeaeke'tnoimangla : 3.1.2.1Ke'tnoi hoanroan PI'- ~ 3.1.2.2 Kel nQivong : Uu : Linh ho~tcae Khuve't: Chi phi lOn @ /~ C§J @ ~@/ Uu:M~ngdongian Khuye't:Thongtintraod6icae nodekhonglinhho~t Trang36 3.1.2.3CaLI true sao: NghienC[fUcdi d</tmr)th{!CSDL ph{inttinph(ICV(IchoI'i{!c({uunIi ddnof TP HCM @ @ ~c/ /~ @ @ 3.1.2.4CaLI truesao: @ /~ /@\ ~ C0 0 @ ~ . 3.1.2.5 C1Ll true bon hdQ: VLI : J:)dngian Khuye't:Ne'uco s~!co t<;1inut trLlngtamthim<;1nganhhuang lOn Vu : Phancapr6 rang Khuyet :Tl!dngn.!nhucall truc sao @ / ~ /~~ G) 0-@ @ ~ Trang thlfcti~n,cacchQnIlfa phI.}thuQcvaodi6ukit$nv~t chat, tinhchatb~li to:'ln.Do d~ctn!nght$quan19daBcu va Sifphancap CI:'1ano, tachQnIlfa mo hinh cay rho bai toannay. Vu :Phananhdungthlfclien Khuye't: Phuc t<;1Prho quan 19 3.2MO HINH QUAN NUtM DO LIitU Do baitoanla khalOn,thaigiankhongrhopheplritinkhail6ngquat,tachi vemohinht~i2mlicPhuong-Thanhpho Vi9CchamgiaQu~nvaomohinhhoanroankhonglamthayd6i mohinhdli li<$u nay.Baog6m: vMo hlnht<;1iPhl!ong Trang37 NghienCL{Uc/li (t('itm()the CSDL ph(lnteinph1;lCV1;lcho I'iecquilnIi delnCL(TP HCM ./M6 hlnht'.liThanhrho (j dily chungta tier c~nthea m6 hlnh"tu trenxuong". Bat dau W m6 hlnht6ng qU:'ltsaud6 phanra chom6hlnhphuongvathanhrho 3.2.1M6 I-fInhDC(Lieu T6ngquat: (Hlnhtrangsau) 4-'1 3.2.2M6 Hlnh Dll Lieu tai Phl(ong a. M6 hlnh: (Hlnhve A) 4"1 b. Tl( c1i€n dll lieu Nl;hiencuucdi dilt 1//(}thf CSDL ph£1ntunpJIl;lel'll ehovife quiinli danell TP HCM H~thongTI Quan Iy DC T 1 2 3 4 5 6 7 TentatTI MSNK Hoten NS SCMND 8 Gioitinh Honnhan TI-LAODONG TD-VANHOA BANGCAP LoaihoCT LoaihoHK TRUONGPT NGHANHDT NGHE CYCNY COQUAN TP-KINHTE NHUCAU-YL NGHE-ML DIEN-CSACH LYDO-DEN-TP NAM-DEN Mo hinhQN dCi'li~u. ~ ~. Ten thlfcthe: NHANKHAU Ngay10.5.98 Diengiai:Mo tathongtinnhfinkhffu Kh6a:MSNK Diengiai Giatri B B B K K B B B K B B K K K K K K K K K K K Lo,?-i C C D C N N N C C N N C C C C C C N C C C N MGT Dai 9 10 11 12 13 1-1- IS 16 17 18 19 20 21 22 I I 10 10 10 10 1 1 1 10 10 1 1 20 20 10 4 6 5 1 6 4 10 2 T6ng: 153 H~thongTI Mo hinhquanni~mdO'li~u QuanIy DC TenthlfCth~:TACHHO Diengiiii :Mo t.1thongtinvi~ctachhQmdihayd6ichuhQ:' Kh6a:MSPTH ;;1 Tinh~hat I LO~i I MGT I Chi~u~~i STI TentatTI I MSPTI-I 2 3 NgaylapPTH NNDLPTH Dien oiiiito> MS phicll t~1chQ K K Ngay11.5.98 D D 10 10 TONG: 30 Trang39 Nghien('Leucdi(1~7rI1l(Jrhf CSDL phc1nreinph!leI'!lehovi~equdnli dunell TP HCM H~th6ngIT Mo hlnhquanni~mdO'Ii~u ~gfly10.5.98 QuanIv DC Tenthl!Cth€: CDI Oi~ngicii:Phie'uchuy€ndi (trangTP) Kh6a:MSPCO SIT Tent5tIT Oi~ngicii Gi:i tri Loai MGT Dfli . I MSPCO B N 10 2 NgaylapPCO K D 10 3 NNOLPCO K 0 10 4 LYOO K C 10 5 NOIOI B N 1 SIT I 2 Oi~ngiiii:Mo tiithongtinPhie'usinh Kh6a:MSPS, UAN,PHUONG Oi~ngiiii . Gi:i trj Lo~i Msphie'usinh B N B N B N K C K 0 B C K 0 K 0 B N TONG: 65 TONG :41 H~th6ngIT QU<.1nIy DC Mo hlnhQN dO'li~u Ten thl!cth€.:PHIEUSINH Ngay10.5.98 MGT Ofli 10 2 3 i .:+ 5 Ten tiftIT MSPS Quan Phuong Benhvien I 1 2 10 10 10 10 10 1 6 7 NLKS SGKS NNOLPS N~aylapPS LoaiPS NgaylapKS so'giayKS NgayI~pOL 8 9 TONG: :: 54 Trang40 H th6ngIT Mo hlnhQNdO'liu Ngfly10.5.98 QlIanIv DC Tenthueth. P-TU Oin giiii:Mo tiithongtin:PHIEUTV Kh6a:MSPT,QUAN,PHUONG SIT TentatIT Oin giiii Gi<itn Loai MGT Dfli I MSPT Msphie'uor B N 10 2 Quan B N 2 3 Phuong B N 2 .:+ NNTC Ngaychet B C 10 5 NNOLPT NgayvaoOL B D 10 6 Nguyennhan s6 giayKS K C 10 7 NgaylapPT NgayIp DL K D 10 M - ~ /'0 h'lt'lh TONG o.uAT NHANKHAU (tI") NK-NTP SC'MNl> (0) I) I LI-IION MSLH (17,f) (0,1) TACIlIfD MSllI Cui'1) n,NI (0.1'11 {C,O ({J ,) (.J ") NUDe (0,") (HiNH A) M(}HINH nIT LI~U I)HU('1NG NHANKHAU NK-NP MSNI\.NTP NK-NTP S('MNIJ (0) I) I LI-IION I MSLlI (~)I) (17Jf) (0,1) TA('IIIIO MSTII ('DEN MSCDEN (v, I) (I.NI 10,NI Ib, f) (~I ) (~JI?) (0, Vi) Nxhienn(u dii ll(lt flU)th~CSDL pMn tanphl,leI'¥clIOI,ife quanli danell TP HCM 4 H<$thongIT Qllan Iy DC SIT 1 SIT 1 Mo h'inhqllan ni<$mdG'li<$ll Tenthueth~:P-CDEN Di~nghH:Thongtinv~lo~iehlly~ncte'n Kh6a:MSPCDEN ') Ten tiltIT MSPCDEN NNDL LYDO NGAYLAP LoaiCD Gid trj B K K K Ngay10.5.98 Lo~iI MGT N D C D D~li 10 10 20 10 Di~ngiai MITsophie'uehuy~ncte'n Ngayl~pdG'li<$u 3 4 5 H9thongIT Qllan 19DC Mo h'inhquanni~mdG'li~u Tentht!eth~:HONGOAIPHUONG TONGCQNG:SO Ngay10.5.98 Diengi::li:ThongtinNK dangkyhQkh5ungoaiphuong Kh6a:MSHNP MGT Dai 10 TentiltIT MSHKNP Diengiiii Lo~i C rTONGCQNG:I0 Gid trj B TONG: ::53 Trang41 H thongIT Mo h'inhquannim dG'liu Ngay 10.5.98 Qllan Iy DC Ten (hueth: LI-J-1.0N n Diengiiii:Thongtinlyhon Kh6a:MSLH SIT TentatIT Diengiiii Gi<itIi Loai MGT Dai 1 MS-PLH B N 10 2 Lihon-Lan K N 1 :1 SobanAN B C 10 4 QD-Ngay B D 10 5 SoeonLihon K N 1 6 NNDLPLH K D 10 7 NgaylapPLH K D 10 8 Loai K C 1 NghienCLlucui {l(itlIl(Jth~CSDL pMn tanph(/cV!tchovi?cquanli dun clf TP HCM H~thongIT 10.5.98 Qmlnly DC Mo h"inhquanni~mdITli~u Ngfly Tenthlfcth6:TlNH Diengiiii:M5h6ah~thongtinh Kh6a:MS-TlNH SIT I 2 TentiltIT MS-TlNH TENTlNH Diengiai GiGtrt B B Lo<}i C C MGT Dfli 2 10 TONGCQNG:12 He thongIT QuanIy DC Mo h"inhquanni~mdITli~u Tenthl!cth6:TONGlAO Ngay10.5.98 Diengiai:M5h6ah~thongtongiGO Kh6a:MS-TONGIAO STT I TenratIT MS-TONGlAO TONGlAO Diengiai MGT Dai 2 10'/ GiGtrt B B Lo<}i C C TONG: ::12 TONGCQNG:12 Trang42 H thongTT Mo hlnhquannim dITliu Ngay10.5.98 QuanIyDC Tenthl!Cth6:DANTOC Diengiai:M5h6aM thongDANTOC Kh6a:MS-DANTOC SIT Tel,dt 1'1' Diengiai GiGtri Loai MGT Dfli I MS-DANTOC B C 2 2 DANTOC B C 10 NghienCL?Uccii(l<ltm(jth? CSDL phiin tanphr,u:V!lchovi?cquiinli duncLlTP HCM HI$thongIT 10.5.98 QuanIy DC SIT I 3 4 TONG :67 M6 hlnhQN dO'lil$u Ngily Ten thl!Cth~.:QP ') Diengiai:M5h6ahl$thongtuongquantrongTP Kh6a:MS-PH,MS- Diengiiii Giatrj MGT Masophuong N Masoqll~n N B B -r- TONG: Chi~udili 2 2 15 15 TentatIT MS-PH MS-Q Ten-P Ten-G 34 He;thongIT QuanIy DC STT I ') 3 4 5 6 M6 hlohQN dO'lil$u Ten thucth~.NK-NTP Ngily10.5.98 Diengi,li:M6 tath6ngtinNguoingoaithilnhpho Kh6a:SCMND NTP,SONHA,DUONG,CUAN,TINH TenteltIT Diengiiii Gi,i tri Laail MGT HaTen B C TINH 13 C QUAN 13 C NTNS B D DUONG B C SCMNDNTP B C Dili 30 2 15 10 25 10 A TONG: 92 Trang43 HI$thongIT M6 hlnhquaDnil$mdO'lil$u Ngily10.5.98 QuanIy DC Tenthl(Cth: HO Diengiai:He)(CutruhaycHingkyh9kh5u) Kh6a:MSH SIT TentatIT Diengiai Giatri Lai MGT Dili I MSH M5 soh9 B N 10 2 HaTenCH Tenchuh9 B C 30 3 KHUPHO B C 2 4 DIABAN K C 2 5 NNDL B D 10 6 SO-NHA B C 10 7 MS-DUONG B C 2 8 LOAIHO K N 1 NghienCl?Ucdi (1(7tnu)thf CSDL pMn teinph{lcV(Ichovifc quilnIi duncll TP HCM H~thongIT Quan ly DC SIT I 2 3 4 5 6 7 8 9 H9thongIT Qu~lnIy DC SIT I 2 M6 hlnhQN dO'li~u Ten tht!cthti.KETHON Diengiai:M6tiith6ngtin:KET HON Kh6a:MSPKH Tent~tIT MSPKH KetHon-lan Ngay-DK Sogiay-DK NguoiLap SoCon2Nguoi NNDLPKH TheLoai NguoiLapPKH Diengiai Gi<itrj B K K B K K K B K Ngay10.5.98 Lo<;li N N D C C N D N D MGT Dai 10 1 10 10 30 1 10 1 10 Ngay10.5.98 TONG CONG : Trang44 --- Dai 2 4 M6 hlnhQN dO'li~u Ten tht!cthti.DMHO ~' TONG: ::83 Dien gi~li: Cho bitt hQthuQchQgl trangdanhI11I,lChanhchanh Kh6a : LOAIHO TenratIT LOAIHO TENHO Diengiai Gi<itri B B Loai I MGT--'- C C A' TONG: 6 12 HetbonoIT M6 hlnhQN dO'liu Ngay 10.5.98. QuanIv DC Tenthu'cthti.LOAIDKHK Diengiai:ChobittnhankhftudangkyHK aGaU Kh6a: MSDKHK SIT Tent5tIT Diengitii Giatri Loai MGT Dfli I MSDKHK B C 2 '") [,oaiDKI-I B C 10 NMhienn~ucui diJt m(jth? CSDL philn tanph¥ev¥eho\'i~equaIlIi ddneLfTP HCM H~thongIT QuanIvDC M6 hlnhQNdG'li~u Tenthucth~.LAODONG Ngay10.5.98 SIT I 2 Diengiai:Chobiertlnhtql.l1glaodOnghi~nqi Kh6a:MS-LD TentatIT I Diengiai I GiLltri I Loai IMGT MS-LD TEN-LD B B N C Chi~uDai 1 10 TONG CQNG: 11 H~thongIT QuanIv DC M6 hlnhQN dG'li~u. Tenthtfcth~.NKNP Ngay10.5.98 Diengiai: LuugiG'mas6nhankh5ungoaiphuong nhungvanthuOcM QL.Tp Kh6a:MSNKNP SIT I TentatIT MSNKNP Dien giai Giatri B Lo~i C MGT Dai 10 TONG CQNG : 10 TONG CQNG: 82 : Trang45 H thongIT M6 hlnhQNdG'Iiu Ngay10.5.98 QuiinIy DC Tenthtfcth. HO-N-TP Diengiiii :Chobierth6ngtinhQngoai'trudngphong Kh6a:SONHA,DUONG,QUAN,TINH SIT TentatIT Diengiai Giatri Loi MGT Dai I TINH B C 2 2 QUAN B C 15 3 TenCHNTP B C 30 4 SONHA B C 10 5 DUONG B C 25 H thongIT M6hlnhQNdG'liu Ngay10.5.98 QuanIv DC Tenthucth. NUOC Diengiiii: Danhnwede nudc Kh6a:M S-NUOC SIT TentatIT Diengiiii Giatri Loai MGT Dfli I MSNUOC B C 3 2 TENNUOC B C 20 Nghienerlucui c1(1tm(ilhf CSDL phantanphw:v~ehovifCquanli dunell TP HCM A" TONG: 23 H~tho'ngIT Qw.i.n19DC M6 hlnhQNdcrli~u Tenthueth8.DUONG Ngay10.5.98 SIT 1 2 Di~ngiiii:Danhml,lcacduongtrangthanhpho'. Kh6a:M S-DUONG Tendt IT I Di~ngiiii I Gi<itri I Loai r MGT MSDUONG TENDUONG B B C C Dai 3 20 TONG: 23 TONG CQNG: 20 TONG CQNG: 20 H~tho'ngIT Quan19DC M6hinhQNdcrli~u Ten MKH:Quanh~moi Ngay10.5.98 SIT Di~ngiai: Khi tachhQsethayd6iquanh~chuhQvanhankh5u Kh6a:MSPTH,MSNK,MSH Tent5tIT I Di~ngiai I Tfnh I Lo~i I MGT I Chi~uDai cha't I 2 3 4 MSH MSPTH Ql1anHeCT MSNK N C C C 10 10 10 10 TONG CQNG: 40 Trang46 H tho'ngIT M6 hinhQNdcrliu Ngay10.5.98 QuanIv DC TenMKH. DI-CP Din giai:Chobie'thQsetoicungphuong Kh6a:MSPCD,MSH SIT Ten ratIT Din giai Giatrj Lo;:1i MGT ChiuDai I MSPCD B N 10 ') MSH B C 10 H thongIT M6 hinhQNdcrliu Ngay10.5.98 Quanly DC Ten MKH:TU-CP Din giiii :Chobie'tnoihQxua'tphatcii tochuyn de'n Kh6a:MSCDEN,MSH SIT Tenrat Din giai Gi<itri Loai MGT ChiuDai I MSPCDEN N 10 ') MSH C 10.... NghierzcLeucui t1(1t1I1(lth~CSDL pht11ltall ph¥cv¥clIOvi~cquiinl£duncLlTP HCM TONG: 30 H~thongTT QuanIy DC M6 hlnhQN dO'li~u Ten MKH: Di-NTP Ngay10.5.98 STT Dien giai : Chobierphieuchuy€n di ngoaiTp. Kh6a : MSPCD,SCMNDCH-NTP TendtTT I Diengiai I Tinh I Lo~iI MOT chat Chi€uDfli I MSPCD SCMNDCH-NTP B B N C 10 10 'r TONG: 20 HethonoTT. '" QuanIy DC M6 hlnhQN dO'li~u Ten MKH: Di-NP Ngay10.5.98 STT Diengiai:Chobierphieuchuy€ndidenhQngoaiTp. Kh6a:MSPCD,MSHNP Tendt TT I Diengiai I Tinh I Lo~iIMoT chat Chi€uDai I 2 MSPCD MSHNP B B N N 10 10 _. TONG: 20 TONG: 20 Trang47 H thongTT M6 hlnhQNdO'liu Ngay10.5.98 QuanIy DC Ten MKH:: HK-NTP Diengiai:Nhankh5ucutn.1t<;liphlrongdangkyhQkh5ut<;liTp. Kh6a:MSNK,MSCMCHNTP SIT Tendt TT Diengiai Tinh Lo<;li MOT ChiuDfli chat I MSNK B C 10 2 SCMNDCHNTP B C 10 3 QuanheHKNTP B C 10 H thongTT M6hlnhQNdO'Iiu Ngay10.5.98 Qu.lnIv DC Ten MKH: DLH-NP Diengiiii :ChobietndidicuaITIQtnhankh5uWihQngoaiphuong Kh6a: MSPCO,MSHONP STT TentdtTI' Dicngiiii Oiatrj MGT Chiu Dai I MSPCO B 10 2 MSHONP B 10 NghienCIfUcclid(it l1l(jthf CSDL phiin tdnphl,lcV{Ichovifc quiinif dunell TP HCM TONG: 55 HethonoTT. "" Qllanly DC M6 hinhQN dCi'li~u Ten MKH: DI-TP Ngay10.5.98 ') Dien giai : CHO BIET di chuy~ndenhQkhacthuQcphuong Kh6a: MSPCD, MSH TentatTT Diengiai Giatr) LOAI I MGT MSPCD B C MSH B C TONG: 20 Chi~uDai 10 10 STT i TONG: 30 H~thongTT QllanIy DC M6 hlnhQN dCi'li~u Ten Mdi kethelp:NK-DKHK Ngay10.5.98 STT Dicn giai :MQtnh5nkhfflldangky hQkh511qi ITIQthQ Kh6a : MSHK, MSHK Ten tiltTT I Diengiiii I Tfnh I Lo~i I MGT chat Chi~uDfli I 2 3 MSNK MSHOK Ql1anHcHK B B B C N C 10 10 10 Trang48 H thongTT M6 hinhQNdCi'liu Ngay10.5.98 QuanIy DC Ten MKH: Di-N-NTP Diengiiii :ChobiernelidihQngoaithanhpho Kh6a:MSPCO,TENCH,SONHA,DUONG STT TentatTT Diengiai Giatri MGT Chiu Dfd I MSPCO B 10 2 TENCH B 30 3 SONHA B 10 4 DUONG B 15 He thonoTT M6 hlnh QN dCi'lill Ngay 10.5.98. "" Qllan IyDC Ten MKH: NK-CT Dien giai :Nhankhff dangky cu truqi I11QthQ Kh6a : MSNK, MSHK STT TentiltTT Dien giai Gia tr) LOAI MGT Chiu Dfli I MSNK B C 10 ') MSH B N 10 3 Qllanhc;CT B C 10 NghiencTiucui tl<lt/1/(J(h~CSDL philn ttinphl}cVI}cho~'i~cquail li t!tincll TP HCM ~., TONG: 30 H~thongIT Quanly DC SIT I 2 3 M6 hintQNdO'li~u Ten MKH: NH-DKNP Ngay10.5.98 Dien giai :MQtnhankhffu dangky hQkhffut~iphuongkhac. Kh6a : MSNK, NK-DKNP Diengiai I Tinh I Lo~i chfft Ten rat IT ChieuDaiMOT MSNK MSHKNP QuanHeNP B B B C N C 10 10 10 ,,' TONG: 30 H~thongIT Quanly DC SIT I ') TenratIT MSPLH SCMND M6 hintQNdO'li~u Ten Mdi KH: LH-NTP Diengiai: Kh6a:MSPLH,SCMND Diengiai I Tinhchfft 1- Lo~i MOT ChieuDai 10 10 Ngay10.5.98 B B N C ~. TONG: :: 20 HethonoIT. ;:, Qll~lnly DC SIT I 2 M6 hinhQN dO'li~u Ten Mdi KH : NK-LH2 Ngay10.5.98 Diengiai:Th6ngtinnguoilyh6n2thuQcphuongquanly Kh6a:MSflh.MSNKTenratIT I Diengi i Tinh I Lo~i I MGT chfft ChieuDai MSPLH MSNK B B N C 10 10 ,.:' 20 TONG: 20 Trang49 H thongIT M6hinhQNdi1liu Ngay10.5.98 Qllln ly DC Ten Mdi KH: NKNTP-NUOC Diengiai:ChobiernguoingoaithanhphothuQcquocrichnaG. Kh6a:SCMND,MS-NUOC SIT Tent:1tIT Dienoiiii Tinh Loi MOT ChieuDai0 chfft I SCMND B C 10 2 MA-NUOC B C 10 Nghienn?u cui (1<ltm(JtM CSDL phanteinph!lcV!lclIOvifc quilnIi duncLlTP HCM TONG: 20 H~thongIT Qllan19DC Mo hlnhQN dO'li~u Ten Mdi ke'th<Jp:KH-NTP Ngay 10.5.98 STT Diengiiii :NguoitrangphuongkethonnguoingoaiTp. Kh6a:MSNK,SCMND Tent5tIT I Diengiai I Tinh I Lo<;1i I MGT chat Chi~llDai I MSPKH SCM1'..JD B B N C 10 10") TONG: ~ 20 TONG: 20 H~thongIT Qll.ln19DC Mo hlnhQNdO'li~u Ten Tht!c th~: NUDC Ngay10.5.98 STT 1 2 Tent5tIT MS-NUDC TEN-NUDC Dicngiiii Tinhchat B B LO~li C C MGT Chi~uDai 3 15., TONG: 18 Trang50 H thongTT Mo hlnhQNdO'Iiu Ngay10.5.98 Quan19DC Ten Mdi ke'thop:NK-KH2 Diengiai:Thongtinlienquankethen2ngl(oithllQCphuongqllan19 Kh6a:MSHK,MSPKH STT Tent5tIT Diengiai Tinh Loi MGT ChiuDai chat 1 MSPKH B N 10 2 MSNK B C 10 -" H thongIT Mo hlnhQN dO'Iiu Ngay 10.5.98 Quan 19DC Ten Mdi ke'th<;1p:LH-NP STT Ten tt IT Diengiai Tinh Lo<;1i MGT ChiuDai chat 1 MSPLH B N 10 ..., MSNK2 B C 10.. .. ..- NghienCl(Ucui c1(i(111(;(hf CSDL phiin ((/nphllCVIIchol'ifc quaIl li dunCllTP HCM TONG: 13 H~thongIT Quiin19DC M6 hinhQN dG'li~u Ten MKH: THUOC2 Ngay10.5.98 Diengiai :ChobierhQngoaithanhphothuQcdnhnaco Kh6a:MS-NUOC,TenCH-SoNha,Duong T TentatIT Diengiiii Tinhch5t Lo~i I MS-TINH B C 2 SCMND-CH-NTP B C MOT Chi~uDai 2 10 TONG: A' 20 TONG: 12 TONG: 20 Trang51 H thongIT M6 hinhQNdliliu Ngay10.5.98 Quan19DC Ten M KH: :HONTP-NUOC Diengiiii :ChobierhQngoaithanhphothuQcI1lfocnaG Kh6a:MS-NUOC,SCMND-CH-NTP SIT TentatIT Diengiiii Tfnhch5t Loai MOT ChiuDai I MS-NUOC B C 3 2 SCMND-CH-NP B C 10 H<$thongIT M6 hinhQNdG'liu Ngay10.5.98 QllanIy DC Ten Moi KH: NAM Diengiiii:ChobierhQn5mtfenduongnao. Khca:MSH,MS-DUONO SIT TentatIT Diengiiii Tfnhch5t Loi MOT ChiuDai I MSH B N 10 2 MS-DUONO B C 2 H thongIT M6 hinhQNdG'liu Ngay10.5.98 QllanIy DC Ten Moi KH: DI-H-NP Diengiai:Chobierndidi nhankh511toihQngoaiphuong. Kh6a:MSPCD,MSHONP SIT TenratIT Diengiai Tfnhch5t Loai MOT ChiuDli I MSPCD B N 10 2 MSHONP 13 C 10 Nghienet?ucui (1(1tl1l(jth~CSDL ph{jntdnph{ic~'(ichovi~cquiinli dunelfTP HCM H~thongIT QuanIV DC SIT I 2 H~thongIT Quan19DC SIT I ') H~thongIT QlIan 19DC SIT I 2 H~thongIT Quan19DC SIT I 2 Me hlnhQN dO'li~u Ten Moi KH : DI-HNTP Dien giai :Chobietnc1idi h9ngoaithanhpho. Kh6a : SCMND, MS-PCDI Dien criai Tfnhchat Loai B C B C Diengiai:Chobietdichuy~ndenh9khacthuQcphuong. Kh6a:MSPCD,MSH Diengiiii Tfnhchat Lo~i B N B C TONG: TenratIT MS-PCD SCMND Tendt IT MSPCD MSH MOT " TONG: Me hlnhQN dO'li~u Ten Moi KH: DI-TP MOT Me hlnhQN dO'li~u Ten Moi KH: TU-NTP Diengiiii :Chobietphie'uchuy~nde'ntll'daBngoaitp Kh6a:MSPCDEN,SCMND-CH-NTP Diengiiii Tfnhchat Lo~i B N B C TentatIT MSPCDEN SCMND-CH-NTP MOT A' TONG: Me hlnhQN dO'li~u Ten Moi KH: TU-NP Ngay10.5.98 Chi~uDai 10 10 20 Ngay10.5.98 Chi~uDai 10 10 20 Ngay10.5.98 Chi~uDai 10 10 20 Ngay10.5.98 Dien giai :Chobie'tphieude'nthuQcqu~n, phuongnaG(trangTP) Khoa : MSPCDEN, MSH-NP. Dicn criiii Tinhchal Loai B N B N TentatIT MSPCDEN MSH-NP MOT A' TONG: 20 Chi~uDai 10 10 Trang52 NghienCL(Ucdi dilt /1/(Jth~CSDL pluln tanphl;lCvl;lehovi~equanIi dunell TP HCM TONG: 20 H~thongIT 10.5.98 Ql1anly DC Mo h'inhQN dCi'li~u Ngay Ten Moi KH: NK-LH 1 - SIT I TentatIT MSPLH MSNK Diengiai:Thongtinlienquanphie'uIi honvanhtinkh511. Kh6a: MSPLH,MSNK Diengiai Tfnhchat Lo~i MGT B N B C Chi€uDfli 10 10') TONG: ~ 20 TONG: 20 TONG: 20 Trang53 H thongIT Mo h'inhQNdCi'liu Ngay10.5.98 Quanly DC Ten Moi KH: NK-DEN Diengiai:Chobie'tmoiquanh phie'uchuyn de'nvainhankh5unaco Kh6a:MSPCDEN, MSNK SIT TentatIT Dien iai Tfnhchat Loi MOT ChiuDfli I MSPCDEN B N 10 2 MSNK B C 10 H thongIT Mo h'inhQNdCi'liu Ngfly10.5.98 Quanl' DC ' Ten Moi KH: NK-KHI Diengiai:Thongtinlienquanphie'uke'thonvamQtnhtinkhffu.. Kh6a:MSPKH,MSNK SIT TentatIT Diengiai Tfnhchat Loai MOT ChiuDfli I MSPKH B N 10 2 MSNK B C 10 H thongIT Mo h'inhQNdCi'liu Ngay10.5.98 Ql1.1nly DC Ten Moi KH: NK-DI Dicngiiii:Chobie'thongtingiUanhankh5udi. Kh6a:MSNK,MSPD SIT Tenlt IT Dien iai Tfnhchat Loai MOT ChiuDfli I MSPD B N 10 2 MSNK B C 10 Nghihl euuedicliftIll(lth(?CSDL phc1n((illplll,u.:V!IclIOvi(?equanIi ([{inell TP HCM H~thongIT Qui.lnIy DC M6 hinhQNdliIi~u Ten MdiKH: NDEN Ngay10.5.98 SIT I 2 Diengiai:dientadnhmanhankhffud trudcdenTp .HCM. Kh6a:MSNK,MS-TINH Diengiai I Tfnhchat B B Tendt IT MSNK MS-TINH MOT Chi€uD 10 2 TONG: -;zr 12 H~thongIT Qui.lnIy DC M6 hinhQNdliIi~u Ten Moi KH: : NQUAN Ngay10.5.98 SIT 1 Tendt IT MSNK MS-TINH Diengiai:Dientanguyenquancuanhankhffu. Kh6a:MSNK,MS-TINH Diengiai I Tlnhchat B B MOT Chi€uDai 10 2') TONG: 12 H~thongIT QuanIVDC M6 hinhQNdliIi~u Ten Moi KH: : SQUAN Ngay10.5.98 SIT 1 2 Dien giai :Dientanguyenquar,cuanhankhffu. Kh6a: MSNK, MS-TINH Tent5tIT I Diengiai I TlnhchatI MOT MSNK MS-TINH Chi€uDfli 10 2 TONG: 12 TONG: 20 Trang54 H thongIT M6 hinhQN dO'Iiu Ngay 10.5.98 Quan IV DC Ten Moi KH: PTH-HO Dien giai :MQtphieutachhQlien quandenhQnaco Khoa : MSPTH, MSHK SIT Ten t[ltIT Dien giai Tfnhchat LOAI MOT ChiuDai 1 MSPTH B C 10 2 MSHK B C 10 NghienCl(Ucdi d~7tm(jth~CSDL phc1ntanphl;lCv¥clIOvi~cquanIi dancl1TP HCM Ht$thongIT M6 hlnhQNdulit$u Ngay10.5.98 Quanly DC Ten Moi KH: NK-TG Di~ngiai:T6ngiaocua nh£1nkhffu. Khoa:MSNK,MS-TG SIT Tendt IT Di~ngiai Tfnh LOA! MGT Chi6uDai chat 1 MSNK B C 10 2 MSTG B C 2 TONG: 12 Ht$thongIT Qlian 19DC M6 hlnhQNdulit$u Ten MKH: NK-TU Ngay10.5.98 SIT Tendt IT Di~ngiai MGT Chi6uD?li 1 ') MSNK SITPT QUAN PHUONG B B B B C N N N 10 10 2 2 ::I .:+ TONG: 24 TONG: 12 TONG: 30 Trang5:5 Ht$thongIT M6 hlnhQN du liu Ngay 10.5.98 ! Quan ly DC Ten Moi KH: NK-DT I Din giai :Mieu tii clantQccuamQtnhankhffu. Khoa : MSNK, MS-DT SIT Ten ratIT Din gitii Tfnhchat MGT Chi6uD?li 1 MSNK B 10 2 MSDT B 2- H thongIT M6 hlnhQNduliu Ngay10.5.98 Quanly DC Ten Moi KH: CUTRU-NP Dicngiai:MQtnh£1nkhffucohQkhffuti phlfongco thtfcutn.!ti phuongbn . Kh6a:MSNK,MSHONP SIT Tcn ratIT Din gi:ii Tfnhchat LOA! MGT ChiuD?li 1 MSNK B C 10 2 MSHONP B N 10 ::I QlIanheNP B C 10-' Nghiene!(uedi 11ij(Il1(J(h~CSDL p/ulntanph~leV~lehovi~equan[{duneLlTP HCM H~thongIT Quan ly DC Mo h1nhQN dCi'li~u Ten Moi KH: CUTRU-NTP Ngay10.5.98 SIT I 2 3 TenratIT MSNK MSHONTP QuanheNTP Di~ngiai :Mieu ta lllQtnh5nkhtlucu'tn.1t<;tidjachingofliTp. Kh6a : MSNK, SCMND-CH Di~ncriai Tinhchat LOA! B C B N B C MGT ChiSuDfli 10 10 10 TONG: ~. 30 3.2.2!VIaHINH xU'LY TAl PHUONG Cffn0: Phicu h<;5pl~ . x{f LY VA c~p NH~T Phieu sinh,tlf,lylkethon.. Phieu sinh tlf Phieu ly/kethon Phieu di den Phieu t~lch Q .. ------.. . . I ToPHol . :I<CAP I : Chi tiethoalo~iphieu BI: MO HINH xV LY PHIEUSINHTAl PHUONG Phiell khong IHjpI~ 1.2 Ca'pnh~t NK,cu' tn! phan tan P SINH Trang56 NghienClfllcui #t 11I()thf CSDL pMn tanph(/cv(IchovifCqudnif ddnclI TP HCM .M(}HINH XU LY PHlEU KET HONTAl PHUONG khongh<jpl~ / 0 NHANKHA \,THN ~ 1~ 1 Khac phltC1ng . Cling phuong :=[TP TraWi Kh6nghejp ~~KETHON Khac th.pho 3.3 Ki(fmtra t6nt~i nhankhflu ~~ 3.4 TP ~/' Chlfa ,. C6 0 3.5 N? NK-NTP Them .-->r 0 KETRON KH ~ [)p Trang57 Nghien el{Uedi (l<Jtl11(jrhf CSDL phan tan phl:lcv~~eho vifc quan If £Ian el( TP HOyf .MO HINH XU LY PHrEU LY HON TAl PHUONG 4.1 ¥ 0 NHANKHATTI Phie'llly hon . Kh6ng hC;p 1<% I 1 Khac phuong 4.4 ~ .. . Td Wi ~EJ,~ Cling phuong .. Td 0 LIHON ~ D LIHON ~ D NK-NTP Trang58 NghienCL(Ucui d<7tm~;th~CSDL phiin tanph¥cv¥chovi~cquilnli clfinct{TP HCM .MO HINHXU LY PHn1:uC' DENTAl PHU(1NG Khongh<jpl~ p' CDEN 5.1 P.cde'n (Khacphuong) 5.3 C~pnh~t thongtin 2 node(z) 5.4 La'ythong tin tu tp . (C6) 5.6 C~pnh~t thongtin \ OPC'. nf'.n (Khac phttong) ~!IITraWiTP NK TP NK.NP PC'.I)F.N Trang59 NRhie,lCallcui #t m(jth~CSDL pht:1ntanphl,lcVl,lchovi~cquilnli dancll TP HCM *MO HINH xiI LY PHIEU DI TAl PHUONG ,. TP 6.2 C~pnh~t thongtin 2node(x) Cdi Nhankhan (NgoaiTP) 6.4 Cdi 6.3 C~pnh~t JNK ..[LNhankhan!tt2nole(y) ~HO Hongoai Tri'.loi 0 NhankhanI Trang60 NghienCUllcui dt;ltm(jth~CSDL phtinttinphl,lcVI,lchovi~cquiinli duncll TP HCM A' ", A' , A *MO HINH XU LYPHIEU TACHHO ! /' 7.1 ~ '\:h~~lo~ivakIemtra~ . Kh6ng h<;1pl~ I Hinh/+hQmOi TP 7.2 Cm quail h~ TT nhankhau TT c~p/nh~t 7.5 C~pnh~t nhankh§'u HQ P tachhQJ TP Chtiy: Chi thu'c~tidip Dhattai 7.6 Trang61 Nghieneau edid4tm(Jthf CSDL phantanph¥ev¥chovi~cqudnIi dun ell TP HCM Dinhnghia0 xii'19: Ten HTIT: . ,,<uiinIy DC DL VaG Phie'usinh-->1.2 Phie'umota0xii'Iy 1.2 Diengiai:c~pnh~than Tomtilt * NMp phie'usinh *Nh~pnhilnkhffumdi *Tie'nhanhghidcrli~utren mohlnhDhilntan. . Ngay:11.05.98 tinnhankhffumdi I DLra 1.1- ->nguoiduaphie'u 1.1- ->1.2 TenHTIT: t..<llanIy DC DL VaG Phie'usinh-->2.1 Phie'umota0 xii'Iy2.1 Di~ngiai:Ki~mtraphanlo'.li Tomtilt I Phanlo<:1ivaki~mITa I '"Ki~mtratlnhh<;1pphapP tii' * Philolo~iNK co hQkhffudangky tronghayngofliDhuong. Ngay:11.05.98 DLra 1.1- -> 1.2 Trang62 TenHTIT: Phie'umota0 xii'Iy 1.1 Ngay:11.05.98 QuiinIy DC Din giai:Kim tratlnhh<;1pphapvaphilo100;liphie'ustsco me,haykhong? DL VaG Tomtilt DLra Phie'usinh-->1.1 * Kim tratlnhhnguoiduaphie'u * Philoloaiphie'usinh 1.1- ->1.2 Ten HTIT: Phie'umota6xU'ly2.2 Ngay:11.05.98 QuanIv DC Din giai:CD nht tai2node DL VaG * NMp giatrjphilotU'. DLRa 21-->2.2 * Php thongtincp nht. nhilnkhffu. 2.2-->TP * Cp nMtmohlnhphilotan. 2.2-->PTV 2.2-->NHAN KHAU Ten HTIT: Phie'umotii0 xU'Ii 3.1 Ngay:11.05.98 QuanIy DC Diengiai:Philoloaikim tra DL VlO Tomtt DL ra P ke'thon-->3.1 * Kim trah3.2 * PhilolO3.3 - Nhan kh5um>3.1 ke'thendk hQkhffuthuQcphuong khong? Nghienctiu('(Ii{l~ltIIIt}th? CSDL phantanphl;tevl;tehovi?cqudnli danell TP HCM Trang63 TenHTIT: Phieumota0xli'1/3.2 Ngay:11.05.98 Quanly DC Diengiiii:Cp nht t<;1i2node DL VaG *Nhp thong tin p.sinh,nhan DLra 3.1-->3.2 khti'u. 3.2-->NHANKHAU TP-->3.2 * Cp nht trenmohlnhphantan 3.2-->PKETHON tNK - NTP 3.2-->TP. TenHTIT: Phieumota0 xli'1/3.3 Ngay:11.05.98 Quanly DC Kim trat6nti NK tran,gTP DL VaG Tomtdt DLra 3,1-->3.3 Kim tra co t6n qi nhankIlti'll 3.3-->3.2 TP-->3.3 trangphieukethentNgaydt1a TenHTIT: Phieumota0 xli'ly 3.4 Ngay:11.05.98 Qu£inIy DC KitSmtraSCMNDngt1oikethencot6nti ? Tom tilt DL VaG Kif-mtrad5congt1oib<;1nkethen DL ra 3.1-->3.4 t6ntl trangCSDL ti Cl;}Cbi?va 3.4-->3.5 NK-NTP -->3.4 tuxacht1a? 3.4-->3.2 TP -->3.4 Ten HTIT: Phieumotii0 xli'ly 3.5 Ngay:11.05.98 Qu£inIy DC Themvacp nMt T()mtt DL VAo -Themnhankhti'ungoiiiTP DL ra 3.4-->3.5 - C pnMt thongtinkethenrhea 3.5-->NK-NTP mohlnhphantan 3.5-->KETHON 3.5 -->TP Ten HTIT: Phieumotii0 xli'ly4.1 Ngay:11.05.98 Qu£inIy DC Phanloaiva kim tra Tomtt DL VAo -Ki0m lra tfnhh<;1p1<;cua giay DL ra P Iy hon-->4.1 Iy hen 4.1-->Ngt1oidt1a NHANKHAU -->4.1 - Phan loi ngt1oib4.2 phieulyhendangky(j dau? 4.1-->4.3 NKhihl CUUcai (14tm(Uhf CSDL phantanph~cv~chovifc quaIl If £Iancl.lTP HCM DLvAG 4.1-->4.2 TP -->4.2 Phieumota0xU'Ii 4.2 C~pnMtt~i2node Tom t:1t * Nh~P dCi'li~uphieuIy hon vatInhtr~ngnhankhffu. * C~p nh~t tren2 nodetheo mo hint dCi'li~uphantant~i TP vaohu'onO' Ngay:11.05.98 DLra 4.2-->TP. 4.2-->NHANKHAU 4.2-->LIHON. Trang64 TenHTIT: Phieumota0 xU'Ii 4.3 Ngay:11.05.98 Quanly DC Kim ITat6ntaiNK trongTP Tom Hit DL VAo Kim ITat6nti NK trongTP DLra 4.1-->4.3 nhu'ngkhacphu'ongtrongphieu 4.3-->4.2 TP -->4.3 1yhondITt6nti trongCSDL 4.3-->ngu'oidu'a chu'a Ten HTIT: Phieumota0 xtrIy4.4 Ngay:11.05.98 Quan1yDC Kim ITat6ntaiNK ngoaiTP Tom tt DL ra DLVAo * Kim trangu'oibn 1yh on 4.4-->4.5 4.1-->4.4 ngoal TP dITc6 trongCSDL 4.4-->4.2 NK-NTP -->4.4 chu'a TP -->4.4 TenHTIT: Phieumota0 xU'194.5 Ngay:11.05.98 Quan19DC Themvacp nMt DLVAo Tom Hit DLra 4.4-->4.5 ThemnhankhffungoaiTP vaG 4.5-->NK-NTP DL. Cp nht thongtin ly hon 4.4-->LYHON vaNK theomohintphantan 4.5-->TP NghieneL?Uedi d(itm(Jthf CSDL philn tanphl:leVl:lchovife qudnli claneLlTP HCM Ten HTTT: Quan 19DC Phie'umota0 xli'195.3 Ngay:11.05.98 Di€n giai:C~pnMt thongtintfen2node. DLVAo \ TP -->5.3 \ 5.1-->5.3 Tom tdt DL ra * Tie'nhanhc~pnMt thongtin 5.3-->TP tren2nodeTP vaphuong. 5.3-->NHANKHAU 5.3-->PC DEN. TenHTTT: Quan 1yDC Phie'umota0 xli'1y5.4 Di€n giai: Ngay:11.05.98 DLvAG 5.1-->5.4 TP -->5.4 Tomtdt * Lffythongtinnhankhfiutlf dCi'1i~1ITP * C~pnMt Iffythongtinmdi. DLra 5.4-->5.8 Trang65 TenHTIT: Phie'umota0 xli'195.1 Nay: 11.05.98 Quan19DC Phanlo,!ikim ITa DLvAo TomHit DLra P CDEN -->5.1 - Kim eraHnhhP CDEN NHANKHAU -->5.1 - Phanlo,!iphie'uchuyn de'n 5.1-->5.2 5.1-->5.3 5.1-->5.4 TenHTIT: Phie'umota0 xli'195.2 Ngay:11.05.98 Quiin19DC Din giai:Tqchiletlmkie'm DLvAo Tomtdt DLra 5.1-->5.2 - Tunkie'mt,!iphuong 5.2-->5.6 - Tunkie'mt,!iTP 5.2-->5.5 NghienCl(lIeiJi dilt11I(Jth~CSDL philn tanph!/eV!Iehovi~equail Ii diln elfTP HCM Trang66 H Th6ngIT: Phieumotaaxii'Iy6,1 Ngay:11.05.98 QuanIy DanCll' Kim travaphanlo:,li. Tomtilt DLra DL VAG * Kim tratinhhNgu'oidi ' J -->6.1 chuyn di. 6.1-->6.2 * Phanlo:,liphieuchuyn di 6.1-->6.3 theeloai HaC? 6.1-->6.4 H Th6ngIT: Phieumotaa xii'Iy 6..2 Ngay: QuanIy DanClf 11.05.98 Cp nht phantanZ DLVAo Tom tilt DL ra 6.1-->62 Cp nht thongtin tren2 6.2-->TP TP -->6.2 nodetheemohlnhphant:in. 6.2-->NHANKHAU 6.2-->CBI H ThongIT: Phieumotaaxii'ly 6.3 Ngay:11.05.98 QuanIy DanCll' Cp nht phant:inZ DL vAG Tom rilr. DLra 6.1-->6.3 Cp nht tren2 nodethee 6.3-->TP TP -->6.3 mohlnhphantan. 6.3-->NHANKHAU 6.3-->CB! H ThongIT: Phieumotaaxii'ly 6.4 Ngay:11.05.98 Quanly DanClf Cp nMtphantanY DL vAG Tom tilt DLra 6.1-->6.4 Cp nMt theemohlnhphiln 6.4-->TP TP -->6.4 tanti 2node 6.4-->NHANKHAU 6.4-->CDI 6.4-->HaNGOAIPHUaNG NghiennfU ctii d(/tm<Jthi}CSDL ph£1nttinph{lcI'!lC/1ovii}el/wlnlf c!t'1IleLfTP HC,\<[ H~Th6ngIT Quanly DanCL( DL VaG 5.2-->5.5,5.7 TP -->5.5 Phieumot,1a xU'Iy5.5,5.7 Di~ngiai:5.5,5.7 Tom Hit Ohi nh~nvac~pnh~thongtin tren2Nodephuongva TP ~gay:11.05.98 DL ra 5.5-->TP 5.5-->NHANKHAU 5.5-->CDEN 6.4-->HONTP H~Th6ngIT QuanIy DanCL( DL VaG TP--> 5.8 5.4-->5.8 Phieu 1110t,1a Xl( IY 5.8 Di~n giai: Tom t5t C~p nh~t thongtin theo1116 hlnh dli li~uphant,1ntai 2 node TP. phL(Ong. Ngay:11.05.98 DL ra 5.8u>TP 5.8-->NHANKHAU 5.8-->PC DEN. 5.8-->NK-NP. -- H~Th6ngIT Quiil1 I)' D511Cu' DL VaG 7.1-->7.2 TP -->7.2 Phieu1110tii a xli'Iy 7.2 Dicn gi<'ii:C~pnh,}t2 node Tom t~t C~pnh~[thongtinh9vaquan h~nh5n khau [rangh9 trcn m6hlnhphan[<in Ngay: 12.05.98 DL fa 72 -->TP. , 7.2-->NHANKHAU 7.2-->HO Trang67 H th6ngIT Phieumotaa xli'ly 5.6 Ngay:11.05.98 Quan Iy Dan CL( Din giai:Cp nMt thongtin DL VaG Tom Hit DLra 5.2-->5.6 Cp nht thongtin tren2 node 5.6u>TP TP n>5.6 bangmohlnhphantan. 5.6-->NHANKHAU 5.6-->PC DEN. H Th6ngIT Phieu 1110taaxli'Iy 7.1 Ngay: 12.05.98 Quan Iy Dan CL( Din giai: Ki111traphanloi DL VaG Tom t5t DL fa P.tachh9 -->7.1 *Kim tfatinhhQpphap 7.1n>Nguoi * Phanloi tachh9 7.ln>7.2 7.1-->7.3 NglIien ('lfU cdi (1(1tm()tIIf CSDL phc1ntanph{ICv~chovifc qwJnIf ddnell TP HCM H~ThongIT \,.!U<lnIy Dan Cu DLra 71-->7.3 H~ThongIT Quin Iy DanCl( DL ra 7.3-->7.6 7.2-->7.6 7.3-->7.6 TP-->7.6 Phieu 1110taaXl( ly 7.3,7.4,7.5 Diengiiii:C~pnMtphantan Tom tM -Themh9mdihlnhthanhtrongphieutachh9. -C~pnh~tmoi quanh~I11Oivdi nhankhffu trongh9. C~pnMt thongtin h9 bi thayc16itrenphieu Chllh9 Ngay: 12.05.98 DLra 7.4,7.3-->ho 7.5,7.3-->NHANKHAU 7.3--->PTACHHO 7.3,7.4,7.5 >7.6 Phieumotaa xu1y7.6 Diengiai:C~pnh~tphantan Tomt~t C~pnMt rheamohlnhphantan thayc16ih9,nhankhffuvaphieu t<ich9. Ngay:12.05.98 DLra 7.6-->TP 7.6-->NHANKHAU 7.6PTACHO 7.6HO 3.2.2 Mo hlnhdO'lieu taiThanhpho :1.M<1hlnh thl(Cthti ket hop: (Hlnhve B) b.Tl( c1itinau lieu: 86 lr~inhI~p1~1i,tachimotacacthlfCthel11a1110hlnhphuongkhongco ho~cco nhl(ngsekhac1sothu9Ctlnh. Cic tlWcth6khongc1€c~peoinhugionghoanloan. b.T~(c1i6ndO'li~u: Ta chimotatomd tcaethlfeth6khaebi~tsovdimohlnhtrudc H~thongIT Quanly DC STT 1 2 3 4 M6 hlnhQN duli<$u Ten thtfcth~: KETHON Diengiai:Motathongtinehoslfkethon Khoa:STTKH,QUAN,PHUONG Ngay 11.05.98 TenratTT Dienoiiiib Gia tri Lo~i Dai MSKH QUAN PHUONG MSkethon B 13 B N N N 10 2 2 . . . . . . . . . . . . . . . . . . . . TO NG:57 Trang68 (HINHB) M(}HINHOULItU TP MSNK (I,N> MSCDI QUAN PHUONG (0,1) (0,1) ((J) )1) TACHHO MSTIi QUAN PHUONG CDEN MSCDEN QUAN PI IUONG LI-HON MSLH QIJAN PHUONG II.NI (O.NI (gIlt) (0) f) (C/4) ((/~) (..,1)t) NUDC L01It) (0/)\) Nghien('leuc(/i (1(71m(Jth~CSDL phrrntanph(lcV(lchovi~cquan[[duncil TP HCM He;thongTI Quan Iy DC STI 1 2 3 4 He;thongTI QuanIy DC 1-. STT J 3 4 Tltangtt!tht!eth€ ke'thontruDe Mo hlnhQN dli E<$u Ten tht!eth€ : LYHON Di~ngiiii :Motathongtinehostfly hon Kh6a:STILH, QUAN,PHUONG Ngay 11.05.98 TentatTI Di~ngiai Giatrj LOZli Dai MSLH QUAN PHUONG MS ly hon B B B N N N 10 2 2 . . . . . . . . . . . . . . . . . . . . ruangtt!tht!dth€ truDe TONG: 57 Mo hlnhQN dli li<$u Ten thl!eth€ : HO Di~ngiai:Nhutniae Kh6a:STIHO, QUAN,PHUONG Ngay 11.05.98 Tendt TT Diengiiii Gi;i tr! LO:,1i Dai MSHO QUAN PHUONG M5 sohQ 10 2 2 B B B N N N . . . . . . . . . . . . . . . . . . . . flfang II! tht!dth€ truDe TONG :71 Trang69 He;thongTT Mo hlnhQN dftli<$u QuanIy DC Ten tht!eth : CD! Ngay 11.05.98 Din giai:Nhutruae Kh6a:STTCDI,QUAN,PHUONG S'IT TentatTT Diengiai Giatr! LoZli Dai I MS CDI MSchuyn B N 10 2 QUAN di B N 2 3 PHUONG B N 2 4 . . . . . . . . . . . . . . . . . . . . "\fangII! thl!Cth truDe -' t 'Nt T . 4"'1 Nghien Cl{llcui d41t/I/(!thf CSDLphuntanph(JCv¥chovifc qulInli duncLfTP HCM H~thongIT Quan19DC SIT 1 2 3 4 Mo hlnhQN dITli~u Ten tht!cth€ :CDEN Di~ngi<ii:Nhutruck Kh6a:SIT CDEN,QUAN,PHUONG Tent~tIT Di~ngiai Giatri B B B . . . . ru'dngtt!tht!dth€ tru'oe Khongh9Pl~ haydangLock Caeloaiphie~ -MO HINH XU LY TAl THANHrHO. MS CDEN QUAN PHUONG MS chuy~n den . . . . . . . . a.Moh'inh: 1.CaR 0: Phu'dnggdi 2.CflR 1: PhanIOqi vakfchhoqt phuongban c~pnh~t phantan Ngay11.05.98 Lo<}i Dfli ... Danglock haykhong h9pl~ Trang70 Phu'onglien quan N N N 10 2 2 . . . . . . . . TONG :54 . Caelo?iphieu Nghienn?u cui dIU!I/{)th~CSDL phdntanph(u;V~lehovi~equiinli duneli TP HCM *Chi tie'teuaeaeIillifu : <1.Phie'u sinh: Kh6ngh<;jpl~ ha~dangLoo Phl(OngA PI1l(ongB Td loi tan. ~K~D NK P SINH ,. A.3 Chotin hi~uphuong b~n P.sinh NK Trang71 NghienCUllcai d<lt11l(}(h~CSDL phdn(tinphl;lCVl;lchovi~cqLlllnli dunell TP HCM b.Phieuttf: Phuon(} Ab PTU P.ta Khong h<;5pI~haydangLock ;. NHANKHAU . P.tti ,. PhuongB I TraIoi~ Tn! Wi. (Khong) (Haytimeout) PhuongA ,. (Dti<;5C) B.4 C~p nh~it mohlnh phantan PTU NHANKHAU (TInhtr'.lng,conma't) c.Phieu ket bon: P. kcthon ,. 0 NK-NTP 0 P.KETHON I C.l NH "- ~ NHANKHAUI~ Kh6ngIantruy~n I. PhtiongA Kh6ng h<;5p1<; , haydangLock Trang72 NghienCL(Ucai d(i/II/(I/ hI}CSDL phunteinph(lcV(IclIovil}cqudnIi dc1nclI TP HCM d.Phieuly bon: P.ke'than P.LYHON Phl(dngA KhanghQpl~ haydangLock e. Phieu chuy6nden: P. chuy~nde'ri /°NHANKHAU] ~ Phan lo~i ki~mtra . E.3 C~p nh~H moh'inh phanhill P.ede'n 0/ P.CDEN Tenhi)ell ~ IpHUONG I Td WiKhang h<;1pl~hay" dang Lock I Pht(dngA TrongTP P. chuy~nde'n D P.CDEN (Ngoai TP) Td loi t -1J HO-N-TP I ~ NHANKHAUI PHUONG '. Trang73 Nghiencau cui dilt m(jth~CSDL phdntanph~cv~clIovi~cqudnl{dan cll TP HCM f. Phie'uchuy~ndi: ,.Kh6ngh</pl~haydangLock I PhuongA ~NHANKHAUIMS P.Di Trangphuong (ngoaiphuong) ChuyenDi I0 s6 CMND-CH_NTP T ? I'. , 'ra 01 . FA C~pnh~t mohlnb philotan CHUYENDI TeaWi 1 (' oj rHDONG I Trang74 Nghiencau cdi d(it/1lr)th~CSDL phdntanphl:/cVI:/chovi~cqudnli danCliTP HCM g.Phie'utachh6: P. tachhQ 0 HO Quanh~ PmJON Khongh</pl~hay dangLock I PhuongA ,. ( B6i chuhQ) !IP. tachhQ 0 PTACHHO I G.3 C~pnh~t mohinh phantan HO PTACHHO Tn\ Wi 1 I PHUONG I Trang75 Nghiencliu cui (li;1tm('Jth~CSDL phtintanphf:lcVf:lchovi~cqudn[[dtlnctJ TP HCM b.Tlf di~nDL cae0 xU'19: Trang76 H Th6ngTT Phie'umota0xU'19Al ngay13-05-98 QuanIVDC Kim ITa,phanloai DL vilo TomT5t DLra PhuongA --->Al - Kim ITat1nhejpl phie'ugdi Al --->PhuongA - Kim ITaDL eobjlockkhong? Al --->A2 - Phanlo A3 khomr? Al ---> PhuongB H Th6ngTT Phie'umota0 xU'19A2 ngily13-05-98 QuanIv DC Cp nht phantan DL vilo TomT5t DLra Al --> A2 -KhoaTable A2 --->P.Sinh -Cp nMt caethongtin mdiv A2 --->Nhankhau P.Sinh -NhaTable H Th6ngIT Phie'umota0 xU'19A3 ngily 13-05-98 QuanIv DC Chotinhil$u DL vilo TomT5t DLra A3 n> A3 -ThongbaoehophuongB khong A3 --->A4 PhuongB ---> A3 ep nhp thongtin va eho tin A3 --->PhuongA ,. hil$utuB H Th6ngTT Phie'umota0xU'19A4 ngay13-05-98 Quanly DC Cp nht phantan DL vilo TomT5t DLra A3 --> A4 -KhoaTable A4 --->P.Sinh -Cp nMtP.Sinhvonhankhftu A4---->NHANKHAU -Nhakhoa H Th6ngTT Phie'umota6xU'19B 1 ngay13-05-98 Ql1anIv DC Kim tra,phanloai DL vilo TomTh DLra PhuongA --> B1 -Kim tnitlnhhejpI DL B1 --->B2 Nhankhau--->B1 -Kim tratablecolockkhong? B1--->B3 -Phan loPhuongB truyn ? NRhiencuucai (l(1tm(jth~CSDL phtintanph~ev~ehovi?cqudn[{diln ell TP HCM H~ThongTT ~uan1yDC DL vao Bl --> B2 Phie'umota0xl't1yB2 C~pnh~theemohIntphan1<1n TomTat -Khoa -C~pnh~tPhie'utl't -C~pnh~tnhankhilu .ngay13-05-98 DLra B2 --->P.Tu B2--->NHANKHAU Trang77 H ThongTT Phie'umota0xl't1yB3 ngay13-05-98 QuanIv DC C pnh ttheomohlnhphantan DL vao TomTat DLra Bl -->B3 rho nhn thongbaatuphltongB B3 --->B4 PhuongB m>B3 B3--->PhuongA H ThongTT Phie'umota0xl'tly B4 ngay 13-05-98 Quanly DC Cp nMtmohInt(mode) DL vao TomTat DLra B3--> B4 -Khoa B4 --->P.Tu -Cp nht P.Tl'tvanhankh:1u B4---->NHANKHAU H ThongTT M((cmota0 xl'tly CI ngay13-05-98 QuanIv DC Kim tra,phanloai DL vao TomTat DLra PhUl{OngA --> C1 Kim traTablebikhoa C1 --->PhuongA Nhankh:1u-->Cl Kim tratjnhhQpl phie'ugdi Cl --->Cl PhanloaiIantruvn C1 --->C3 H ThongTT Macmota0xl'tly C2 ngay13-05-98 QuanIy DC Cp Nht,PhanTan DL vao TomTat DLra Cl --> C2 KhoaTable C2 --->Nhankhilu Cp nht NhanKhilu,phie'uKH C2 --->pKethon Nhiikhoa C2 --->NH-NTP Nghiencuucui tlij.t1/II)th~CSDL phiin tanph':lcV':lchovi~cquaIl li dancli TP HCM Trang78 H Th6ngTT Phie'umotaaxU'ly Dl ngay13-05-98 Quan19DC Kim tra,phanloai DL VaG TomTat DLra PhuongA --> DI Kim ITatinthc;lpl phie'ugoi D1 --->D2 NHKHAU --->DI Kim ITaDL cobilock Dl --->PhuongB Phanloi P. Iyhon Dl --->D3 H Th6ngTT Phie'umotaaxU' Iy D2 ngay 13-05-98 Quan 19DC C pnh t mode DL VaG TomTat DLra Dl --> D2 KhoaTable D2 ---> Nhankhau Cp nht Iyhonvanhankhau D2 ---> P.Lihon Nhfftable H Th6ngTT Phie'umotaxU'IyEl ngay13-05-98 Quan19DC Kim tra,phanloi DL vao TomTat DLra phuongA n> EI Kim tratinthc;lPI phie'ugoi EI --->E2 Nhankhau-->E I Kim traDlcobi Lockkhonh E2 --->E3 Phanloi phieuchuyn den H Th6ngTT Phieumota0xU'lyE2 ngay 13-05-98 Quan19DC C pnh t(3mode) DL VaG TomTat DLra EI --> E2 Khoatable E2 --->Nhankhau Cp nMt thongtinchuyn de'n E2 --->peDen Cp nMtnhankhau E2--->PHUcJNG NhaTable H Th6ngTT Phie'umota0 xU'lyE3 ngay 13-05-98 Qu,ln19DC C pnhtmohIntphantan2mode DL VaG TomTat DLra EI -->E3 -Khoatable E3-->PCDen -Cp nht thongtin chuyNhankhau . nhankhauvahe>ngoaiTp E3-->HO-N-TP E3--->PHUcJNG NNhiencuucdi cl(itIIIl)th? CSDL phtintanph¥cv¥chovi?cqudn1£duncli TP HCM H~ThongTT ~uanIy DC DL vao F3-->F4 Phieuroota0 xi'tly P4 C~pnh~tphantan{* TomTat -KhoaTable -C~pnMt nhankhffu,chuy~ndi, HO- N-TP -NhaTable ngay13-05-98 DLra F4 --->Nhankhau F4 --->c.di F4 > H-N-TP F4--->PHV<JNG H~ThongTT ~uanIy DC DL vao PhliongA > GI HO ---> G1 Phieumota0 xi'tly G1 Ki~mEra,phanleaL TomTat -Ki~mEratlnhh9Pl~phieugdi -Ki~mEraDL Lockkhong? -Phanloaiphie'uchuv~ntachho ngay13-05-98 DLra Gl m>G2 G1 --->G3 Trang79 H Th6ngTT Phie'umota0xi'tlyPI gay 13-05-98 Quanly DC Phanloai,kim tra DL vao .TomTt DLra PhuongA--> Fl -Kim tratinhh9Pl phieugi'ti PI --->F2 Nhankhau-->Fl vaTablebiLock? FI --->F3 -Phanlo<).iphieuchuyn di H ThongTT Phie'umota0xi'tlyP2 ngay13-05-98 QuanIv DC Cp nMtmohlnhphantan DL vao TomT t DLra FI --> F2 -KkoaTable P2 --->Nhankhau -Cp nht thongtIn chuyn di, F2 --->Chuyendi nhankhffu F2--->PHU<JNG -NhaTable H ThongTT Phieumota0 xi'tlyF3 ngay 13-05-98 QuanIy DC Kim trahQNTP dffeo trongCSDL ehu'a. DL vao TomTt DLra Fl --> F3 Tru'dekhiquye'tdinhghithongtinhQ F3 --->F4 Fl--> HO-N-TP mdi , KT hQell dfft6nt<).iehU'a. . Nghifl11eltueai diJt mQth~CSDL phlln tanphl,icVI,ichovi~cquiinif dtlnell TP HCM 3.2.5 r])lllLIl. I'tLeal'..1I1l1l'../hi/hanft. eal'..quaIL he. Ta 1110hlnhquailni~111DL taphanra tMnhde quailh~vdichuY vi~ephanraa daycho1116hlnhPhuongt~iTph6lahoanloangi6ng. H.Phan fa: l.QNHANKHAU (#MSNK, HoTen, NTNS, So-CMND, GioiTinh,... ) 2.QHO (#MSH , HoTenCH , Quan, Phuong,Khurho , Diaban, ...,Ioai-ho) 3.QNK-CT ( #MSNK ,#MSHCT , QuanheCT) 4. QNK-DKHK (#MSNK, #MSHDK, QuanheHK) 5.QHONGOAIPHUONG (#MSHNP , QuanNP, Phuong2 ) 6. QHO-NTP ( TenCHNTP , SoNhaNTP , DuongNTP,#SoCMND-CH-NTP ) 7.QNUOC ( #MS-NUOC , TENNUOC ) 8.QHONTP-NUOC (#SoCMND-CH-NTP ,#MA-NUOC ) 9. QTHUOC2 (#SoCMND-CH-NTP ,#MA-'fINH) 10.QNK-DKNTP (#MSNK, #SoCMND-CH-NTP ) 11.QNK-DKNP (#MSNK , MSHONP ) 12.QTINH (#MS-TINH, TENTINH) 13.QDUONG (#MS-DUONG , TEN-DUONG) 14.ONAM (#MSH ,#MS-DUONG ) 15.QpCOi (#MSPCi , loai CO , NgaylapCD,NNOLCOi... ) 16.QNK-Di (#MSPCD, #MSNK) 17.QOi-H-NP (#MSPCD , #MSHONP) 18.QOi-H-NTP (#MSPCO , #SoCMND-CH-NTP ) 19.QOi-TR-P (#MSPCD , #MSH ) Trang80 H Th6ngTT Phie'umetae xii'ly G2 ngay13-05-98 Quan 1YDC Cp nMt phantan. DL VaG TomTih DLra Gi--> G2 -KhoaTable G2 --->HO -Cp nht mohlnhphilntan G2 --->PTACHHO -NhaTable G2 --->PHV<JNG H Th6ngTT Phie'umeta0xii'ly G3 ngay13-05-98 Quan19DC CQPnMtmohlnhphantan2 DL VaG TomTftt DLra Gl--> G3 -KhoaTable G3 --->P.TACHHO -Cp nht mohlnhphantan G3 --->HO -NhaTable G3---->PHV<JNG Nghieneuucui d(it/1/(Jth~CSDL phuntanphf:lcVf:lchovi~cquiinl£dunell TP HCM 20.QpCDEN (#MSPCDEN , NgaylapPCDEN, NNDLPDEN , ...) 21.QTHEMMOI( #MSPS,QUAN, PHUONG, #MSNK) 22.QNK-DEN (MSPCDEN , #MSNK ) 23.QpSINH (#MSPS, QUAN, PHUONG, NgaylapPS,NNDLPS, loaiPS,...) 24.QPTU (#MSPT , QUAN, PHUONG, NgaylapPT, NNDLPT, LyDo, ) 25..QNK-TU (#MSPT,QUAN, PHUONG, #MSNKTU ) 26.QKETHON (#MSPKH , loaiKH, NgaylapPKH, NNDLPKH, ) 27.QNK-KHI (#MSPKH, #MS-NKI ) 28.QNK-KH2 (#MSPKH , #MS-NH2 ) 29.QNK_TP (#MSNK2,...) 30.QNK-NTP (#SoCMNDNTP , HoTenNKNTP , SONHA , DUONG ,loaiNTP, ) 31.QKH-NP (#MSPKH ,#MSNK2 ) . 32.QKH-NTP (#MSPKH , #SoCMNDNTP ) 33.QLYHON (#MSPLH, loailh , NgaylapPLH, NNDLPLH, ) 34.QLHONP(#MSPLH , #MSNH2) 35.QLHONTP ( #MSPLH, SoCMNDNTP ) 36.QNK-LHI (#MSPLH, #MSNKI ) 37.QLH-LH2 (#MSPLH, MSNK2 ) 38.QTONGIAO (#MS_tg , TEN-TG ) 39.QTINH ( #MS-TINH , TEN-TINH ) 40.QOANTOC (#MS-OTOC , TEN-DTOC ) 41.QNK-CUTRNP (# MSNK, #MSHNP, QuanheNP) 42.QNK-CUTRNTP (#MSNK , #SoCMND-CH , QuanheNTP) 43.QTU-NTP (#MSPCDEN ,#SCMND-CH-NTP ) 44.QPTACHHO (#MS-PTH, NgaylapPTH, Quan, Phuong,NNDL, ) 45.QTU-CP (#MSPCDFN , #MSH ) 46.QPTH-HO (#MSPTH , #MSH) 47.QTU-NP (#MSPCDEN , MSH ) 48.QTHUOC (#MSPTH , #MSH , #MSNK , Quanhemoi) 49.QNK-TU (#MSPT, #MSNK) . 50.QNK-TGIAO (#MSNK, #MS-TGIAO) 51.QNK-DT (#MSNK ,#MS-DTOC ) 52.QNQUAN (#MSNK, #MS-TINHNQ) 53.QSQUAN (#MSNK, #MS-TINHSQ) 54.QNOEN ( #MSNK ,#MS-TINHNDEN ) .T6 h(/pcaeQuanhecum!khoavacaephuthuocham: (Chl1Y : Mffsomoilo~iphie'ug6m:stt,qu~n,phuong,lo~iphie'u) Trang81 Nf.:hiencilu cui d(1tnl(jth~CSDL phiin tanph¥cv¥chovi~cqudnli diin ell TP HCM b.Phu thuoeham: 1.MSPLH ~ MSNKMC . 2.MSPLH ~ MSNKBL 3.MSPKH ~ MSNKI 4.MSPKH ~ MSNK2 5.MSPKH ~ MSNK-NP 6.MSPKH ~ SOCMNDNTP 7.MSNK ~ MSHDK 8.MSNK ~ MSHCT 9.MSNK ~ #SOCMND-CH-NTP lO.MSNK ~ MSHNP 11.MSPT ~ MSNK 12.MSPLH~ MSNKI 13.MSPLH ~ MSNK2 14.MSPCDI ~ MSHONP 15.MSPCDI ~ #SOCMND-CH-NTP 16.MSPCDI ~ #MSH 17.MSPS ~ MSNKMC 18.MSPS ~ MSNKBL 19.MSNK ~ MS-TINHNQ 20.MSNK ~ MS-TINHSQ 21.MSNK ~ MS-TGIAO 22.MSNK ~ MS-DTOC 21.SQ-CMNO-HO-NTP~ MS-TINH 24.S0-CMND-HO-NTO ~ MS-NUOC c.allanhesankhit6ho'p(nhi'imthoacaedangchu§n) l.QNHANKHAU (#MSNK, #MS-TINHQ, # MS-TINGSQ , # MS-DTOC , # MSHCT , # MSHDK , loaiDKHK , #MS-HNP, # SOCMND-CH-NTP, # MS- TGIAO ,#MS-DTOC, HOTEN, NTNS, SO-CMND, GIOITINH ,HONNHAN... ) 2.QHO (#MSH, TenCH, MS-Ouong,Quan,Phuong,Khupho,Diaban,Loaiho, Sonha,NNDL ) 3.QHONTP(#SO-CMND-CH-NTP,TenCHNTP,SonhaNTP,DuongNTP,Loaiho, MS-TINH, MS-NUOC) 4.QTONGIAO (#MS-TG,TEN-TG) 5.QOANTOC(#MS-OT,TEN-OT) 6.QTINH(#MS-TINH,TEN-TINH) 7.QpSINH(#MSPS,LoaiPS,#MSNKMOI,#MSNK-MC,#MSNK-BL, Benhvien, NgaylapPS,NNOL,... ) 8.QNUOC(#MS - NUOC,TENNUOC) 9.QOMHO(#LOAIHO,TENHO) Trang82 NghiencllUcd;#1 m(Uh? CSDL p/ulnfanphl;lCVI;lchovi?cquaIlII duncll TP HCM 10.QDUONG(#DUONG,TENDUONG) 1L QLOAIHOHK (#MSDKHK,LOAIDKH) 12.QLAODONG(#MS-LD,TENLD) 13.QNK-NTP (#SCMND,Hoten,NS,SoNha,Duong,Tinh,Nuoc) 14.QKETHON (#MSPKH,NgayDK,NgayLapKH,Kethonlan,LoaiKH,...,MSNK) MSNKCP, MSNKKP, SCMND-TN) 15.QTU (#MSPT,MSNKC,LydoC,NgayTu,NgayLap,NNDL) 16.QLYHON (#MSPLH, NgayQD,Lyhonlan,LoaiLH, MSNKCP, MSNKKP, SCMND-TN,MSNK) 17.QCTRU-NP(#MSNK,#MSHNP,QuanheCT-NP) 18.QCTRU-NTP(#MSNK,#SCMND-CH-NTP,QuanheCT-NTP) 19.QTU-NTP(#MSPCDEN,#SCMND-CH-NTP) 20.QTU-NP (#MSPCDEN,#SNSH-N8) 21.QCDI ( MSPCDI, LoaiDi,LyDo,MSHCDENP,MSHCDEN-NP,SCMND-H- NTP, NgayLap,NNDL ...) 22.QCDEN (#MSPCP,Loai-CDEN,MSHONOIDEN,SOCMND-CH-NDI,MSH- NP-NDI,Lydo...) 3.2.6. @tie..1'l!!.l!L[Hille..loan Dell: a. MSHONP E MSH trangCSDL loanTP b. MSH* E MSH trongclIngffiQtphU'C1ng c.LyhonLan>=1,E N d.SoConLyhon>=0, E N e.NgayLapPT <=NNDLPT f. NgayLapPS <=NNDLPS; NLKS <=NgayLapPS g. NAM-DEN-TP >=NAM (NTNS) h.Socon2nguoi>=0, E N i. Kelhon-Lan>=1, E N j. Ngay-DK <=NgayLapPKH <=NNDLKH k.NgayLapPTH<=NNDLr'.H I.NgayLapPCD<=NNDLPCD ffi. NgayLap PC DEN <=NNDLPCDEN n. NgayLapPLH <=NNDLPLH; QD-Ngay<=NgaylapPLH o. . NeuLo<;1iLH=1(TrongPhuong) ThlMSNK2E MSNK (TrangPhuong).Neu IOZliLH =2(NgoaiPhuong) ThlMSNK2 E MSNK (ToanTp) p.. NeuLoaiKH =1(TrongPhuong) ThlMSNK2 E MSNK (TrangPhuong) .Neu Loai KH =(2) (Trong TP) Thl MSNK2 E MSNK (ToanTP).Neu MSNK E MSPKH Trang83 N!{hieneuucui d(itm(Jth~CSDL phtintanphl,lcvl,ltho vi~cqudnIi dunell TP HCM ThlMSNK TINHTRANG6D='BQcThan'ho~c'G6a' q.Ne'uMSNK E MSPLH ThlMSNK TINHTRANG6D='C6GiaBlnh' r.Ne'uTT-LAODONG=1(C,6vi~clam6ndinh) Thl Chucvu' ',Coquan' ',NHU-CAU-VL =0 s.Ne'uTT-LAODONG=3vaNHU-CAU-VL=1(C6nhuc5u) ThlNgh~-ML" , t.Ne'uLo~iKH =3(NgoaiTP)Thl 3 MSPKH ->SCMND(Chonhi~ub<;lnke'thall) u.Ne'uLo<;liKH =4(Ngoainude)Thl 3 MSPKH ->SCMNDNN(Chonhi~ub<;lnngoainude) - Ne'uLo~iLH =3(NgoaiTP)Thl 3 MSPLH->SCMND(Chonhi~ub<;lnngoaiTP) - Ne'uLo~iLH =4 (Ngoainude)Thl 3 MSPLH->SCMNDNN(Chonhi~ub~nngoainude) v. '\f PSINH -Ne'uMSPS ->MSNK Thl MSNK.NTNS <=MSPS.NGAYLAPPS y. '\f PTV -Ne'uMSPT ->MSNK Thl MSKT.NGA YLAP >=MSNKNTNS . '\fPSINH: -Ne'uLo~iPS='BL' ThlMSNKMC =Null vaNK.DKHK=NULL NKDKCT =PSINH.MSNKBL -Ne'uLo~iPS='MC'ThlMSNKBL =NULL v~NK.DKCT=NKMSNKMC.DKCT NKD KHK=t~KMSNKMC.DKHK . '\f KETHON - Ne'uLoaiKH=l (CungPhuong) Thl SCMND-NT=MSNKKP=NULL -Ne'uLoai.KH=2(ClIngTp) Thl SCMND-TN=MSNKCP=NULL -Ne'uLoaiKH=3 Thl MSNKCP=SCMND-KP=NULL . '\fNK: - Ne'uLoaihoHK='P'Thl MSHNT=SCMND-CH=NULL=QuanheHKNP=QuanheHKNTP -Ne'llLoaihoHK='KP' . MSHDK=SCMND-CH=NULL=QuanheHKP=QuanheHKNTP -Ne'uLoaihoHK='KTP' MSHDK=MSHNP=NULL=QuanheHKP=QuanheHKNP. '\f KH: MSNK E MSNK CCuaPhuong) Trang84 NghiencuuciHdilt TnQthf CSDL phcintanphf:leVf:lehovi?equdnII danell TP HCM . V LH : MSNK E MSNK(Cua Phuong) . V LHON: .Ne'uLoaiLH=1(CungPhuong) Thl SCMND-NT=MSNKKP=NULL .Ne'uLoaiLH=2(KhacPhuong) Thl SCMND-NT=MSNKCP=NULL) .Ne'uLoaiLH=3(KhacTp) Thl MSNKCP=MSNKKP=NULL . V NHANKHAU: .Ne'uLoaihoCT='P'Thl MSHCT-NP=SCMND-CT-NTP=NULL Va QuanheCTNTP=QuanheCTNP=NULL .Ne'uLoaihoCT='TP'Thl M SHCTP=S CMND-CT -NTP=NULL 1 Va QuanheCTP=QuanheCTNTP=NULL .Ne'uLoaihoCT='NTP'Thl MSPCTP=MSHCT-NP=NULL Va QuanheCTP=QuanheCT-NP=NULL . V LYHON: MSPLH.MSNKHONNHAN='Cogiadinh' Va MSNKNAMSINH >=18 . V KETHON: MSPKH.MSNK.HONNHAN='Goa'HAY 'Lyhon'HAY 'Docthan' vaMSNKNAMSINH >=18 . V PHIEUCDEN: .Ne'uLoaiphieuCDEN=1(NgoaiPhuong) Thl SCMND-CH-NTP=NULL NguocLai : Thl MSCH-NP=NULL . V PHIEUDI: .Ne'uLoaiphieuCDi=l(ThuocPhuong) Thl MSHCDENNPHUONG=SCMND-HO-NTP=NULL .Neu LoaiphieuCDI=2(NgoaiPhuong) Thl MSCDENP=SCMND-HO-NTP=NULL NguocLai : Thl MSCDENP=MSCDEN-NPHUONG=NULL Trang85