Professional Documents
Culture Documents
QUN L
H THNG THNG TIN
QUN L
Chng I: Cc khi nim c bn v h thng
thng tin
Chng II: C s cng ngh thng tin ca h
thng thng tin
Chng III: Phn tch, thit k v ci t h
thng thng tin qun l
Chng IV: Cc h thng thng tin phc v qun
l doanh nghip
TI LIU THAM KHO
TrngVnT,TrnThSongMinh. Gio trnh
H thng thng tin qun l. NXB Thng k, H ni,
2000.
HnVitThun,Tr ngVnT,CaonhThi,
TrnThSongMinh. Gio trnh h thng thng
tin qun l (Dng cho h cao hc v Nghin cu
sinh). NXB Lao ng-X hi, H ni, 2004.
Nguyn Vn Ba. Phn tch v thit k HTTT.
Cp
Quyt nh chin lc Thng tin
Cp chin
Quyt nh thut Thng tin
X l giao dch
D liu D liu D liu
CHNG I: CC KHI NIM C BN
V H THNG THNG TIN
Ph gim Ph gim
c (TC) c (NL)
K K T Vn Bo
ton hoc chc th v
h
CHNG I: CC KHI NIM C BN
V H THNG THNG TIN
Doanh nghip
cnh tranh
DOANH NGHIP
Doanh nghip c
lin quan
H thng qun l
Doanh nghip s
cnh tranh
i tng qun l
Nh cung cp
CHNG I: CC KHI NIM C BN
V H THNG THNG TIN
Thu X l v Phn
thp lu tr pht
Kho d liu
CHNG I: CC KHI NIM C BN
V H THNG THNG TIN
phc v
Phn loi h thng thng tin trong t chc
doanh nghip
CHNG I: CC KHI NIM C BN
V H THNG THNG TIN
Quitctrchi:
Chia s SV lm hai nhm. Mi nhm c mt
nhm trng.
Cc thnh vin trong nhm xp thnh hng
dc
Tin c truyn l s bt k
Quitctrchi:
Sau khi nhn tin cc thnh vin s truyn tin ln
Mng my tnh
2.1.1 My tnh in t:
a. S chc nng
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
B x l lnh B logic v
Thc hin s hc
ch th v Thc hin cc Cc thit b
Cc thit b vo iu khin php ton s ra
Nhp d liu x l hc v so snh a thng
v chng tin ra t
B nh trong trong
trnh vo my
Lu tr d liu v cc chng my tnh
tnh
trnh trong thi gian x l
Thit b nh ngoi
Lu tr d liu v
chng trnh cho
cc cng vic x l
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
My tnh ln (MainFrame)
My tnh c va (MiniComputer)
My vi tnh (MicroComputer)
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
b. Cc loi mng:
Mng LAN: mng cc b
Mng LAN:
Thnh phn mng LAN: My ch tp, My ch
in n, My ch truyn thng, My trm, Dy cp,
Cc giao din mng (NIC), H iu hnh mng
(NOS)
Cc cu hnh mng: Mng hnh sao, mng
ng trc, mng vng, mng hn hp, mng
xng sng
MNG HNH SAO (STAR)
MNG VNG (RING)
MNG NG TRC (BUS)
MNG HN HP
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
Mng WAN:
Thnh phn mng WAN: My ch, My tin x
l, Modem, Thit b u cui, B tp trung, Giao
thc truyn thng, Phn mm mng
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
Mng INTERNET:
Thnh phn mng INTERNET: Mng con, u
cui, H thng trung gian, Cu ni, B dn
ng, Giao thc INTERNET
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
ca my tnh
Phn mm tin ch: x l cc nhim v thng
gp.
Phn mm pht trin: Cc ngn ng lp trnh,
Gi c phn mm - Yu cu ca b nh
c vi nhau
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
Chn phn mm
biu, tng hp cc mc
CHNG II: C S CNG NGH THNG
TIN CA H THNG THNG TIN
ch c mt cha
K43 Anh 1
K44A
K45 Anh 3
K44C
K44D
2.4.3 Cc loi m hnh d liu:
M hnh mng li: mi cha c N con,
mi con M cha
Quan h 1 1
Quan h 1 n
Quan h n - n
CHNG II: C S CNG NGH
THNG TIN CA H THNG THNG
TIN
Nhng yu cu mi ca nh qun l
Qun l kho
hng
Nhp Xut Kim k
hng hng
Xut trnh Xut trnh Kim k
phiu phiu
nhp xut
Ghi s
Nhp Giao gc
hng hng
Ghi s Ghi s
gc gc
Ghi s danh
mc
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
3.1 NH GI YU CU:
Mc tiu: cung cp cho lnh o t chc hoc
Nghin cu ti liu
Quan st
3.2.3 M ho d liu:
a. Khi nim m ho d liu:
b. Cc phng php m ho d liu:
M ho phn cp: h thng nh s
M ho8gi
93nh:
5025VND,
33457 6
USD
M ho ghp ni: NTHD1000136
V d m ho th sinh trng H NT
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
c. Li ch ca m ho d liu:
Nhn din khng nhm ln i tng
c.Ccphngphpphnrchc
nng:
Top Down
Bottom Up
d.Quitclpschcnng:
Tun t
La chn
Php lp
d.Vd:
Qun l kho
hng
Nhp * Xut * Kim k*
hng hng
Xut trnh Xut trnh Kim k
phiu phiu
nhp xut
Ghi s
Nhp Giao gc
hng hng
Ghi s Ghi s
gc gc
Ghi s danh 0
mc
e.Bitp:Hy v s chc nng qun
l ti trng i hc Ngoi Thng
e.Bitp:
Qun l trng H
Th cng Tin hc ho
Bng im In bng
Cui Trung bnh im MH
mi hc
k Bng im Tnh BQ
Bnh qun
In im BQ
Thi im Khch hng Th kho Phng K
ton
Khch
Ha n KT s
hng n Ko
Xut hng
nhn
hng Xut
hng
Ha n
Xut hng
S kho
hng
Hng mi
s S danh
mc
S kho
hng
Phiu thanh
Sau ton tin Tnh tin
xut
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Tin trnh x l: Tn
x l
Tc nhn: Tn tc nhn
c. Qui tc v s :
Cc bc v s : V s ng cnh, ln
HT
A B C
D E F G H
X
Vd: S ng cnh
c xy dng nh HT
sau:
- Chc nng chnh l: Y
HT
- Cc tc nhn h Z
thng: X, Y, Z
- S c m t:
3.2.6 S lung d liu (DFD):
V s mc nh:
- Tch chc nng chnh ca h thng
thnh cc chc nng con mc 1.
- Xc nh lung d liu gia cc chc
nng b phn vi cc tc nhn ngoi.
- Xc nh lung d liu ni b v kho.
Ch : khi phn r phi bo ton cc lung
d liu v cc tc nhn ngoi.
3.2.6 S lung d liu (DFD):
V s mc nh: phn r thnh cc
chc nng A, B, C v thm kho d liu K.
X
1.A
HT
2.B K
3.C
Y
Z
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
V s di mc nh:
- Phn r ring tng chc nng mc
nh thnh cc s di mc nh.
- Tch cc chc nng mc nh thnh
cc chc nng con mc di. Lm tng t
nh phn r chc nng mc nh.
Ch : khi phn r phi bo ton cc lung
d liu v cc tc nhn ngoi.
3.2.6 S lung d liu (DFD):
V s di mc nh: Phn r x l A
1.1 D
Chc
K1 nng A
1.2 E
K
3.2.6 S lung d liu (DFD):
V s di mc nh: tng t tin
2.2 I
3.2 K
K Z
K Z
3.2.6 S lung d liu (DFD):
1.1 D X
K1
1.2 E
3.1 H
Y 2.1 G
K
3.2 K
2.2 I Z
3.2.6 S lung d liu (DFD):
Mt s qui tc khi v s :
- Tn cc x l l ng t.
- Cc x l phi c m s.
- X l buc phi thc hin bin i d liu.
- Mi lung d liu phi c tn lung tr
lung ni x l vi kho d liu.
- D liu cha trn hai vt mang khc nhau
nhng lun i cng nhau th to nn mt
lung duy nht.
- V li cc kho d liu cc lung khng
ct khau.
3.2.6 S lung d liu (DFD):
Mt s qui tc khi v phn r s :
- Nn ti a 7 x l trn mt s DFD.
- Mt x l m khi trnh by bng ngn ng
cu trc chim mt trang th khng phn r
tip.
- Tt c cc x l trn mt s DFD phi
cng mt mc phn r.
- Lung vo ca mt x l mc cao phi l
lung vo ca mt x l con mc thp no
. Lung ra ti ch ca mt x l con
phi l lung ra ti ch ca mt x l con
mc ln hn.
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Nhp hng
Khch 0.Qun l
hng kho hng
Xut hng
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
d. V d: S mc nh:
DM hng
Ho n nhp 1.Nhp
hng hng
Khch
hng S kho hng
2.Xut
Ho n
xut hng
hng
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
. V d: S chc nng 2:
2.1
Kim tra
Ho n Hng ti
xut hng kho
Khch H c chp
hng nhn
d. V d: S chc nng 2:
HD nhp 1.1 Kim tra DM hng
hng hng nhp
Khch
hng H nhp
hng
Phiu 1.2 Nhp
nhp hng hng vo
kho
S kho hng
d. V d: S tng hp
1.1 Kim tra DM hng
hng nhp
H nhp
hng H nhp hng
1.2 Nhp
Phiu nhp hng vo
Khch hng kho
hng
S kho hng
H xut
hng 2.1
Kim tra
kho hng
Phiu nhn
hng H c
chp
nhn
2.2 Xut
hng
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Bi tp:
M t s chc nng ca h thng chm,
qun l im.
M t s lung d liu ca h thng
SV 0. QL P o to
im
Bng
Bi thi 1. Chm
thi im
SV P o to
B.im 2. X l Bng
TB im im
M t s lung d liu
1.1 Chm
Bi thi
thi VP Khoa
SV Bi thi
chm Bng
1.2 Vo P o to
im im
2.1 Vo
im MT Bng
im
SV Bng P o to
im
Bim 2.2 Tnh
BQ im Bng
im
M t s lung d liu tng hp
1.1 Chm
thi VP Khoa
Bi thi
Bi thi
1.2 Vo
im Bng
im
SV P o to
2.1 Vo Bi thi
Bi im MT
m BQ
Bng
im
2.2 Tnh
im Bng
im
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Chun on v xc nh cc yu t gii
quyt vn
Xc nh thi hn
Sa i xut d n
u ra
Tin hnh chun ho mc 1 (1.NF): tch cc
..
Vn vay:. K hn:
.
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
tch ring
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Qun l vn vay
S phiu, Ngy vay, M khch hng, Vn vay,
K hn, Li sut.
Danh sch khch hng:
M khch hng, Tn khch hng, a ch, S
CM
Trong danh sch Qun l vn vay: K hn, Li
sut ph thuc bc cu vo kha chnh tch
ring thnh danh sch mi
Kho l: K hn
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Qun l vn vay
S phiu, Ngy vay, M khch hng, Vn
vay, K hn
Danh sch khch hng:
M khch hng, Tn khch hng, a ch, S
CM
Danh mc li sut
K hn, Li sut
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Bc 3:
M t cc tp: Mi danh sch bc 2 l mt
tp c s d liu. Mi danh sch lin quan n
mt i tng qun l. Nu c nhiu danh sch
cng m t v mt thc th th phi tch hp li
thnh 1 danh sch.
Biu din cc tp: Tn tp vit in hoa trn, cc
thuc tnh nm trong cc , trn mt hng. Kho
gch chn.
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
DANH MC LI SUT
K hn Li sut
QUN L VN VAY
M khch Ngy Vn K Ngy TT
hng vay vay hn
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
V d: KHCH HNG
M khch hng Tn KH a ch S CMT
DANH MC LI XUT
K hn Li sut
QUN L VN VAY
M khch Ngy Vn K Ngy TT
hng vay vay hn
Bi tp: thit k CSDL t mu phiu nhp kho sau:
Lit k danh sch cc thuc tnh, gch b
cc thuc tnh th sinh v gch chn cc
thuctnhkha
S phiu
H tn ngi nhp
a ch ngi nhp
a ch Cty nhp
in thoi
STT
Tn hng
n v tnh
n gi
S lng
Thnh tin
Tng cng
S phiu S phiu
H tn ngi nhp M hng
a ch ngi nhp Tn hng
a ch Cty nhp n v tnh
in thoi n gi
Ngi nhn hng S lng
ChunhaNF2:ccthuctnhMhng,Tn
hng,nvtnh,ngikhngphthuc
ton b vo kha tch thnh danh sch
ring
S phiu M hng
M KH Tn hng
H tn ngi nhp n v tnh
a ch ngi nhp n gi
a ch Cty nhp
S phiu
in thoi M hng
Ngi nhn hng S lng
Chun ha NF3: cc thuc tnh H tn
ngi nhp, a ch ngi nhp, a ch
cngtynhp,inthoiphthucbccu
vokhatchthnhdanhschring
M KH M hng
H tn ngi nhp Tn hng
a ch ngi nhp n v tnh
a ch Cty nhp n gi
in thoi
S phiu S phiu
M KH M hng
Mtccbng
DANH MC KHCH HNG
M H tn a ch a ch in
KH ngi ngi Cty nhp thoi
nhp nhp DANH MC HNG
M hng Tn hng n v n gi
tnh
HA N BN HNG
S phiu M KH Ngi nhn
hng
QUN L HNG NHP
S phiu M hng S lng
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
KHCH N T SN
t cha
HNG HNG PHM
c. S mc lin kt:
Lin kt Mt - Mt:
B TH 1 1 CHI
qun l O
CHI
ON N
Lin kt Mt - Nhiu:
CHI 1 N O
c N
ON
VIN
Lin kt Nhiu - Nhiu:
SINH N M MN
Hc HC
VIN
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
vo quan h 1 N
Quan h mt chiu: L anh
em
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
SINH N M
hc LP
VIN
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
GIO
Qun l LP
VIN
D N
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Loi a: - a CD
- a VCD
- a DVD.
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Vd: S hiu a
A Loi a
Nm sn
xut
A S hiu a A CA S hiu a
Tn phim Tn a
PHIM NHC
Loi phim Loi ca nhc
Tn o din Tn ca s
Tn din vin Tn bi ht
Tm tt ni
dung
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
V d: KHCH HNG
1
DANH MC LI XUT 3
K hn Li sut
2 QUN L VN VAY
M khch Ngy Vn K Ngy TT
hng vay vay hn
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Thi gian
Thin hng
Nhn lc
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
Phn mm
Ngun nhn lc
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
phng n
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
- Xc nh cc tiu chun cn nh gi
- Cho mi tiu chun mt trng s
- Tnh im mi phng n theo tiu chun
- Cng im cho mi phng n
- Tng im chnh l ch tiu so snh cc
phng n
P. n 1 P. n 2 P. n 3
Trng s Mc Mc Mc
im im im
Chtlngtt
50 5 4 3
Tin cy 100 80 5 60 4
20 5 50 4 40 4
y 50 20 4 20 4
10 4 20 4 20 3
Thch hp 20 20 2 15 2
5
4 10 10
D hiu 20 4
5
20 4
Bo mt 20
5
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
ti liu gc
Nhm cc trng trn mn hnh theo trt t c
truy tm c
t cc gi tr ngm nh ph hp
Mn hnh
Ting ni
Lp trnh
Th nghim
o to ngi s dng
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
b. Thit k vt l trong cc x l:
A A CA GHI THU
PHIM NHC CHP TIN
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
K thut tch hp
Th nghim h thng
(Ngn ng PASCAL)
Kt qu th nghim
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
H thng c
Ci t h
thng mi
H thng c
Ci t h
thng mi
Ci t h
thng mi
Ci t h
thng mi
H thng H thng c
H thng c Ko m Ko m un
c un 1 t 1,2
Ci t Ci
m un 1 m un 2
M un 1
mi Thi
gian
M un 1, 2
mi
CHNG III: PHN TCH, THIT K V
CI T H THNG THNG TIN
b. Cc kiu bo tr:
Bo tr hiu chnh: cc li thit k, lp trnh cn
tim n sau ci t
Bo tr thch nghi: sa i h thng ph hp vi
mi trng
Bo tr hon thin: ci tin h thng gii
3.7.4 nh gi sau ci t:
- nh gi d n: v thi gian v ngn sch
dnh cho d n so vi d kin
- nh gi h thng: xem xt h thng c t
c mc tiu ra khng
CHNG IV: CC H THNG THNG TIN
PHC V QUN L DOANH NGHIP
doanh nghip
Qun tr cc h thng k ton
nghip
H tr qu trnh kim ton bo m tnh chnh xc
t
nh gi cc khon u t mi v kh nng huy ng
vn ca cc khon u t
4.1 H THNG THNG TIN TI CHNH
nh cc mc tiu u t v thu hi u t, tn
dng cc c hi u t mi hoc kt hp ngun
vn u t cho doanh nghip
* H thng phn tch tnh hnh ti chnh doanh
nghip
* H thng d bo di hn
4.1 H THNG THNG TIN TI CHNH
In bo co k ton qun tr
4.1 H THNG THNG TIN TI CHNH
Phn mm thng k v d bo
Cc h thng k ton t ng ho
xut khc
Kim tra cht lng nguyn vt liu
ra
Kim tra v theo di vic s dng v chi ph
cc ngun lc cn thit
CHNG IV: CC H THNG THNG TIN
PHC V QUN L DOANH NGHIP
X l ti liu
X l d liu
CHNG IV: CC H THNG THNG TIN
PHC V QUN L DOANH NGHIP
H thng hnh nh v ho
Cc thit b a nng
CHNG IV: CC H THNG THNG TIN
PHC V QUN L DOANH NGHIP
mi, Bn hng
Lu kho
v lp bo co nh k.
Cung cp cc cng c m phng, d bo, phn