Tải bản đầy đủ (.pdf) (61 trang)

Quản lý thi cấp chứng chỉ mảng đào tạo trung tâm tin học trường đại học an giang

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 (2.23 MB, 61 trang )

TRU'O'NG DAI HOC AN GIANG
KHOA KY THUAT - CONG NGHE - MOI TRLf^NG

H6 TH| ANH THU1

KHOA LUAN T6T NGHlEP DAI HOC NGANH CD" NHAN TIN HOC

QUAN LY
THI CAP CHtTNG CHI - MANG DAo TAO
TRUNG TAM TIN HOC - TRU^NG DH AN

GIANG
TRUCiNG D^l HOC
AIM GIANG

thUvien
GV. hu>ang din:
Ks. Dang Thi Nhung

An Giang, 05/2006


Luan van t6t nghiep

LOI CAM ON
S3 ****

De tai nay dugc hoan thanh ngoai sir n6 lire cua ban than, con co sir giiip da tan tinh ciia
quy thay co va tat ca cac ban. Em xin girt lai cam on chan thanh den:
•Cac thay co trong Trung tarn Tin hoc va khoa KT thuat - Cong nghe - Moi truang,
tnrbng DH An Giang da luon quan tam, tao dieu kien tot de em thirc hien de tai.


•Cac thay co tnrang DH An Giang, truang DH Khoa hoc tu nhien, va truang DH
Can Tha da nhiet tinh giang day chung em trong suot thai gian qua.
•Co Dang Thi Nhung, da true tifip huang din va tan tinh giup da em hoan thanh dl
tai.

•Tap the cac ban lap DH3TH2 da ho trg tai lieu va chia se kinh nghiem trong qua
trinh toi thuc Men dl tai.

Sinh vien: Ho Thj Anh Thu


Luan van tdt nghty p

L&INOIDAU
*****
Ngay nay tin hoc da trd nen vo cung pho bien va khong the thieu trong cuoc song cua
chung ta. Moi co quan, doanh nghiep muon hoat dong tot can phai co sir tra giup cua tin hoc. Cac
doanh nghiep thanh cong tren con duang kinh doanh da nhan ra vai tro cua he thong quan ty
thong tin r^ng: "He thong thong tin la mot he th6ng trung gian quan trong hS tra thong tin toi da
gitJa cac he thong khac Iai voi ^hau". Vjec quan ly cac nghiep vu b^ng tin hoc da khong con xa la
nila ma no dan dan trcr nen pho bien. Hau het cac cong so, cong ty, xi nghiep da dan dan sir dung
tin hoc vao viec quan ly san xu^t, kinh doanh, nhan sir... nh^m tan dung nhung thS manh cua cac
he thong thong tin quan ty de phuc vu cho cong viec chinh xac hon, hien qua va kinh te hon..Va
lo^ii san pham tin hqc da dong gop vao sir huu dung cua nganh tin hpc noi chung do la cac phan
mem quAn ty. Voi cac phSn mem quan ty, viec quan ty trong mi t6 chirc se chinh xac hon va
cting khong ton nhieu nhan lire.
Vai sir giup da cua cac thay co trong Trung tarn Tin hoc va khoa KT thuat - Cong nghe Moi tnrang, tnrang Dai hoc An Giang em da co ca hoi tim hieu va xay dung he thong quan ty thi
- cap chung chi mang dao tao ciia Trung tarn Tin hoc. Mac dii, cac thly co da tan tinh giup da
nhung do han che ve m|t thai gian va thieu kinh nghiem trong viec xay dung ^han mem nen
chucmg trinh van con nhieu thieu sot kinh mong thay co quan tam dong gop de chuang trinh

duac hoan chinh han.


Luan van tot nghiep

TOM TAT
Ten de tai: Xay dung phan mem quan ly thi cap chiing chi - mang dao tao Trung tarn Tin
hoc -^ truong dai hoc An Giang.
Giang vien hit dug dim: KS. Dang Thi Nhung

Sinh vien time Men: H6 Thj Anh Thir
Npi dung: Tim hieu cong tac quan ly thi va cap chung chi tin hoc quoc gia ciia Trung tarn
Tin hoc, truong Dai hoc An Giang. Phan tich va thi^t k^ he thdng d^ xay dung thanh mot phln
mem quan ly. He thong se h tr^ cac chuc nang can thiet ma mot he thong thong tin quan ly phai
co nhu: nhap lieu, xu ly tinh toan, lap bao cao thong ke,... Cu the:

*Tiep nhan thi sinh du thi
*Xep phong thi va so bao danh

*Cap nhat dilm thi
*Lap the du thi, chung chi...
Yeu edit:
*Tim hieu he thong va xac dinh cac yeu cau
*Tim hieu cac van de ly thuyet co lien quan

*Phan tich thiSt kg he thdng
*Cai dat chucmg trinh demo
Mbi truinig time Men:
*Ngon ngu lap trinh: Visual C#.NET
*He quan tri co so da lieu: Microsoft SQL Server 2000



Luan van tot nghiep

MUC LUC
PHAN 1

Gldl THIEU1

1.Mo tapham vi he thong1
2.Mo ta phtrong an tong quan va danh gia kha thi2

PHAN 2TONG QUAN6
7. Cai dat:6

2. Phan tich thi^t kk8
PHAN 3

PHAN TICH - THIET KE HE THONG11

I.Phan tfch ling dung:11
/. Phan tich hien trang:11
2.Phan tich yeu cau:12
3.Phan tich du lieu22
II.Thiet ke ihig dung24

7. Thi^tkSdirlieu24
2.Mo ta cac rang buoc toan ven28

3.Thik ki xir ly31

4.Thi^t ke giao dien43

PHAN 4

CHUONG TRINH DEMO44

I.Cai dat CSDL trong SQL Server44
II.Cai dat cac man hinh giao dien45
/. Man hinh chinh cua chucmg trinh45

2.Man hinh tigp nhan TS du thi46
3.Man hinh s5p SBD, phong thi va bu6i thi47
4.Man hinh nhap kk qua thi48
5.Man hinh tra cuu TS.....49

6.Man hinh th6ng ke theo khoa thi50
7.Man hinh in danh sach phong thi50

phAn 5

uNg dung vA HtfdNG phAt triensi

I. Danh gia chung'.51
/. Ket qua dat ducrc51
2. Hanch^51

ILHir^ngphattriin51

PHAN 6


PHU LUC52

PHAN 7

TAl LIEU THAM KHAO53


Luan van t6t nghiep

DANH SACH CAC HINH VE. BANG BIEU


Danh sach cdc hinh ve:

HinhO-I So dl tuang tac thong tin13
Hinh 0-2 Mo hinh hoa xii ly:14

Hinh 0-3 Mo hinh clp 115
Hinh 0-4 Mo hinh dp 2 cho 6 xii ly racr khoa thi moi16

Hinh 0-5 Mo hinh dp 2 cho 6 xii ly mcr Tilp nhan TS17
Hinh 0-6 Mo hinh clp 2 cho 6 xir ly dang ky bao liru18
Hinh 0-7 Mo hinh dp 2 cho 6 xu ^^ xlp PT va SBD19
Hinh 0-8 Mo hinh clp 2 cho 6 xir ly lap the dy thi.19
Hinh 0-9 Mo hinh clp 2 cho 6 xir ly Xac djnh kit qua:20
Hinh 0-10 Mo hinh clp 2 cho 6 xii ly lap chiing chi20
Hinh 0-11 Mo hinh cap 2 cho 5 xir ly lap bao cao thong ke21

Hinh 0-12 Mo hinh thuc thi kit hop (ER)22
Hinh 0-13 Mo hinh CDM23

Hinh 0-14 So dl cay clu true chiic nang31

Hinh 0-15 So dl kiln true phln mint32
Hinh 0-16 So dl tuln tir cho khli xir ly dang nhap he thong33
Hinh 0-17 So do tuln ttr cho khli xir ly them KT moi34
Hinh 0-18 So do tuln ttr cho khli xir ly them TS moi35
Hinh 0-19 So dl tuln ttr cho khli xir ly xoa TS36
Hinh 0-20 So do tuln tu cho khli xii ly sira thong tin TS37
Hinh 0-21 So dl tuln tu cho khli xir ly Tra ciiu TS38
Hinh 0-22 So dl tuln tir cho khli xir ly dang ky bao luu39
Hinh 0-23 So dl tuln tir cho khli xir ly xlp PT va SBD40
Hinh 0-24 So dl tuln tu cho khli xir ly nhap kit qua thi41
Hinh 0-25 So dl tuln tir cho khli xir ly thing ke theo khoa thi42
Hinh 0-26 So dl lien kit cac man hinh giao dien43
Hinh 0-27 So do cai dat da lieu44
Hinh 0-28 Man hinh cht'nh45

Hinh 0-29 Man hinh tilp nhan TS46
Hinh 0-30 Man hinh sip PT va SBD47
Hinh 0-31 Man hinh nhap kit qua48
Hinh 0-32 Man hinh tra cuu TS49


Luan van tot nghi^p

Hinh 0-33 Man hinh thong ke theo khoa thi50

Hinh 0-34 M^n hinh in danh sach phong thi50
• Danh sach cac bang bieu:
Bang 0-1 Mo ta du lieu bang CHUNG_CHI24

Bang 0-2 Mo ta da lieu bang THISINH.'25
Bang 0-3 Mo ta du lieu bang QUA_TRINH_THI25
Bang 0-4 Mo ta dtt lieu bang KHOATHI..;26
Bang 0-5 Mo ta du lieu bang THONG_KE_THEO_KHOA26

Bang 0-6 Mo ta da lieu bang QUIJ3INH26
Bang 0-7 Mo ta da lieu bang CHUNG_CHI_DA_CAP26

Bang 0-8 Mo ta du lieu bang PHONG27
Bang 0-9 Mo ta da lieu bang DICH_VU27

Bang 0-10 M6 ta da lieu bang BANG_HONG27
Bang 0-11 M6 ta da lieu bang NGUOI_DUNG27
Bang 0-12 Mo ta da lieu bang THONG_TIN_CHUNG_CHI28


Luan van t6t nghiep

CACTI/VIET TAT
•QTCSDL: Quan tri ca so du lieu
•CSDL: Ca scr dCr lieu
•SBD: So bao danh

•CBQLHT:Canbqquanlyheth6ng
•CBQL: Can bo quan ly
•KT: Khoa thi
•TS: Thi sinh
•PT: Phong thi
•DV: Dich vu


•ER: Entity Relationship (Mo hinh thuc thS kk hop)
•DFD: Data Flow Diagram (Mo hinh dong dir lieu)
•CDM: Conceptual Data Model (Mo hinh quan niem du lieu)
•DH: Dai hoc


Phan 1 - Gi6i thi^u

PHAN1

GICflTHIEU

I.TOCHLfC
•Trung tarn Tin hoc - trucrng DH An Giang duoc thanh lap vao thang 8/2000.
•Co du: Men tai trung tarn co 1 giam d6c, 2 pho giam doc va 11 thanh vien.

n.CAC HOAT BONG
•Qua hon 5 nam thanh lap, moi hoat dong cua trung tarn ngay cang co hf thong, co nhieu
dong gop huu ich cho cong tac dao tao cua truong DH An Giang va cho dia phuong noi
chung. Vai he thong may tinh tuong doi day du, phuong phap giang day tot, trung tarn da
gop phan nang cao trinh do tin hoc cho cac ban sinh vien cung nhu cho nhan dan An
Giang.
•Hoat dong cua trung tam nham phuc vu 3 chiic nang chinh:
?Quan ly he th6ng ducmg truy^t trong mang npi bo, cac phong may tinh va he
thong tong dai noi bo.
?Tin hoc hoa trong nha truong va dia phuong
?Thuc hien cac dich vu dao tao tin hoc - dp chung chi tin hoc qu6c gia A, B.

1. Mo ta pham vi he thdng


Trung tam tin hoc

Ngu'M lap: Ho Thi Anh Thu

Truong Dai Hoc An Giang

Ngay: 28/04/2006
Ten du an

Xay dung pham mem quan ly thi - dp chung chi mang dao tao Trung tam Tin hoc

Quan ly du an: H6 Thi Anh Thu
Phat bieu van dc
Trung tam tin hoc — truong DH An Giang hien dang dao tao 2 loai chung chi:
Chung chi A va chring chi B. M6i nam, t6 chuc khoang 20 khoa thi, vi thS s6 Iuong
thong tin ve TS dn luu tru tuong d6i nhiSu. Cac thao tac quan ly thi van c^n thu cong
chua ducrc tin hoc hoa, do do cong tac quan ly con phvrc tap va kho khan. De quan ly tot
viec thi chimg chi c^n co su tro giup ciia may tinh, vi vay viec xay dung mot ph^n m^m

quan ly la mpt vin dg dn thiSt.

Trang 1


Phin 1 - Gioi thi^u

Muc tieu
? Cho phep can bo quan ly he thing them, xoa, siia, tra cuu khoa thi, TS du thi,
phong thi...


? Cho phep xlp phong thi, s6 bao danh va gio thi ciia TS, xac djnh kit qua TS
dau hay rot, xep loai mot each nhanh chong, chinh xac va hieu qua.
? Cho phep lap cac danh sach thi sinh, the du thi, in chumg chi cho TS.
? Cho phep thong ke lai cac so lieu can thiet.
Mota
He th6ng moi se ghi nhan tit ca thong tin vl TS, khoa thi, ket qua thi, phong thi, chimg
chi, djchvudao tao....

Lai ich mang lai
Tao sir tien lai, nhanh chong cho can bo quan Iy cong tac thi.

• Cac can bo cua trung tarn co th^ tra cuu thong tin ve TS, khoa thi...
• Cong tac quan ly mang tinh chuyen nghiep cao (tu dong hoa)
Cac buoc de hoan tlianh du an

* Khao sat hien trang va phong van
Phan tich
• Thiet kg
• Lap trinh
Kiem tra
Bien soan tai lieu.

* Hu5n luyen sir dung.
2. Mo tii phuong an tong quan va danh gia kha thi
Sau qua trinh khao sat, chung toi thay rang quy mo cua du an cung khong ion lam,
thbi gian thuc hien du an ngdn, co so du lieu khong ion ISm nen he thing co thg dupe xay
dung bang ngon ngu C# va sir dung co so du lieu MS SQL Server 2000.
Chuong trinh se huong den tinh tien dung, giao dien gan gui, de sir dung.

Trang 2



Phan 1 - Gioi thi^u

2.1.Mo ta phirong an tong quan:
2.1.1.Yen cauve phan cieng:

Mot may PC vdi cdu hinh :
•T6i thi^u:
>CPU Pentiumlll 600MHz,
>RAM 128MB,
>DTa ciing: 10GB
•T6t nhat nen:
>CPU Pentium IV2.0GHz,

>RAM 512,
>DTa cung : 20GB tro Ien
2.1.2.Yen can v&phhn mem:
Database server: Microsoft SQL Server 2000
Phan mem quan ly Thi chiing chi Tin hoc.
2.1.3.Kinh phi die kien:
-Phan ciing:
Khong can vi Trung tarn Tin hoc da co mot so may tinh.
-Phan mem:

Microsoft SQL Server 2000: da dirac cai dat (theo khao sat thyc \S).
Microsoft Visual Studio.NET
2.2.Sanh gia tinh kha thi:
2.2.1.KM thi kinh te:
M^c dii khong thiy lqi ich y^ kinh te mot each ro rang, true tiSp nhung

ph^n m^m se tiet kiem rat nhieu cong siic cho nhieu ngudi.
2.2.2.Kha thi kythuat:
Bo l&n aid die an:
-So luqng thanh vien tham gia du an: I nguai.
-Kich thuac phan lap trinh: tuong doi nho.
Ca' trAc cua die an:
-He th6ng dugc xay dung hoan toan moi.

Trang 3


Phan 1 - Gioi thi$u

- Ve mat nhan sir: it co sir thay doi

Nhom phat trien:
Cac cong cu ma nhom phat trien sir dung trong qua trinh hoat dong cua du
an nay nhu sau:
He digu hanh: Windows XP.
Cong cu lap trinh: MS SQL Server, MS Visual Studio.NET (ngon ngu lap

trinh C#)
Cong cu ph^n tich, thi^t kg: Microsoft Visio 2003, PowerDesigner
Cong cu vidt bao cao: Microsoft Word 2003.

Nhom ngtrdi dung:
Ngudi dung la can bo Trung tarn tin hoc, co kign thuc vung vang ve
nghiep vu va su dung tin hoc thanh thao.

Bang tong hop d(i rui ro cua Unit klid tin ky tluicit:

Nguoi dahh gia:

Dirdn:

Ngay: 15/02/2006

Quan ly Thi cluing chl Tin hpc

STT

1

Ruiro
Sir quen thuoc cua
ngucri dung vdi viec sir
dung cc he thdng

. HOThjAnhThu

Th^p

Sir thay d6i t6 chtic, co
cau

Mo ta khic phuc

Tit ca cac can bo d8u sur

Lap kS hoach dao
tao sir dung song


dung may vi tinh thanh
thao, da timg sir dung cac
he thdng tuong tu

tuong tu

2

Mo ta d^nh gia

Danh gia

Rat thap

song vdi thdi gian
diln ra du an

Khong c6 anh hudng
Cac nhan vien dCu mu6n

3

4

Sir nhan thuc va thien
chi cita ngucri diing
tham gia vao he thong

Sir quen thuoc cua

nhom phat trien trong

Rat thap

co mot he thOng fro giiip
ho trong qua trinh lam
viec.

Ba timg lam viec tren cac

Thap

lmh vuc de xuat

du an tuong ty nhung voi
quy mo nho

Nghien ciru cac tai

lieu lien quan khi
phat trign he thdng
ldn

He thong khong ion lam

5

Kich thuoc cua he

Trung


thong

Binh

nhung vdi quy thdi gian
phat triCn tuong doi ngan
nen co the se gap kho
khan.

Co gang sap xep
thdi gian.

Trang 4


Phiin 1 - Gidithifu

2.2.3. Kha tin Iwat (long:
Dyan:

'



Nguoi danh gia:

. ;:: H^Thi:AnhThu ;

Quan ly Thi chtog chi tin hpc


STT

Ruiro

Ngiroi

1

dung

Danh gia

Th^p

thong nay

2

Tac dong cua he thdng
moi ve cau true va thu
tuc cua don vj

..

Ngay:
^

Mo ta danh gia


15/02/2006
Mo ta kliSc
phuc

Cac nhan vien dSu mu6n co

khong

thich tiep nhan he



mot he thdng co nhung chiic
nang tro giup ho trong lam
viec.

Thanh phSn nhan sir khong
thay d6i.

Th^p
Tiet kiem nhieu cong sire cho
mpi thanh vien cua ca quan.

Trang5


Phan 2 — Tong quan

PHAN 2


TONG QUAN

Ten de tai: Chirang trinh quan ly thi — cap chiing chi mang dao tao cua Trung tam tin
hoc, truong dai hoc An Giang
I. Moi truont! sir dung
B tai duqc xay dung va phat trien tren moi truong Visual Studio.NET (ngon ngit lap
trinh: Visual C#.NET) va he quan tri co so da lieu Microsoft SQL Server 2000.
II. Co so Iv thuvet

1. Caidat:
1.1.Visual C#.NET
•C# la mot ngon nga don gian, trong sang va chi gom khoang 80 tu ch6t

(keyword), diin dat rat t6t khi di vao viec thiet dat nhttng khai niem lap
trinh tien tien. C# la mot ngon ngtt lap trinh thien doi tuqng nen no ho
trq viec dinh nghla cung nhu lam viec vdi cac lop. Lop. dinh nghia

nhttng kieu dtt lieu mod cho phep ndi rang ngon ngtt de mo hinh hoa
van de dang ban tam giai quyet.
•C# cung ho trq giao dien, mot kieu qui uoc voi mot lop lien quan den
nhttng dich vu ma giao dien de ra. Tren C#, mot lop chi co the ke thtta
tu mot lop khac nhung co the thik dat vo s6 giao dien.
" C# cung cung cap ho trq doi voi struct, mot khai niem ma y nghia da
thay doi kha nhieu tu C++.
•C# chiu hS trq nhttng chuc nang thien ve cau kien chttng han thuqc
tinh, tinh huong va cau true khai bao (declarative construct) duqc gqi la
attributes.
•C# la ket qua cua viec ket hop hieu nang cao cua Visual Basic va sue
manh cua C++. Tom lai C# la mot ngon ngtt lap trinh hien dai va la
mot moi truong phat trien day tiem nang de tao ra cac dich vu Web

XML, cac ung dung dua tren Microsoft .NET va cho ca nn tang
Microsoft Windows cung nhu tao ra cac ling dung Internet the he ke
tiep mot each nhanh chong va hieu qua.
1.2.SQL Server (Structured Query Language)
•La ngon ngtt truy van do IBM phat trien vao thap nien 70, duqc ANSI
cong nhan va phat trign thanh mot chu^n quoc te (86). '

•SQL duqc cai dat trong hint h6t cac he QTCSDL, cho phep:
•Truy v&t CSDL
•Cap nhat CSDL
•Tao, huy, sua cac doi tuqng CSDL nhu: table, indexes, views,...
•Kiem soat viec truy xu^t CSDL va cac d6i tuqng CSDL.

Trang 6


Phan 2 - T6ng quan



SQL Server la he quan tri ca sa dft lieu theo mo hinh client-server.

1.3.Mot so doi tuwng trong SQL Server
•Databases: la mot vat chua nhieu kieu d6i tuong khac nhau (table,
views, store procedures, triggers, data types, ...).

•Tables: bao gom cac cot chua tat ca du lieu, moi hang trong table
chua thong tin cua mot doi tuong nao do.
•Views: tuang tu nhu mot table nhung no chi hien thi nhung cot thong
tin din thibt, chung ta co the thao tac dft lieu tren Views (table ao).

•Store Procedures: la mot chuong trinh con trong do co cac cau lenh
SQL, chung co the nhan tham so dau vao va cho ra ket qua
•Triggers: tuong tu nhu Store Procedures nhung no se tu thuc hien khi
mot record trong table co sir thay doi.
1.4.Ngon ngft truy van du- lieu - thao tac - mo ta - quan ly
•Ngon ngic truy van die lieu: Ngon ngir truy van du lieu, hay ngon ngft
hoi dap co cau true (Structured Query Language — SQL) chd phep

nhung ngucri khai thac CSDL (chuyen hoac khong chuyen) sir dung
d^ truy vdn cac thong tin c^n thik trong CSDL
•Ngon ngic thao tac die lieu: Ngon ngtt thao tac dtt lieu (Data
Manipulation Language - DML) cho phep ngubi su dung co the them

(Insert), xoa (Delete), sua (Update) dtt lieu trong CSDL.
•Ngon ngic mo ta die lieu: Ngon ngtt mo ta dtt lieu (Data Definition
Language - DDL) cho phep khai bao cau true cac bang cua CSDL,

khai bao cac moi lien he cua dtt lieu (Data Relationship) va cac quy
t^e (Rules, Constraint) quan ly ap dat len cac dft lieu do.
•Ngon ngic quan ly table va data: Ngon ngtt quan ly dtt lieu (Data

Control Language - DCL) cho phep nhttng ngubi quan tri he thong
thay doi cau true cua cac bang dtt lieu, khai bao bao mat thong tin va
cap quyen han khai thac ca sa dft lieu cho ngubi su dung.
1.5.Import/Export du lieu
SQL Server cung cap cho chung ta cong cu Import du lieu ttt ben ngoai
vai nhieu dang dtt lieu khac nhau (Oracle, Fox, Text, Access, SQL, ...), cong cu
Export dft lieu ra ngoai ybi nhieu dang khac nhau (Oracle, Fox, Text, Access,
SQL, ...). Cong cu hieu qua cho cong viec nay la Enterprise Manager (dung
Wizard). Cong cu nay giup chung ta Import/Export dtt lieu nhanh chong de

chiing ta co the dung dft lieu nay phuc vu cho muc dich khac.

Trang 7


Phin 2 - T6ng quan

2. Phan tich thiet ke
Cac mo hinh su dung trong giai doan phan tich, thiet ke:
2.1. Mo hinh dong du lieu (Data Flow Diagram - DFD)
Cac khai niem chinh:

Khai niem

K^hifu

Ynghia >]

:

'''^ ' '\

"':•

'V;.

"•

/<Sd thu tu>\
Oxuly


<Ten xu ly>

Dong dir lieu

Kho da lieu

Dau cuoi

Mot hoat dong ben trong he thong

Sir chuyen doi thong tin giaa cac thanh phan

Vung chua da lieu, thong tin trong he thong

<Ten kho da lieu>

<Ten d^u cu6i>

Mot tac nhan ben ngoai he thong

Mo hinh dong da lieu bieu dien ca xu ly Ian da lieu he thong, nhung chu y den xu ly
hen da lieu.

Trang 8


Phan 2 - Tong quan

2.2. Mo hinh thuc th kct hop (Entity Relationship Diagram- ERD)

Cac khai niem chinh:
,

Khsii

; '

Kyhifu

^nghia

;'

niem

Thuc thS

Bieu diln lop doi tugng the gioi thuc vdi cac tinh chat dac
<Tn thuc the>

Kit hop

trung cua chiing

Bieu dien su ket hop cua hai hay nhieu thuc the
y^
X^kgt hop>/

Thuoc


• Bieu dien cac dac trung cua thuc the hay moi ket hop

tinh ' .

• Ngoai cac khai niem chinh da neu, con co cac khai niem: thuoc tinh ket hop, phan cap,
tong quat hoa, djnh danh,...
2.3.Ngon ngu mo hinh hop nhat (Unified Modeling Language -

UML)
UML la mot ngon ngu: giup cho nguoi phan tich thiet ke (dac biet la
nguoi phan tich thiet ke cac he thong huong doi tupng) true quan hoa, dac
ta, xay dung va lam suu lieu cho cac thanh phan cua mot he thong phan
mem.

Trong UML co 9 loai luoc d6 chuln va co the chia lam 2 nhom:
-Cac loai luoc d6 tinh: use case diagram, class diagram (lop), object
diagram (doi tuong), component diagram (thanh phan), deployment

diagram (trienkhai)
-Cac loai lucre d6 dong: sequence diagram (tuan tu), collaboration

diagram (hop tac), statechart diagram (trang thai), activity diagram
(hoat dong)
2.4.Luoc do tuan tu (sequence diagram)
Lucre do tuan tu ghi nhan cac hanh vi huong thoi gian. Muc tieu cua
loai luoc d6 nay la mo hinh hoa luong xii ly va minh hoa cac kich ban dac
trung.

Trang 9



Phan2-Tongquan

Cac ky hieu:
Y nghta

Ky hicu

Khainiem .

Mot Actor la mot ngudi

Actor (Tacnhan)

su dung ' hoac mot he
thong khac tuong tac vai
he thdng dang xet. Cac
Actor luon la cac thuc the
ben ngoai he thong.

Mot lop bi^u diln cho sir

Class (Lap)
: Database

mo ta trim tuang mot tap
cac doi tuang co cung

tinh chdt. Lap co thS

duac xem la mot kieu dit
lieu.

13:lcmdDongY CliJk()

Message (thong diep)

II

'I '

Ghi chu thong rfiep:
[•

Chu thich

Kyhieu

rfrmTHISINH

XL THISINH

inh I
lltLayDanhSachlhiSinh

Thong diep gai tu fimTHISINH
den XL_THISINH (man hinh
fimTHISINHgoilap
XLTHISINH thuc hien ham
LayDanhSachThiSinh ())


Mot doi tuang gdi thong diep den
3: Ki riTraThongTin()

chinh no (goi mot trong cac thao
tac cua no)

Trang 10


Phin 3 - Phan tlch Thiet ki he thdng

PHAN 3 PHAN TICH - THIET KE HE THONG
/. PHAN TICH UNG DUNG:
1. Phan tich hien trang:
1.1.Hien trang trung tarn tin hoc:
Trung tam tin hoc - trirong DH An Giang hien dang dao tao 2 loai chung

chi: Chiing chi A ya chiing chi B. Moi nam, to chiic khoang 20 khoa thi, vi the so
lupng thong tin ve TS can Itru trtr tuong doi nhieu. Cac thao tac quan ly thi vin
c6n thu cong chua dtrqc tin hoc hoa, do do cong tac quan ly con phirc tap va kho
khan. Be quan ly tot viec thi chiing chi can co sir trp giiip cua may tinh, vi vay
viec xay dung mot phan mem quan ly la mot van de can thiet.
1.2.Hien trang bai toan:
Qui trinh nghiep vu:
1.2.1.M& khoa thi m&i:
Khi trung tam quyet dinh me mot khoa thi mdi, can bo quan ly he
thong co nhiem nhap va luu thong tin cua mot khoa thi (Ngay thi, ngay bat
d^u dang ky, ng^y ket thiic dang ky...).
1.2.2.TiSp nhan thisinh die thi:


Khi TS nop h6 so dtr thi, CBQLHT co nhiem vu k^m tra thi sinh da
ttrng du thi hay chua? N^u co thi chi cap nhat thong tin du thi cho thi sinh,
ngugc lai thi nhap va luu lai thong tin ca nhan cua TS (hnoi sinh, chiing chi du thi .. .).TS co the du thi tu do hoac theo tung dich vu
dao tao ben ngbai.
1.2.3.Sap so bdo danh, phong thi va buoi thi cho thisinh:

Sau khi ht ngay dang ky du thi, CBQLHT se ti^n hanh lap SBD,
phong thi, va bufli thi cho TS. D^u tien, CBQL se chpn thii tu phong thi c^n
sap (uu tien sap cho nhung TS thi chiing chi B truce vi thong thuong so

lupng TS thi B it horn so lupng TS thi A). Sau do, CBQL se cap nhat lai s6
may c^a tung phong (so may nay do can bo quan ly phong may cung dtp).
TiSp theo he thSng se thuc hien sap xep.
1.2.4.Cap the dip thi:

Sau khi da s5p SBD, phong thi, va bu6i thi cho TS he thbng se cSp the
d^ thi cho TS. Khi co the, nlu TS thiy khong du thi dupe vao bu6i thi da
s^p, TS co the yeu cau d6i bu6i thi khac vcri dihu kien bu6i thi ma TS yeu
chx co to chiic trong khoa thi do.
1.2.5.Nhap ket qua thi:

Khi can bo cham thi gui bang diem den, CBQLHT se nhap ket qua bai
thi cua TS (so may, so byte, diem cac mon . ..). Khi co day du thong tin ve

Trang11


Ph^^n 3 - Phan tich Thiet ke he thong

bai thi, he thong se xac dinh ket qua TS dau hay rot, neu dau se tien hanh

xep lo^i cho TS
1.2.6.Thong ke:
Cu6i mi khoa,he thdng se ti6n hanh thong ke Iai so TS du thi, v5ng,
dau, rot. D6ng thai, cho ra danh sach kit qua cua TS de trinh ban giam hieu
ky duyet. Ngoai ra h^ thong con cho ph^p thong ke theo ttrng dich vu (de
gui bang diem cho dich vu do) va theo ttrng phong thi.
1.2.7.Cap chung chi:
He thong se tien hanh cap chung chi cho nhung TS dau theo mau
chung chi cua bo qui dinh. Trong qua trinh in chiing chi, CBQL se luu Iai

thong tin cua nhung chung chi in bi hong (Ma bang, ma khoa)
1.2.8.Bang ky thi Iai:

Trung tam cho phep nhung TS thi rat duqc bao luu diem (chi bao luu
nhung mon co diem Ian ham hoac bang diem bao luu qui dinh cua trung
tam) va duqc thi Iai trong hai khoa lien tiep.

2. Phan tich yiu ciiu:
2.1. Cac yeu cau chiic nang:
>Quan ly thong tin ve cac chung chi ma trung tam dao tao

>Quan ly thong tin TSdu thi
>Quan ly qua trinh thi
>Quan ly thong tin phong thi
^Quan ly thong tin ve timg khoa thi
>Quan ly thong tin v^ cac dich vu dao tao ben ngoai trung tam

>Quan ly thong tin ve cac chiing chi in bj hong

>H trq lap danh sach thi sinh cua timg phong thi
^Ho trq gan so bao danh cho tirng thi sinh

>H6 trq xac dinh ket qua cua timg thi sinh
>Ho trq in the du thi, chung chi cho thi sinh
^ Ho trq lap danh sach cac thi sinh duqc cap chiing chi cimg vai ma so
chiing chi de trinh ban giam hieu ky.

>Ho trq thbng ke s6 TS dyr thi, v^ng, dau, rot theo timg khoa thi, ttmg
dich vu, timg phong thi.

Trang 12


Phto 3 - Phan tlch Thi^ k& h$ thong

2.2.Cac yeu cau phi chile nang:
>Giao dien than thien de su dung
>Co che do bao mat

>Tro giup sir dung
>Cho phep truy cap dtr lieu da ngu^i dung.
>Backup dG lieu.

2.3.Mo hinh quan niem xii ly he thong
2.3.1. Sff dd tuffiig tdc thong tin:
Nguoi true tiep su dung he thong: can bo quan ly viec thi cua trung tam
(tiep nhan thi sinh moi, ghi nhan ket qua....)

^...if"I

l"BVCI1 I
''

Thon tin v
bit thi,-8"

xii ly cu a h| thong

.. can BO

QUAN LY THI CHLTNG
CHI

QUAN LY THI

s^ch thi sinh dy
thi, ph6ng thi,
the dy thi

— ~^ ^~~

n ^^ ^_ I

chtrng chi

Hinh 4-1 So- do tuong tac thong tin

Trang 13



Ph^n 3 - Phan tich Thiet ki he th6ng

2.3.2. Sof dS biiu diln hogt ^ong cua he thdng
Mo hinh (long dfr lieu (DFD - Data Flow Diagram) cac cap


So do he thong con

I

HI DA CAP

CHUNG CHI DA CAP

Hinh 4-2 Mo hinh hoa xfr ly

Trang 14


Ph^n 3 - Phan t(ch Thih ke hS th6ng

Mo hinh cap 1:

et qua
yeu cau kiem tra\

Can bo
Quan ]y
He thong


Hinh 4-3 Mo hinh cap 1

Trang 15


Phan 3 - Phan tich ThiSt ki he thfing

Mo hlnh cap 2 cho o xii ly mo' khoa thi moi:

Can bo
Quan iy
He thong

Hlnh 4-4 Mo hinh cap 2 cho 3 xu- ly mir khoa thi moi

Trang 16


PhAn 3 - Phan tich Thi^^ k h$ th6ng

Mo liinli cap 2 cho 6 xu- ly Tiep nhan tin' sinh:

i sin

ua thi Ian nao(hi sinh da co du thi

thong tip thi sinhchung chi & dich vu & khoa
Chung chi & dich vu & khoa & ma thi sinh

QUA TRINH THI


Hinh 4-5 Mo hinh cap 2 cho 6 xu- ly mo Tiep nhan TS

TRU^^NG D^I HQC
ANGIANG

THUVIEN

Trang 17


×