bao cao bai tap lon ktpm nhom gd2k
TRANSCRIPT
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
1/50
Bo co K thut phn mm NhmGD2K
MC LCLI NI UI. TM HIU YU CU
1.1 Phng php nghin cu ti liu, bn mu.
1.2 c t yu cu.1.2.1 c t yu cu thc t.1.2.2 c t chc nng phn mm.1.2.3 c t yu cu phi chc nng.
II. PHN TCH H THNG.2.1 S phn cp chc nng FD.2.2 Biu lung d liu DFD.
.2.1 DFD mc ng cnh.
.2.2 DFD mc nh.
.2.3 DFD mc di nh.
III. THIT K H THNG3.1 Thit k c s d liu
3.1.1 Phn tch yu cu.3.1.2 Nhn din thc th.3.1.3. S thc th lin kt3.1.4 Nhn din kha chnh.
3.1.5 Cc gi thit ph thuc hm.3.1.6 Chun ha c s d liu.3.1.7 S thc th lin kt (ERD)3.1.8 Khai bo phm vi cc thuc tnh.3.1.9 Cc quy tc m bo ton vn d liu.
3.2 Lu thut ton mt s chc nng c bn.
IV TRIN KHAI4.1 Mi trng pht trin, cng c xy dng CSDL v ngn ng
lp trnh.4.2 Phn cng cng vic.
V TI LIU NGI DNG5.1 Hng dn ci t.5.2 Hng dn s dng.
VI. KT LUN V KIN NGH CHO MN HC
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
2/50
Bo co K thut phn mm NhmGD2K
LI NI U
Trong nhng nm gn y ngnh cng ngh thng tin ni chung v kthut phn mm ni ring c nhng bc pht trin mnh m. Cc phnmm ngy cng c ng dng rng ri trong mi lnh vc ca cuc sng mtrong cc phn mm qun l c bit chng t c tnh u vit v tinch ca mnh.
S ra i ca cc phn mm qun l gp phn quan trng gii quytvn qun l nhn lc m mt v d c th l qun l sinh vin cc trng ihc. Vi cc trng i hc ln nh i hc Bch Khoa H Ni vic qun lthng tin, x l hc tp vi hng chc ngn sinh vin thc s s mt rt nhiuthi gian v cng sc nu thiu i nhng phn mm qun l. Nhng vi nhng
phn mm qun l hin nay cc cn b o to ch cn vi thao tc n gin lc th tm c nhng thng tin mong mun trong khong thi gian rt ngnv rt chnh xc.
Vi nhng l do nhm sinh vin GD2K chn mng ti Qun lsinh vin cho bi tp ln mn K thut phn mm vi mong mun vi nhngkin thc v kinh nghim c c sau khi hon thnh bi tp ln ny chng ems c th p dng c vo cc cng vic ca mnh sau ny c bit lin quann vn qun l.
Trong phm vi bi tp ln ny chng em s xy dng phn mm qun lsinh vin vi nhng chc nng c bn l qun l thng tin sinh vin, x l kt
qu hc tp v cc bo co s dng hai cng c ch yu l Microsoft VisualBasic 6.0 v Microsoft Access 2003.n v p dng: khoa in T-Vin Thng, trng i hc Bch Khoa
H Ni.a ch: tng 4 nh C9, trng i hc Bch Khoa HN, s1 i C
Vit.S in thoi: 04 8692242Email: http://fet.hut.edu.vnPhng php pht trin: do y ch l mt d n nh, yu cu trong
phm vi bi tp ln c thc hin trong mt k hc vi nhng kin thc c
cung cp sau mi tun hc chng em xin la chn phng php pht trin theom hnh tuyn tnh.
Phn tch Thit k Lp trnh Kim th
http://fet.hut.edu.vn/http://fet.hut.edu.vn/ -
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
3/50
Bo co K thut phn mm NhmGD2K
I. TM HIU YU CUTrong qu trnh thc hin xy dng phn mm khu u tin l tm hiu
nghin cu yu cu ca ngi s dng. Nhm GD2K chng em la chn
phng php tm hiu yu cu ca ngi s dng l nghin cu ti liu c sntrn c s chnh nhng ti liu hc tp ca cc thnh vin trong nhm.
1.1 Phng php nghin cu ti liu, bn mu.Phng php nghin cu cc bn mu c trc cho php tm hiu su
hn v nhng yu cu c th ca bi ton vi tng chc nng ca h thng.
Tn ti liu: Danh sch sinh vinBn mu:
DANH SCH SINH VIN
LP IN T 3 K50
STT SHSV H v tn Ngy sinh a Ch Ghi ch01 20050062 Ng Nht Anh02 20050137 Ch Xun Bch03 20050250 Hol ChanTha04 20050323 Phm Cng Chng05 20050548 ng Quc Dng06 20050570 Nguyn Anh Dng(BT)
07 20050717 Bi Nguyn t08 20050872 Nguyn Cng c09 20050960 Phm Trng Giang10 20040968 Sn Hi11 20051072 Nguyn Hong Hi12 20051085 Nguyn Thanh Hi13 20051128 Bi Thu Hng14 20051232 Nguyn Tr Tun Hip15 20051302 Duy Hon16 20051379 Ung Hong Tech
17 20041454 Nguyn nh Hng18 20051539 Nguyn Mnh Hng19 20041637 Nguyn Quc Khnh20 20051760 ThaLang KheMaRa21 20051837 V Ngc Kin22 20041721 Vn Lai23 20052223 Trng Cng Minh24 20052231 Cp Trng Nam
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
4/50
Bo co K thut phn mm NhmGD2K
Tn ti liu: Bng im thi hc kBn mu:
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
5/50
Bo co K thut phn mm NhmGD2K Tn ti liu: H s sinh vin
Bn mu
Tn ti liu: Danh sch nhn hc bngBn mu
DANH SCH NHN HC BNGKho: 50 Lp: in T 3 Hc k: 2 Nm hc: 2007-2008
SHSV H v tn Ngy sinh imTBL1
Mc hcbng
S tinc lnh
Ghich
20050570 Nguyn Anh Dng 01/11/1987 9,26 300.000 1.500.000 +0.320050960 Phm Trng Giang 04/02/1987 9,16 300.000 1.500.00020051128 Bi Thu Hng 20/05/1987 9,10 300.000 1.500.00020052223 Trng Cng Minh 24/8/1987 8,70 240.000 1.200.00020052751 V Th Phng 18/04/1987 8,24 240.000 1.200.00020051320 Duy Hon 21/06/1987 8,05 240.000 1.200.000
Ngoi ra cn c th tham kho thm cc thng tin trn trang web trng
i hc trng i hc Bch Khoa H Ni ti a ch http://hut.edu.vn v cakhoa in T Vin Thng ti a ch http://fet.hut.edu.vn .
http://hut.edu.vn/http://fet.hut.edu.vn/http://hut.edu.vn/http://fet.hut.edu.vn/ -
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
6/50
Bo co K thut phn mm NhmGD2K
1.2 c t yu cu.1.2.1 c t yu cu thc t.Qu trnh hc tp ca mi sinh vin khoa in T-Vin Thng c
chia lm 2 giai on: giai on i cng (2 nm u) v giai on chuynnghnh (3 nm cui). mi giai on c nhng c th ring, v d nh phn ln cc mn i
cng l do cc khoa khc trong trng ph trch cn cc k chuyn ngnhhu ht l ging vin khoa in T-Vin Thng m nhn. Trong phng phptnh im tt nghim ang p dng im trung bnh cc k i cng vchuyn nghnh s c nhn h s khc nhau do vy trong phn mm qun lcn phi c cc chc nng qun l im ca cc k hc i cng, chuynnghnh ring, trnh s nhm ln trong khu tnh ton im tt nghip sau ny.
Mt c th na khoa in T-Vin Thng l sang k 9, tc l nm
cui sinh vin s c ng k chn cc chuyn ngnh hp l: in t VinThng, in T Tin hc, in T Y Sinh v in t Hng Khng.
Hin nay trng i hc Bch Khoa H Ni bt u p dng ch hc tn ch, khoa in T Vin thng nm nay c K52 p dng hnh thchc ny vi cc cch tnh im, qun l lp, x l hc tp theo quy ch mi.
Vi nhng c th i hi phn mm qun l sinh vin p dng chokhoa phi tng hp c tt c cc yu cu , a ra cc chc nng qun l cth, hiu qu, ph hp vi tng c im, giai on, vi tng kha hc khcnhau mang li kt qu chnh xc v hiu qu ti a.
Nh ni trn, trong phm vi bi tp ln v nhng kin thc cn hn
ch, nhm GD2K ch mi xy dng c mt phn mm qun l sinh vin vinhng chc nng c bn nht. Nhng chc nng qun l phc tp, nng cao sc nhm tip tc tm hiu v hon thin trong thi gian ti.
1.2.2 c t chc nng ca phn mm.
Mt h thng qun l sinh vin cho khoa in t - Vin thng cn cc
thng tin sau: S hiu sinh vin, H v tn sinh vin, Kho, Tn lp, M lp,
Ngy thng nm sinh, Gii tnh, Dn tc, Tn gio, Chng minh th nhn dn,
i tng, Qu qun, H khu thng tr, a ch lin h, H tn b, Nghnghip ca b, H tn m, Ngh nghip ca m, Nm tt nghip, Xp loi tt
nghip PTTH, Nm vo trng, S bo danh, im vo trng, Ngy vo
on, Ngy vo ng, Lp trc khi phn ngnh, Ngnh hc, Hc k i
cng, M mn i cng, Mn hc i cng, im i cng ln 1, im
i cng ln 2, im i cng ln cao nht, Hc k chuyn ngnh, M mn
chuyn ngnh, Mn hc chuyn ngnh, im chuyn ngnh ln 1, im
chuyn ngnh ln 2, im chuyn ngnh ln cao nht, S n v hc trnh.
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
7/50
Bo co K thut phn mm NhmGD2K
Yu cu :
Cc chc nng chnh: X l thng tin v sinh vin, x l kt qu
hc tp ca tng sinh vin v xut ra cc loi bo co
Qun l tt c cc thng tin ca tng sinh vin trong mi lp
thuc tng kho trong Khoa, khi cn c th tm kim bt k thng tin no
ca mt sinh vin v: thng tin bn thn, gia nh, lp, im cc mn hc
thuc tng k Cho php nhp mi, b sung thng tin ca mt sinh vin
bt k vo lp.
Qun l im, nhp vo im v c kh nng lc ra danh sch
sinh vin t hc bng, sinh vin thi li, hc li da vo cc iu kin cho
trc.
Xut ra cc loi bo co khi cn thit nh: Bng im, danh sch
lp, H s sinh vin, danh sch hc li, danh sch thi li
1.1.3 c t yu cu phi chc nng
Tiu ch 1 : Khng qu n gin nhng d s dng, cha y cc thng tin cn thit, trnh cc thao tc rm r, s d tha d liu v
phi phc v ti a cho mc ch qun l sinh vin.
Tiu ch 2 : Cc qu trnh x l m bo nhanh chng, tin li v
tht chnh xc. Cp nht y cc chc nng cn thit, cc thng tin
tng hp phc v cho cng vic qun l theo tng giai on c th.
Tiu ch 3 : p ng c ti a yu cu ca ngi s dng v c
kh nng nng cp khi pht sinh yu cu mi. Tiu ch 4 : Giao din p mt v thn thin vi ngi dng. C
hng dn ci t v hng dn s dng chi tit, c th, hng dn x
l khi xy ra mt s s c c th xy ra
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
8/50
Bo co K thut phn mm Nhm GD2K
II. PHN TCH H THNG
2.1 S phn cp chc nng FD
8
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
9/50
Bo co K thut phn mm Nhm GD2K
2.2 Biu lung d liu
2.2.1 DFD mc ng cnh
2.2.2 DFD mc nh
9
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
10/50
Bo co K thut phn mm Nhm GD2K
2.2.3 DFD mc di nh
2.2.3.1 DFD mc 2-mc di nh ca chc nng 1 (qun l
thng tin)
10
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
11/50
Bo co K thut phn mm Nhm GD2K
11
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
12/50
Bo co K thut phn mm Nhm GD2K 2.2.3.2 DFD mc 2-mc di nh ca chc nng 2 (X l hc
tp)
2.2.3.3 DFD mc 2-mc di nh ca chc nng 3 (Qun lbo co)
12
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
13/50
Bo co K thut phn mm Nhm GD2K 2.2.3.4 DFD mc 3-phn r ca chc nng 1.1 (Qun l thng tin
c nhn sinh vin)
2.2.3.5 DFD mc 3-phn r ca chc nng 1.2 (Qun l thngtin lp hc)
13
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
14/50
Bo co K thut phn mm Nhm GD2K
2.2.3.6 DFD mc 3-phn r ca chc nng 1.3 (Qun l thngtin mn hc)
2.2.3.7 DFD mc 3-phn r ca chc nng 1.4 (Qun l im)
14
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
15/50
Bo co K thut phn mm Nhm GD2K
III. THIT K H THNG 3.1 THIT K C S D LIU
3.1.1 Phn tch cc yu cu ( thc hin trong bc tm hiu yucu).
3.1.2 Nhn din cc thc thTn y Tn vit tt
*S hiu sinh vin SHSV
Kha KHOA
Tn lp TENLOP
M lp MALOP
H tn sinh vin TENSV
Ngy thng nm sinh NGAYSINH
Gii tnh GIOITINH
Dn tc DANTOC
Tn gio TONGIAO
Chng minh th nhn dn CMTND
i tng DOITUONG
Qu qun QUEQUAN
H khu thng tr HKTHUONGTRU
a ch lin h DCLIENHE
H tn b HTBO
Ngh nghip b NNBO
H tn m HTME
Ngh nghip m NNME
Nm tt nghip NAMTN
Xp loi tt nghip PTTH XLPTTH
Nm vo trng NAMVT
S bo danh SBDim vo trng IEMDH
Ngy vo on NVDOAN
Ngy vo ng NVDANG
Lp trc khi phn ngnh LOPTPN
Ngnh hc NGANHHOC
15
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
16/50
Bo co K thut phn mm Nhm GD2K
Hc k i cng HKDC
M mn i cng MAMONDC
Mn hc i cng MONDC
im i cng ln 1 DIEMDC1
im i cng ln 2 DIEMDC2
im i cng ln cao nht DIEMDCCN
Hc k chuyn ngnh HKCN
M mn chuyn ngnh MAMONCN
Mn hc chuyn ngnh MONCN
im chuyn ngnh ln 1 DIEMCN1
im chuyn ngnh ln 2 DIEMCN2
im chuyn ngnh ln cao nht DIEMCNCN
S n v hc trnh SODVHT
3.1.3 S thc th lin kt
16
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
17/50
Bo co K thut phn mm Nhm GD2K
17
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
18/50
Bo co K thut phn mm Nhm GD2K 3.1.4 Nhn din kha chnhKha chnh ca bng cha chun ha l SHSVdo cc thuc tnh cn
li u ph thuc hm vo thuc tnh ny.
3.1.5 Cc gi thit ph thuc hm
Gi thit 1:
Mt s hiu sinh vin xc nh duy nht thng tin v mt sinh vin
v ti mt thi im sinh vin hc duy nht ti mt lp thuc mt khoa nht
nh. V vy cc thng tin v sinh vin bao gm 17 thuc tnh cn li u
ph thuc hm vo thuc tnh SHSV.
m bo s hiu sinh vin l duy nht ta biu din s hiu sinh
vin nh sau: bn s u l nm vo trng v d 2005 v bn s sau l
th t ca sinh vin trong danh sch sinh vin cng nhp hc kha
(danh sch th t do phng o to i hc qun l) v d 0570
Vi cc sinh vin chuyn h t Cao ng ln i hc th bn s cui
c dng Cxxx trong xxx l s th t ca sinh vin v d C570
Nh vy ta s c s hiu sinh vin c th l: 20050570 hoc
2004C570.
Gi thit 2:
Trong hai nm hc i cng, mi mn hc ch hc duy nht trong
mt k, trng hp mn hc no hc trong nhiu k th ta thm ch s vo
sau tn mn hc phn bit. V d: Gii tch 1, Gii tch 2, Vt l 1Dovy thuc tnh HKDCph thuc hm vo MONDC.
Gi thit 3:
18
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
19/50
Bo co K thut phn mm Nhm GD2K Trong nhng nm hc chuyn ngnh, tng t nh i cng, mi
mn hc cng ch hc trong mt hc k. Ring k 9 i vi sinh vin h i
hc chnh quy, mi sinh vin c php ng k mn hc ph hp vi
chuyn ngnh ring. Do vy cp thuc tnh (SHSV, MONCN) s xc nhmt k hc chuyn ngnh duy nht. Nh vy thuc tnh HKCN ph thuc
hm y vo thuc tnh ghp ( SHSV, MONCN ).
Gi thit 4:
Mi mn hc c s n v hc trnh nht nh (k c i cng ln
chuyn ngnh) (c th trng nhau). V vy thuc tnh SODVHTi cng
ph thuc hm vo MONDCv SODVHT chuyn ngnh ph thuc hmvo MONCN.
Gi thit 5:
im thi ht hc phn ca mi sinh vin gm c: im ln 1, im
ln 2 v im ln cao nht (tnh t ln th 3 tr i), v vy im mi ln ph
thuc hm y vo thuc tnh ghp ( SHVH, MONDC) hoc (SHSV,
MONCN)
Gi thit 6:
Mi mt tn lp ch c mt m lp duy nht. Cch nh m lp nh
sau: T v s th t lp (t 1 n 12). V d: T5, T11Nh vy
TENLOPph thuc hm vo thuc tnh MALOP.
Gi thit7:
C i cng v chuyn ngnh th mi m mn hc cng u xc
nh mt mn hc duy nht nn thuc tnh MONDC ph thuc hm vo
thuc MAMONDCv MONCNph thuc hm vo MAMONCN.
19
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
20/50
Bo co K thut phn mm Nhm GD2K
3.1.6 Chun ha c s d liua. Ti sao phi chun ha c s d liu- M hnh quan h ch chp nhn duy nht cc quan h tha mn iu
kin mi gi tr trong quan h - ngha l tt c gi tr ca cc thuctnh trong tt c cc b u phi l nguyn t (ngha l khng chia nhc)
- Ni cch khc ti mi v tr ct nhau ca mt hng v mt ct trongbng tn ti ng mt gi tr v khng bao gi c l mt tp cc gitr
- p dng vo bi ton qun l sinh vin y ta thy:
- Theo cc gi thit ph thuc hm trn ta c mi SHSV xc nh duynht cc 17 thuc tnh cn li, tc l xc nh duy nht mt sinh vin.
- Tuy nhin mi sinh vin hc nhiu hc k, mi hc k li hc nhiumn, mi mn li c th c nhiu im (ln 1, 2) do vy khng mbo tnh nguyn t trong m hnh quan h.
- khc phc hin tng trn ta cn tin hnh chun ha c s d liutheo cc bc sau
3.1.6.1 Chun ha dng 1NF (tt c cc min u cha gi tr nguyn t)
Thuc tnh kho chnh ca bng cha chun ho l: SHSV
chuyn thnh 1NF ta s dng phng php tch nhm lp. Sau khi
tch cc thuc tnh lp ta thu c bng: IMC, IMCN,
THNGTINSV.
* S hiu sinh vin
* M mn i cng
Mn hc i cng
S n v hc trnh
Hc k i cng
im i cng ln 1
im i cng ln 2
im i cng ln cao nht
imC
20
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
21/50
Bo co K thut phn mm Nhm GD2K
* S hiu sinh vin* M mn chuyn ngnh
Mn hc chuyn ngnh
S n v hc trnh
Hc k chuyn ngnh
im chuyn ngnh ln1
im chuyn ngnh ln2
im chuyn ngnh ln cao nht
imCN
21
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
22/50
Bo co K thut phn mm Nhm GD2K
* S hiu sinh vin
Kha
M lp
Tn lpH tn sinh vin
Ngy thng nm sinh
Gii tnh
Dn tc
ThngtinSV
Tn gio
Chng minh nhn dn
i tng
Qu qun
H khu thng tr
a ch lin h
H v tn bNgh nghip b
H v tn m
Ngh nghip m
Nm tt nghip
Xp loi TN PTTH
Nm vo trng
S bo danh
im vo trng
Ngy vo on
Ngy vo ngLp trc phn ngnh
Ngnh hc
3.1.6.2 Chun ha dng 2NF (tch cc ph thuc hm vo tng tp conca kha chnh)
Trong bng IMC: Mn hc i cng, hc k i cng, S
n v hc trnh ph thuc hm vo M mn i cng thuc kha chnh
nn cha dng 2NF. Ta tch thnh bng: IMC, MNC.
Trong bng IMCN: Mn hc chuyn ngnh, hc k chuyn
ngnh, S n v hc trnh ph thuc hm vo M mn chuyn ngnh
22
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
23/50
Bo co K thut phn mm Nhm GD2K thuc kha chnh nn cha dng 2NF. Ta tch thnh bng: IMCN,
MNCN.
Trong bng THNGTINSV: kha chnh l SHSV kho n, cc
thuc tnh khng kho u ph thuc hm y vo kho chnh nn dng 2NF.
* S hiu sinh vin
* M mn i cng
im i cng ln 1
im i cng ln 2
im i cng ln cao nht
imC
* M mn i cng
Mn hc i cng
S n v hc trnh
Hc k i cng
MnC
* S hiu sinh vin
* M mn chuyn ngnh
im chuyn ngnh ln1
im chuyn ngnh ln2
im chuyn ngnh ln cao nht
imCN
* M mn chuyn ngnhMn hc chuyn ngnh
S n v hc trnh
Hc k chuyn ngnh
MnCN
23
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
24/50
Bo co K thut phn mm Nhm GD2K
* S hiu sinh vinKhaM lp
Tn lpH tn sinh vinNgy thng nm sinhGii tnhDn tc
ThngtinSV
Tn gio
Chng minh nhn dni tngQu qunH khu thng tr
a ch lin hH v tn bNgh nghip bH v tn mNgh nghip mNm tt nghipXp loi TN PTTHNm vo trngS bo danhim vo trngNgy vo onNgy vo ngLp trc phn ngnhNgnh hc
3.1.6.3 Chun ha dng 3NF
Trong bng IMC: mi thuc tnh khng kho l im i cng
ln1, im i cng ln 2, im i cng ln cao nht u ph thuc hm
trc tip vo kho chnh (SHSV, MAMONDC) nn dng 3NF.
24
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
25/50
Bo co K thut phn mm Nhm GD2K Trong bng MNC: kha chnh l kho n M mn i cng,
cc thuc tnh u ph thuc hm trc tip vo kho chnh nn dng
3NF.
Trong bng IMCN: mi thuc tnh khng kho l im chuyn
ngnh ln 1, im chuyn ngnh ln 2, im chuyn ngnh ln cao nht u
ph thuc hm trc tip vo kho chnh (SHSV, MAMONCN) nn
dng 3NF.
Trong bng MNCN: kha chnh l kho n M mn i chuyn
ngnh, cc thuc tnh khng kha u ph thuc hm trc tip vo kho
chnh nn dng 3NF.
Trong bng THNGTINSV: thuc tnh Tn lp ph thuc hm bc
cu vo kha chnh S hiu sinh vin thng qua thuc tnh khng kho l
M lp nn cha dng 3NF. Ta tch thnh bng: THNGTINSV v LP.
Ta c cc bng dng 3NF sau:
* S hiu sinh vin
* M mn i cng
im i cng ln 1
im i cng ln 2
im i cng ln cao nht
imC
* M mn i cng
Mn hc i cng
S n v hc trnh
Hc k i cng
MnC
25
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
26/50
Bo co K thut phn mm Nhm GD2K
* S hiu sinh vin
* M mn chuyn ngnh
im chuyn ngnh ln1
im chuyn ngnh ln2im chuyn ngnh ln cao nht
imCN
* M mn chuyn ngnh
Mn hc chuyn ngnh
S n v hc trnh
Hc k chuyn ngnh
MnCN
26
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
27/50
Bo co K thut phn mm Nhm GD2K
* S hiu sinh vin
Kha
M lp
H tn sinh vinNgy thng nm sinh
Gii tnh
Dn tc
ThngtinSV
Tn gio
Chng minh nhn dn
i tng
Qu qun
H khu thng tr
a ch lin hH v tn b
Ngh nghip b
H v tn m
Ngh nghip m
Nm tt nghip
Xp loi TN PTTH
Nm vo trng
S bo danh
im vo trng
Ngy vo onNgy vo ng
Lp trc phn ngnh
Ngnh hc
* M lp
Tn lp
Lp
3.1.6.4 Chun ha dng BCNF
27
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
28/50
Bo co K thut phn mm Nhm GD2K
Trong cc bng MNC, MNCN, THNGTINSV, LP: cc kho
chnh u l kho n nn cc bng ny dng BCNF.
Trong bng IMC: kho chnh (SHSV, MAMONDC) l thuctnh quyt nh v cc thuc tnh khng kho u ph thuc hm y vo
n, ng thi n cng l kho ng c nn dng BCNF.
Trong bng IMCN: kha chnh (SHSV, MAMONCN) l thuc
tnh quyt nh v cc thuc tnh khc u ph thuc hm y vo n
ng thi n cng l kho ng c nn dng BCNF.
Vy cc bng dng chun ha 3NF trn cng chnh l cc bng dng chun ho BCNF.
3.1.7 S lin kt thc th (ERD)
3.1.8 Khai bo phm vi ca mi thuc tnh
28
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
29/50
Bo co K thut phn mm Nhm GD2K Sau khi chun ho d liu, ta lp t in d liu cho cc thuc tnh:
Tn y ca
thuc tnh
Tn vit tt
ca thuc tnh
Kiu d
liu
Khong
gi tr
hp l
Gi tr muThuc bng
d liu
S hiu sinh
vinSHSV Nvarchar
810
k t20050570
THONGTINSV
DIEMDC
DIEMCN
Kha KHOA Integer 1100 50 THONGTINSV
Tn lp TENLOP Nvarchar810
k tin t 3
THONGTINSV
LOP
M lp MALOP Nvarchar45
K tT3
THONGTINSV
LOP
H tn sinh vin HOTENSV Nvarchar2050
k t
Nguyn Anh
DngTHONGTINSV
Ngy thng nm
sinhNGAYSINH DateTime 01/11/1987 THONGTINSV
Gii tnh GIOITINH Nvarchar 34 Nam THONGTINSV
Dn tc DANTOC Nvarchar 46 Kinh THONGTINSV
Tn gio TONGIAO Nvarchar 410 Khng THONGTINSV
Chng minh th
nhn dnCMTND Big Integer 12421403 THONGTINSV
H khu thng
tr
HKTHUONG
TRUNvarchar 30100
Ba nh, H
NiTHONGTINSV
Qu qun QUEQUAN Nvarchar 30100 Hng Yn THONGTINSV
i tng DOITUONG Nvarchar 46 06 THONGTINSV
a ch lin h DCLIENHE Nvarchar 3010068A Th L, Ba
nh, H Ni THONGTINSV
H v tn b HTBO Nvarchar 2530Nguyn Ngc
TunTHONGTINSV
Ngh nghip b NNBO Nvarchar 2540 B i THONGTINSV
H v tn m HTME Nvarchar 2530 V Th Hng THONGTINSV
29
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
30/50
Bo co K thut phn mm Nhm GD2K
Ngc
Ngh nghip m NNME Nvarchar 2540 Cng nhn THONGTINSV
Nm tt nghip NAMTN Datetime 2005 THONGTINSV
Xp loi TNPTTH
XLPTTH Nvarchar 45 Gii THONGTINSV
Nm vo trng NAMVT Datetime 2005 THONGTINSV
S bo danh SBD Nvarchar 610 BKA0168 THONGTINSV
im vo
trngDIEMDH
Tiny
Integer28 THONGTINSV
Ngy vo on NVDOAN Datetime 01/04/1002 THONGTINSV
Ngy vo ng NVDANG Datetime 08/12/2008 THONGTINSV
Lp trc khi
phn ngnhLOPTPN Nvarchar BK17 THONGTINSV
Ngnh hc NGANHHOC Nvarchar3050
k t
in t Vin
ThngTHONGTINSV
Hc k i
cngHKDC
Tiny
Integer1
DIEMDC
MONHOCDC
M mn i
cng
MAMONDC Nvarchar GT1DIEMDC
MONHOCDCMn hc i
cngMONDC Nvarchar Gii tch 1 MONHOCDC
im i cng
ln 1DIEMDC1
Tiny
Integer010 8 DIEMDC
im i cng
ln 2DIEMDC2
Tiny
Integer010 DIEMDC
im i cng
ln cao nhtDIEMDCCN
Tiny
Integer010 8 DIEMDC
Hc k chuyn
ngnhHKCN
Tiny
Integer14 6
DIEMCN
MOCHOCCN
M mn chuyn
ngnhMAMONCN Nvarchar TTT2
DIEMCN
MONHOCCN
Mn hc chuyn MONCN Nvarchar in t MONHOCCN
30
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
31/50
Bo co K thut phn mm Nhm GD2K
ngnh tng t 2
im chuyn
ngnh ln 1DIEMCN1
Tiny
Integer010 10 DIEMCN
im chuyn
ngnh ln 2 DIEMCN2Tiny
Integer 010 DIEMCN
im chuyn
ngnh ln cao
nht
DIEMCNCNTiny
Integer010 10 DIEMCN
S n v hc
trnhSODVHT
Tiny
Integer1100 35
MONHOCDC
MONHOCCN
3.1.9 Cc quy tc m bo ton vn d liu3.1.9.1 Quy tc ton vn thc thQuy tc m bo ton vn thc th c pht biu nh sau: Khng
mt thnh phn no ca cc thuc tnh dng lm kha chnh trn mt bngd liu c l NULL.
p dng quy tc ton vn thc th:Cc thuc tnh kho :
S hiu sinh vin (trong bng THNGTINSV, IMC, IMCN).
M mn i cng (trong bng IMC, MNC).
M mn chuyn ngnh (trong bng IMCN, MNCN).
M lp (trong bng LP).
khng c php rng (NULL) tc l khng nhp k t no vo.
3.1.9.2 Quy tc ton vn quy chiuQuy tc m bo ton vn quy chiu c pht biu nh sau: Nu
mt bng d liu bao gm mt kha ngoi lai (FK) khp vi mt kha chnh(PK) trn mt bng d liu T no th mi gi tr FK phi hoc bng gitr ca kha chnh trn mt hang no ca bng d liu T hoc hon tonNULL
Phi tun th quy tc m bo ton vn d liu cho 3 thao tc Chn(Insert), Thay i (Update) v Xa (Delete).
31
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
32/50
Bo co K thut phn mm Nhm GD2K p dng quy tc m bo ton vn quy chiu:
Php ton Chn (Insert): Khi thm mi mt bn ghi vo bng
IMC, IMCN th SHSV phi tn ti trn ct SHSV trong bng
THNGTINSV; thm bn ghi vo bng THNGTINSV th MALOP phitn ti trn ct MALOP trong bng LOP
Php ton Thay i (Update): Khi thay i mt bn ghi vo bng
IMC, IMCN th SHSV phi c thay i trn ct SHSV trong
bng THNGTINSV; thay i bn ghi vo bng THNGTINSV th
MALOP phi c thay i trn ct MALOP trong bng LOP
Php ton Xo (Delete): Khi cn xa mt bn ghi vo bngIMC, IMCN th SHSV phi c xo trn ct SHSV trong bng
THNGTINSV; xo bn ghi vo bng THNGTINSV th MALOP phi
c xo trn ct MALOP trong bng LOP
3.2 LU THUT TON MT S CHC NNG C BN
3.2.1 Nhp thng tin sinh vin:
32
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
33/50
Bo co K thut phn mm Nhm GD2K
3.2.2 Tm kim SV
33
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
34/50
Bo co K thut phn mm Nhm GD2K
3.2.3 Nhp im- Nhp im ln 1:
34
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
35/50
Bo co K thut phn mm Nhm GD2K
Nhpthng tin
Bt uBt u
Lp nhp?
C thy SV?
im c?
Kt thcKt thc
ng
ng
Chn mn c
Nhp tip?
Lu im
Sai
Hp l?
Sai
ng
Sai
ng
Sai
Sai
Nhpthng tin
- Nhp im ln 2:
35
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
36/50
3.2.4 Xt hc bng
Bt u
Nhp thng tin
Tm DSSVca lp
Tm DS mnca hc k
C im ln 1 < 5
Tnh im trung bnh (TB)
TB < TB mc 3
Da vo im TB v cc mc nhpa ra cc loi hc bng
Kt thc
Nhp tip ?ng
Sai
ng
Sai
ng
Sai
ng
Sai
ng
Sai
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
37/50
3.2.5 Xt thi li
Bt u
Nhp thng tin
Tm danh schSV
Tm mn
im ln 1 < 5
Ht danh sch SV
Nhp vo bng thi laiSinh vin tip
Hin danh sch SV thi li
Kt thc
Tm tip ?ng
Sai
ng
Sai
ng
Sai
ng
Sai
ng
Sai
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
38/50
IV. TRIN KHAI4.1 Mi trng pht trin, cng c xy dng CSDL v
ngn ng lp trnh.
Chng trnh c xy dng trn mi trng Windows, yu cu vcu hnh v cc phn mm ph tr chy c chng trnh: my cit h iu hnh Windows 9x/2K/XP/Vista.
Phn mm c xy dng t hai cng c ch yu l: MicrosoftVisual Basic 6.0 v Microsoft Office Access 2003.
Microsoft Office Access 2003 l chng trnh dng xy dng hqun tr c s d liu. Access l mt h qun tr d liu quan h (RDMS-Relational Database Management System) rt ph hp cho cc bi ton vav nh; hiu nng cao v d s dng bi giao din s dng phn mm ny
gn ging nh mt s phn mm khc trong b MS Office.Ngn ng lp trnh c s dng l Microsoft Visual Basic 6.0. y
l mt ngn ng lp trnh da trn m hnh client-server c th kt hp cngMS Access mang li nhng hiu qu cao. VB s dng giao din hangi dng (GUI-Graphical User Interface) nn tng i thn thin v ds dng.
Nh trnh by trong phn m u, do c im ca phn mm nyc thit k trong phm vi mt bi tp ln, vi nhng hn ch v mt thigian cng nh kin thc, nhm chng em quyt nh s dng 2 cng c trn xy dng phn mm Qun l sinh vin ca mnh.
u im ca chng trnh l giao din Ting Vit, gn gi v d sdng, cc thao tc thc hin kh n gin gip cho cn b qun l c thtip cn d dng vi h thng v tng hiu qu ca vic qun l sinh vin.
Tuy nhin do iu khin thi gian v kin thc cn hn ch nnchng trnh cn nhiu im thiu st, mt s module cha hon thin, mts chc nng c phn tch trong phn tm hiu yu cu cha thc hinc. Trong thi gian ti nhm s tip tc nghin cu v hon thin phn
mm chng trnh c kh nng p ng i hi thc t v c a vos dng.
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
39/50
4.2 Phn cng cng vic.1. Nguyn Anh Dng (nhm trng): phn tch v thit k c s
d liu. Phn cng v tng hp cc cng vic ca cc thnh vintrong nhm, vit cc bo co tin v bo co tng hp.
2. Phm Trng Giang: ph trch khu lp trnh v kt ni vi cs d liu.
3. ng Quc Dng: phn tch h thng, xy dng cc s phn cp chc nng FD, biu lung d liu DFD, vit phnhng dn s dng.
4. Thlang KheMaRa: tm hiu yu cu, phn tch cc ti liu bnmu, a ra cc c t v yu cu ca chng trnh.
Tuy c s phn cng cng vic tng i c th, song trong qu trnh
lm vic, xy dng chng trnh nhm lun c s bn lun, trao i vinhau nhm a ra nhng gii php ti u v tng cng ti a hiu qu cacng vic.
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
40/50
V. HNG DN S DNG.5.1 Hng dn ci t.
Trong CD cha b ci t ca chng trnh, chy file setup.exe
Giao din ci t ca chng trnh xut hin. Nhn OK tip tc.
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
41/50
Chng trnh yu cu ngi s dng chn th mc cha chng trnh sc ci t, mc nh l C:\Program Files\Quan ly SV. Nhn ln biutng ci t bt u qu trnh
Chng trnh s tin hnh ci cc th vin lin quan cn s dng ln myngi s dng. Nu c thng bo li v chia s file, bm Ignore bqua. Chng trnh s thng bo qu trnh ci t thnh cng.
chy chng trnh, ngi s dng bm Start -> All Programs ->Quan ly SV - GD2K
5.2 Hng dn s dng:
Ngi s dng c th tm hiu v cc chc nng c th bng cch chnMenu Tr gip -> Hng dn s dng trn giao din ca chng trnh.
Di y l mt s giao din tiu biu:1. Menu chnh
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
42/50
2. Chc nng qun l thng tin sinh vin
2.1 Nhp mi: T menu chnh vo Chc nngQun l thngtinThng tin sinh vinNhp mi
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
43/50
Ngi dng s thy hin ln mt form cho php nhp mi thng tinca mt sinh vin vi y cc thuc tnh (cc thuc tnh c du *bt buc phi nhp v l cc kha chnh trong cc quan h)
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
44/50
2.2 Sa thng tin sinh vin: Chc nngQun l thng tin Thngtin sinh vinSa thng tin.
Sau in s hiu sinh vin
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
45/50
Sau click vo control Sa, chng trnh s hin ra mt bngvi y thng tin sinh vin.
Vi cc chc nng qun l thng tin lp hc, qun l thng tin mnhc v qun l im lm tng t.
3. Chc nng x l hc tp
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
46/50
3.1 Thng tin hc bng: T menu chnh vo Chc nngX l hctp x l hc bng
Chng trnh s xut ra mt bng in cc thng tin v x l hc bng
3.2 Thng tin hc li: tng t
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
47/50
4. Chc nng bo co
T Mennu chnh vo Chc nng Bo co cc ty chn
V d mun xem Danh sch sinh vin, click vo Danh sch sinhvin. Chn trnh s hin ra mt bng ngi dng nhp vo thng tin
lp mun xem
Sau khi ngi dng nhp vo tn lp v kha, n ng chng trnhs xut ra danh sch ca lp .
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
48/50
Giao din ca chng trnh c vit bng Ting Vit nn kh ddng trong vic hc cch s dng. Sau mt khong thi gian ngn ngidng s lm ch c phn mm, khai thc cc tin ch m n mang li,gip vic qun l thng tin ca hng ngn sinh vin tr nn tht n gin.
Lu : my cn ci font .VnTime
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
49/50
KT LUN V KIN NGH MN HC
Sau mt thi gian thc hin, vi s n lc ca c nhm c th ni phnmm Qun l Sinh vin p ng c c bn cc tiu ch t ra banu. Phn mm n gin nhng hiu qu, giao din thn thin vi ngidng, cc chc nng c bn c xy dng kh tt c th gip cho cn bqun l tit kim rt nhiu thi gian cho vic qun l thng tin ca hn 2000sinh vin khoa in T-Vin Thng.
Tuy nhin do iu kin thi gian v kin thc cn hn hp chng trnhkhng trnh khi cn nhiu thiu st. Nhm GD2K rt mong mun c th
tip tc pht trin phn mm ny trong thi gian ti, nng cao hiu qu, cithin cc chc nng, thm vo mt s chc nng m rng p ng cc yucu mi v vic qun l sinh vin trong ch hc tn ch. Nu c u tva pht trin nhm tin rng phn mm hon ton c kh nng ng dngtrong thc t.
Nhm chng em xin chn thnh cm n thy gio Dng B Thun nhit tnh hng dn nhm nhm c th hon thnh phn mm. Nhnhng hng dn ca thy qua cc bi ging, cc v d c th v chnh biton qun l sinh vin gip chng em xy dng phn mm ca mnh hiu
qu v hiu nng hn.Mt s kin ngh cho mn hc:
Qua mn hc K thut phn mm chng em c hc cc bc cbn xy dng mt phn mm qun l, c th a vo p dng trong thct.
Qua cc bi ging v vic lm bi tp ln, chng em hc c rtnhiu k nng khng ch trong vic vit chng trnh m l xy dng mtchng trnh vi y cc bc t tm hiu yu cu, phn tch thit k n
trin khai, kim th. Tuy nhin chng em cng c mt s kin ngh mongthy xem xt ni dung mn hc hp dn hn.
1. V gio trnh:
- Trong tp gio trnh photo cn thiu kh nhiu slide nn chng em hikh khn trong vic theo di cng nh s dng tham kho khi lmbi tp ln hay khi n thi.
-
8/7/2019 BAO CAO BAI TAP LON KTPM NHOM GD2K
50/50
2. V phng tin ging dy
- Cht lng ca my chiu cha c tt, gy kh khn cho vic theodi bi.
3. V ni dung mn hc
- ni dung mn hc hp dn hn, nn thm vo cc phn v d thct vi mt vi phn mm c th. C th chy demo mt s chc nng sinh vin thy cch xy dng c s d liu, cc li gp phi vhng khc phc.
Kin ngh v xut tng
- Nh trnh by trn theo chng em nn c cc phn trc quantrong bi ging. V th theo chng em c th kt hp c nhng bui cc nhm trao i v bi tp ln. C th lm power point thuyt
trnh, ch yu cc nhm trao i kinh nghim, a ra cc vn gp phi trong qu trnh lm bi tp ln cng trao i v nh thyhng dn. Chng em tin rng qua nhng bui nh vy s gip ccbn hiu hn v bi ging, ng thi cng gip cc nhm gii quytc cc vn trong bi tp ln ca mnh, a ra cc gii thut tiu hn.
MT S TI LIU THAM KHO
Slide Bi ging K thut phn mm- Dng B Thun
Gio trnh Access- Nguyn Sn Hi.
T hc Visual Basic 6 (khng r tc gi).
Lp trnh trc quan- Nguyn Trung Ha.
http://dtdh.hut.edu.vn
http://google.com
http://dtdh.hut.edu.vn/http://dtdh.hut.edu.vn/http://google.com/http://google.com/http://dtdh.hut.edu.vn/http://google.com/