Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

GII THIU CHUNG: Do chng em mi tham gia n v phn tch thit k nn cha c nhiu kinh nghim, chng em chn ti phn tch thit k h thng thng tin QUN L MUA BN HNG ging nh mt siu th, y chng em s phn tch 2 bn giao dch: th nht l giao dch gia ca hng v khch hng v giao dch ca ca hng vi nh cung cp hng ha. Nhng chng em ch tp trung phn tch h thng qun l ca ca hng. V phn thit k giao din do em tng hc ASP nn em thit k sn giao din v tan b c kt ni vi c s d liu thnh mt chng trnh hon chnh.V th phn n c phn khng hon chnh mong thy b qua. Em xin chn thnh cm n thy

Trang 1 trong 50 trang

Phn tch thit k h thng qun l bn hng

MC LC

Trng HKHTN 2008

Trang Gii thiu chung.............................................................................................................. 1 1. Gii thiu h thng ca hng..................................................................................... 2 1.1 H thng hin hnh............................................................................................ 2 1.2 H thng tng lai.............................................................................................. 2 2. Phn tch...................................................................................................................... 3 2.1 Pht hin thc th .............................................................................................. 5 2.2 M hnh ERD...................................................................................................... 6 2.3 M t chi tit thc th........................................................................................ 6 2.4 Chuyn m hnh ERD sang m hnh quan h.................................................. 9 2.5 Pht hin cc rng buc..................................................................................... 9 2.6M hnh DFD....................................................................................................... 10 2.7M t x l, kho d liu................................................................................... 16 2.8M hnh FlowChart............................................................................................. 23 3. Thit k giao din........................................................................................................ 37 3.1 Chc nng Login................................................................................................ 37 3.2 Chc nng view.................................................................................................. 38 3.3 Chc nng edit.................................................................................................... 39 3.4 Chc nng search............................................................................................... 41 3.5 To Report.......................................................................................................... 42 3.6 Menu File............................................................................................................ 43 3.7 Menu Help........................................................................................................... 43 3.8 Chc nng Logout.............................................................................................. 44 3.9 ng nhp vi quyn user................................................................................. 44 3.10 Rng buc trong form...................................................................................... 45 4. u v khuyt im...................................................................................................... 47 4.1 u im............................................................................................................... 47 4.2 Khuyt im........................................................................................................ 47 5. Cu hnh v phn mm lm n............................................................................. 48 5.1 Cu hnh.............................................................................................................. 48 5.2 Phn mm........................................................................................................... 48 6. Phn cng.................................................................................................................... 49 Li cm n....................................................................................................................... 50

Trang 2 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

1> Gii thiu h thng ca hng H thng hin hnh: Ca hng hin c h thng qun l nhn vin, qun l ha n giao dch gia khch hng vi ngi mua, ng thi c thm ha n giao dch gia ca hng vi ngi cung cp hng ha. H thng tng lai: S pht trin h thng da trn nn web khch hng d giao dch. 2> Phn tch 2.1 Pht hin thc th a) Thc th: NHAN_VIEN - Chi tit cc nhn vin trong c s d liu. - Thuc tnh: #MaNhanVien, HoVaTen, SoPhone, DiaChi, TrangThai. b) Thc th: NHAN_VIEN_KT - Chi tit cc nhn vin chuyn v k thut. - Thuc tnh: BangCapKT, NamKN, BacLuong. c) Thc th: NHAN_VIEN_HC - Chi tit cc nhn vin lm vic trong khu vc hnh chnh. - Thuc tnh: TrinhDoHocVan, BacLuong. d) Thc th: PHONG_BAN - Chi tit phng ban mi nhn vin lm vic. - Thuc tnh: #MaPhongBan, TenPhongBan. e) Thc th: PHUONG_THUC_CHUYEN_GIAO - M t phng thc giao nhn hng ha. - Thuc tnh: #MaPhuongThucChuyen, MoTaCuThe. f) Thc th: DON_DAT_HANG - Chi tit n t hng ca ca hn. - Thuc tnh: #MaDon, MaNhaCungCap, MaNhanVien, MaMatHang, MaPhuongThucChuyen, NgayDat, NgayChuyenDen, CuocPhiVanChuyen. g) Thc th: NHA_CUNG_CAP - Chi tit nh cung cp hng ha cho ca hng. - Thuc tnh: #MaNhaCungCap, MaMatHang, TenNhaCungCap, DiaChi, ThanhPho, MaVung, QuocGia, SoPhone. h) Thc th HOA_DON_GIAO_DICH - Chi tit ha n sau khi giao dch hng ha. - Thuc tnh: #MaHoaDonGD, MaDon, MaMatHang, MaNhanVien, NgayGiaoDich, MoTaGiaoDich, SoLuongDatHang, SoLuongNhan, TongSoTien. i) Thc th MAT_HANG - Thng tin chi tit mt hng c trong ca hng. - Thuc tnh: #MaMatHang, MaPhanLoai, TenMatHang, DonGia, CapDoMatHang (A, B, C), SoLuong. j) Thc th PHAN_LOAI - Chi tit phn loi tng loi hng. - Thuc tnh: #MaPhanLoai, MoTaCuThe. k) Thc th NGUOI_DAT_HANG - Chi tit ngi t hng m ngi cung cp lu tr. - Thuc tnh: #MaNDH, Ten, DiaChi.

Trang 3 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

l) Thc th KHACH_HANG - Chi tit thng tin khch hng mua hng ti ca hng. - Thuc tnh: #MaKhachHang, HoVaTen, DiaChi, SoPhone, Email. m) Thc th HOA_DON_BAN_HANG - Chi tit ha n bn hng ti ca hng - Thuc tnh: #MaDonBanHang, NgayGiaoDich, MoTaGiaoDich, SoLuong, MaPhuongThucChuyen, CuocPhiVanChuyen, TongSoTien.

Trang 4 trong 50 trang

Phn tch thit k h thng qun l bn hng

2.2 M hnh ERD
CHUC_VU #MaChucVu TenChucVu
(1,n)

Trng HKHTN 2008

PHONG_BAN #MaPhongBan TenPhongBan C

(1,n)

DON_DAT_HANG #MaDon MaNhaCungCap MaNhanVien NgayDat NgayChuyenDen MaPhuongThucChuyen CuocPhiVanChuyen MaMatHang

(1,1) (1,1)
(1,n)

NGUOI_DAT_HANG #MaNDH Ten DiaChi MaMatHang SoLuong

(1,n)

Thuc
(1,1)

(1,1)

NHAN_VIEN #MaNhanVien HoVaTen SoPhone DiaChi TrangThai

Lp
(1,1)

Lp

NHA_CUNG_CAP #MaNhaCungCap TenNhaCungCap DiaChi ThanhPho MaVung QuocGia SoPhone MaMatHang

(1,n)

(1,n)

NHAN_VIEN_KT BangCapKT NamKN BacLuong

NHAN_VIEN_HC TrinhDoHocVan NamKN BacLuong

(1,n)

C
(1,1)

PHUONG_THUC_CHUYEN_GIAO #MaPhuongThucChuyen MoTaCuThe

HOA_DON_GIAO_DICH #MaHoaDonGD MaMatHang MaDon NgayGiaoDich MoTaGiaoDich SoLuongDatHang TongSoTien SoLuongNhan MaNhanVien
(1,1)

(1,1)

HOA_DON_BAN_HANG #MaDonBanHang NgayGiaoDich MaMatHang MoTaGiaoDich SoLuong MaPhuongThucChuyen CuocPhiVanChuyen TongSoTien t hng
(1,1)
(1,n)

(1,n)

(1,n)

MAT_HANG #MaMatHang TenMatHang MaPhanLoai DonGia CapDoMatHang(A,B,C) SoLuong

KHACH_HANG #MaKhachHang HoVaTen DiaChi SoPhone Email

(1,1)

(1,n)

PHAN_LOAI #MaPhanLoai MoTaCuThe

Thuc

Trang 5 trong 50 trang

Phn tch thit k h thng qun l bn hng

2.3 M t chi tit thc th a) Thc th: NHAN_VIEN Thc th: NHAN_VIEN Tn Thuc tnh Din Gii #MaNhanVien M s nhn vin HoVaTen H v tn nhn vin SoPhone S in thoi nhn vin DiaChi a ch nhn vin TrangThai Tnh trng nhn vin b) Thc th: NHAN_VIEN_KT Thc th: NHAN_VIEN_KT Tn Thuc tnh Din Gii BangCapKT Bng cp k thut nhn vin NamKN S nm kinh nghim nhn vin BacLuong H s lng nhn vin c) Thc th: NHAN_VIEN_HC Thc th: NHAN_VIEN_HC Tn Thuc tnh Din Gii TrinhDoHocVan Trnh hc vn nhn vin BacLuong H s lng d) Thc th: PHONG_BAN Thc th: PHONG_BAN Tn Thuc tnh Din Gii #MaPhongBan M phng nhn vin lm vic TenPhongBan Tn phng nhn vin lm vic e) Thc th: PHUONG_THUC_CHUYEN_GIAO Thc th: PHUONG_THUC_CHUYEN_GIAO Tn Thuc tnh Din Gii #MaPhuongThuc M phng thc chuyn giao Chuyen hng ha MoTaCuThe M t phng thc chuyn giao

Trng HKHTN 2008

Kiu d liu Chui Chui Chui Chui Chui

Loi d liu Rng buc Khng rng buc iu kin Khng rng buc iu kin

Kch thc 8 k t 50 k t 10 k t 50 k t 10 k t

Kiu d liu Chui S S

Loi d liu iu kin Khng rng buc Khng rng buc

Kch thc 1 k t

Kiu d liu Chui S

Loi d liu Khng rng buc Khng rng buc

Kch thc 10 k t

Kiu d liu Chui Chui

Loi d liu Rng buc Khng rng buc

Kch thc 8 k t 50 k t

Kiu d liu Chui Chui

Loi d liu Rng buc Khng rng buc

Kch thc 8 k t 50 k t

Trang 6 trong 50 trang

Phn tch thit k h thng qun l bn hng

f) Thc th: DON_DAT_HANG Thc th: DON_DAT_HANG Tn Thuc tnh Din Gii #MaDon M n t hng. MaNhaCungCap M nh cung cp hng ha. MaNhanVien M nhn vin t hng. MaMatHang M mt hng. MaPhuongThuc M phng thc vn chuyn Chuyen hng ha. NgayDat Ngy t hng ha. NgayChuyenDen Ngy chuyn hng ha. CuocPhiVan Tin vn chuyn hng ha. Chuyen g) Thc th: NHA_CUNG_CAP Thc th: NHA_CUNG_CAP Tn Thuc tnh Din Gii #MaNhaCungCap M nh cung cp hng ha. TenNhaCungCap Tn nh cung cp hng ha. DiaChi a ch nh cung cp. ThanhPho Thnh Ph nh cung cp. MaVung M vng ca nh cung cp. QuocGia Quc gia nh cung cp. SoPhone in thoi nh cung cp. h) Thc th HOA_DON_GIAO_DICH Thc th: HOA_DON_GIAO_DICH Tn Thuc tnh Din Gii #MaHoaDonGD M ha n giao dch. MaDon. M s ha n t hng. MaMatHang. M s mt hng. MaNhanVien. M s nhn vin. NgayGiaoDich. Ngy giao dch. MoTaGiaoDich. M t qu trnh giao dch. SoLuongDatHang. S lng hng t. SoLuongNhan. S lng hng nhn. TongSoTien. Tng s tin thanh tan.

Trng HKHTN 2008

Kiu d liu Chui Chui Chui Chui Chui Ngy thng Ngy thng S

Loi d liu Rng buc Rng buc Rng buc Rng buc Rng buc Rng buc Rng buc Khng rng buc

Kch thc 8 k t 8 k t 8 k t 8 k t 8 k t

Kiu d liu Chui Chui Chui Chui Chui Chui Chui

Loi d liu Rng buc Khng rng buc Khng rng buc Khng rng buc Rng buc Khng rng buc Rng buc

Kch thc 8 k t 50 k t 50 k t 20 k t 8 k t 20 k t 10 k t

Kiu d liu Chui Chui Chui Chui Ngy thng Chui S S S

Loi d liu Rng buc Rng buc Rng buc Rng buc iu kin Khng rng buc Khng rng buc Khng rng buc Khng rng buc

Kch thc 8 k t 8 k t 8 k t 50 k t

Trang 7 trong 50 trang

Phn tch thit k h thng qun l bn hng

i) Thc th MAT_HANG Thc th: MAT_HANG Tn Thuc tnh Din Gii #MaMatHang. M s mt hng. MaPhanLoai. M phn loi mt hng. TenMatHang. Tn mt hng. DonGia. Gi mt hng. CapDoMatHang Cp xp loi mt hng. (A, B, C). SoLuong. S lng hng ha cn trong kho. j) Thc th PHAN_LOAI Thc th: PHAN_LOAI Tn Thuc tnh Din Gii #MaPhanLoai M s phn loi hng ha MoTaCuThe Tn cc loi hng ha k) Thc th NGUOI_DAT_HANG Thc th: NGUOI_DAT_HANG Tn Thuc tnh Din Gii #MaNDH M s ngi t hng Ten Tn ngi t hng DiaChi a ch ngi t hng l) Thc th KHACH_HANG Thc th: KHACH_HANG Tn Thuc tnh Din Gii #MaKhachHang M s khch hng HoVaTen H v Tn khch hng DiaChi a ch khch hng SoPhone in thoi khch hng Email. Email ca khch hng m) Thc th HOA_DON_BAN_HANG Thc th: HOA_DON_BAN_HANG Tn Thuc tnh Din Gii #MaDonBan M s ha n bn hng Hang NgayGiaoDich Ngy bn hng MoTaGiaoDich M t chi tit bn hng SoLuong S lng hng bn MaPhuongThuc M s phng thc vn chuyn Chuyen hng ha CuocPhiVan Tin vn chuyn hng ha Chuyen TongSoTien S tin tng cng

Trng HKHTN 2008

Kiu d liu Chui Chui Chui S Chui S

Loi d liu Rng buc Rng buc Khng rng buc iu kin Rng buc iu kin

Kch thc 8 k t 8 k t 50 k t 1 k t

Kiu d liu Chui Chui

Loi d liu Rng buc Khng rng buc

Kch thc 8 k t 50 k t

Kiu d liu Chui Chui Chui

Loi d liu Rng buc Khng rng buc Khng rng buc

Kch thc 8 k t 50 k t 50 k t

Kiu d liu Chui Chui Chui Chui Chui

Loi d liu Rng buc Khng rng buc Khng rng buc Rng buc Rng buc

Kch thc 8 k t 50 k t 50 k t 10 k t 50 k t

Kiu d liu Chui Ngy thng Chui S Chui S S

Loi d liu Rng buc iu kin Khng rng buc iu kin Rng buc Khng rng buc Khng rng buc

Kch thc 8 k t 50 k t 8 k t

Trang 8 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

2.4 Chuyn m hnh ERD thnh m hnh quan h NHAN_VIEN (#MaNhanVien, HoVaTen, SoPhone, DiaChi, TrangThai). NHAN_VIEN_KT (BangCapKT, NamKN, BacLuong). NHAN_VIEN_HC (TrinhDoHocVan, BacLuong). PHONG_BAN (#MaPhongBan, TenPhongBan). PHUONG_THUC_CHUYEN_GIAO (#MaPhuongThucChuyen, MoTaCuThe). DON_DAT_HANG (#MaDon, #MaNhaCungCap, #MaNhanVien, #MaMatHang, #MaPhuongThucChuyen, NgayDat, NgayChuyenDen, CuocPhiVanChuyen). NHA_CUNG_CAP (#MaNhaCungCap, #MaMatHang, TenNhaCungCap, DiaChi, ThanhPho, MaVung, QuocGia, SoPhone). HOA_DON_GIAO_DICH (#MaHoaDonGD, #MaDon, #MaMatHang, #MaNhanVien, NgayGiaoDich, MoTaGiaoDich, SoLuongDatHang, SoLuongNhan, TongSoTien). MAT_HANG (#MaMatHang, #MaPhanLoai, TenMatHang, DonGia, CapDoMatHang (A, B, C), SoLuong). PHAN_LOAI (#MaPhanLoai, MoTaCuThe). NGUOI_DAT_HANG (#MaNDH, Ten, DiaChi). KHACH_HANG (#MaKhachHang, HoVaTen, DiaChi, SoPhone, Email). HOA_DON_BAN_HANG (#MaDonBanHang, NgayGiaoDich, MoTaGiaoDich, SoLuong, #MaPhuongThucChuyen, CuocPhiVanChuyen, TongSoTien). 2.5 Pht hin cc rng buc 1> MaNhanVien, MaPhongBan, MaPhuongThucChuyen, MaDon, MaNhaCungCap, MaHoaDonGD, MaMatHang, MaPhanLoai, MaNDH, MaKhachHang, MaDonBanHang phi l duy nht khng c trng nhau. 2> MaNhanVien, MaPhongBan, MaPhuongThucChuyen, MaDon, MaNhaCungCap, MaHoaDonGD, MaMatHang, MaPhanLoai, MaNDH, MaKhachHang, MaDonBanHang s pht sinh t ng. 3> SoPhone phi rng buc c 10 ch s. 4> Email phi rng buc theo a ch mail thng thng. 5> BacLuong phi ln hn 0. 6> NgayDat, NgayGiaoDich phi ln hn hay bng ngy hin ti. 7> NgayChuyenDen phi ln hn ngy t. 8> SoLuongDatHang, SoLuongNhan, TongSoTien, DonGia, SoLuong, CuocPhiVanChuyen phai lon hon 0. 9> CapDoMatHang (A, B, C) phi c la chn A, B hoc C.

Trang 9 trong 50 trang

Phn tch thit k h thng qun l bn hng

2.6 M hnh DFD a) DFD mc 0
Khch hng

Trng HKHTN 2008

Thng tin hng ha Ph hng ha

ng k mua hng

Qun tr

Nh cung cp

Ha n, hng ha , ,s

H thng qun l hng ha

Tr v yu cu

Ha n Tm kim

Nhn vin

n a H gnh m , nc gn S l

gnht n gn t y gn l , gnhi a l

Tr v yu cu Khch hng

Trang 10 trong 50 trang

Phn tch thit k h thng qun l bn hng b) DFD chc nng nh cung cp hng ha
Nh cung cp DON_DAT_HANG Thng tin hng ha

Trng HKHTN 2008

1.1 M hng t Kim tra s lng hng trong kho

h ng

1.2 Tm kim, cp nht ngi t hng

C

Kh ng

Thng tin ngi t hng

1.3.2 Lp ha n

To ngi t hng - M khch hng - S Lng - Ngy t

NHAN_VIEN_HC

HOA_DON_GIAO_DICH

o b gn h T
Th i ng in g t ng n h

c n

1.4 Lp phiu nhp kho

Thng tin ngi t hng

1.3.1

Trang 11 trong 50 trang

Phn tch thit k h thng qun l bn hng c) DFD chc nng lp ha n bun bn
Nhn vin hnh chnh

Trng HKHTN 2008

T h ng h ti n ng kh ch

2.1 Tm kim khch hng Khng c

2.2.1 To khch hng - M s khch hng - S Lng - M hng - Gi tin - Phng thc thanh tan - Ph vn chuyn

Thng tin khch hng

KHACH_HANG

Thng tin khch hng

2.2.2 Lp ha n bn hng

HOA_DON_BAN_HANG

Trang 12 trong 50 trang

Phn tch thit k h thng qun l bn hng d) DFD ca chc nng ngi qun tr hng ha Ngi qun tr Thng tin hng ha
g n Th

Trng HKHTN 2008

3.3 Cp nht s lng

th

tin

Hi n

ng h a h

3.1 Tm m s hng ha
Y u c

3.2 t hng, thm vo kho

T t c th ng t

in

MAT_HANG

Trang 13 trong 50 trang

Phn tch thit k h thng qun l bn hng

e) DFD chc nng qun tr nhn vin
4.1 Xem thng tin trng thi nhn vin Hin th thng tin Ngi qun tr
vin nhn ng tin

Trng HKHTN 2008

4.8 Theo di ngy ngh, lng nhn vin

Th

Th ng
gt n Th

Th n g

tin n h n vi n
tin nh n

Thng tin nhn vin

Th

4.7 Theo di feedback khch hng

4.3

Xa nhn vin ngh

n Th

n g

gt

t in

in

in

nh

nh

n nh

vi n

n v i

vi n

n vi

4.4

4.5

4.6

Thm nhn vin k thut

Thm nhn vin hnh chnh

Chnh sa thng tin nhn vin

Thng tin nhn vin Yu cu NHAN_VIEN

Trang 14 trong 50 trang

Phn tch thit k h thng qun l bn hng

f) Chc nng phn loi hng ha

Trng HKHTN 2008

Nhn vin gnht nt gnh T i 5.1 Phn loi hng ha Thng tin hng ha PHAN_LOAI
ng h tin p g h n a n T h h
lo tin g n ng Th h i

NHA_CUNG_CAP

Thng tin hng ha

s tin ng ng h h ng kho T g l ron t

MAT_HANG

Trang 15 trong 50 trang

Thng tin s lng hng ha

ng h in p g t h n a n Th h

5.2

Cp nht s lng hng ha trong kho

Thng tin hng nhp

M hng ha

Phn tch thit k h thng qun l bn hng

2.7 M t x l, kho d liu 1) M t x l 1.1. S 1.1 Tn: Kim tra hng trong kho. Dng d liu vo: M t hng. Dng d liu ra: Thng bo cn hng hoc ht hng. Din gii: Xut ra thng bo s lng hng ho vi nh cung cp. Tm tt. Input: M hng, s lng. X l. - Kim tra xem s lng cn hay khng. - Nu cn th chuyn qua x l 1.2 - Nu khng cn xut thng bo nh cung cp. Output. S lng hng tng ng trong kho. 2) M t x l 1.2 S 1.2 Tn: Tm kim ngi t hng. Dng d liu vo: Thng tin ngi t hng. Dng d liu ra: Thng bo tm thy hoc khng tm thy. Din gii: Xut ra thng bo vi nh cung cp. Tm tt. Input: Tn, m ngi t hng. X l: Kim tra xem ngi t hng c cng thng tin trn khng. - Nu c: chuyn sang x l 1.3.2 - Nu khng c: chuyn sang x l 1.3.1 Output. Thng tin ngi t hng. 3) M t x l 1.3.1. S 1.3.1 Tn: To ngi t hng. Dng d liu vo: Thng tin ngi t hng. Dng d liu ra: Thng bo nhp thnh cng. Din gii: To ngi t hng mi. Tm tt. Input: Tn, a ch, m ngi t hng, s lng hng, m mt hng. X l: Thm ngi t hng mi. Output: Thng tin ngi t hng.

Trng HKHTN 2008

Trang 16 trong 50 trang

Phn tch thit k h thng qun l bn hng

4) M t x l 1.3.2 S: 1.3.2 Tn: Lp ha n. Dng d liu vo: Thng tin v n t hng. Dng d liu ra: To ho n bn hng. Din gii: To ho n ngi t hng. Tm tt. Input: Thng tin cn c trong ho n. X l: Thm ngi t hng mi. Output: Thng tin ho n. 5) M t x l 1.4 S: 1.4 Tn: Lp phiu xut kho. Dng d liu vo: Thng tin mt hng xut kho. Dng d liu ra: To phiu xut kho. Din gii: To phiu xut kho. Tm tt. Input: S lng, m hng. X l: To phiu, cp nht s lng trong kho. Output: Thng tin phiu xut kho. 6) M t x l 2.1 S 2.1 Tn: Tm kim khch hng. Dng d liu vo: Thng tin khch hng. Dng d liu ra: Khng tm thy hoc tm thy. Din gii: Xut ra thng bo khch hng. Tm tt. Input: Tn, a ch, s phone, email, m khch hng. X l - Kim tra xem c khch hng no trong c s d liu khng. - Nu c: chuyn sang 2.2.2 - Nu khng c: chuyn sang 2.2.1 Output: Thng tin khch hng. 7) M t x l 2.2.1 S 2.2.1 Tn: To khch hng. Dng d liu vo: Thng tin khch hng. Dng d liu ra: Bo nhp thnh cng. Din gii: To ra khch hng mi. Tm tt. Input: Tn, a ch, s phone, email. X l: Thm 1 khch hng mi vo c s d liu. Output: Thng tin khch hang mi to.

Trng HKHTN 2008

Trang 17 trong 50 trang

Phn tch thit k h thng qun l bn hng

8) M t x l 2.2.2 S 2.2.2 Tn: Lp ho n bn hng. Dng d liu vo: Thng tin v cc ho n. Dng d liu ra: To ho n. Din gii: To ra ho n cho khch hng. Tm tt. Input: Thng tin cn c trong ho n. X l: Cp nht khch hng c trong c s d liu. Output: Thng tin ho n. 9) M t x l 3.1 S 3.1 Tn: Xem tn hng ho. Dng d liu vo: Thng tin v m s hng ho. Dng d liu ra: Thng tin v tn hng ho. Din gii: Xut ra tn hng ho cho ngi qun l. Tm tt. Input: Thng tin v m s hng ho. X l: Hin th tn hng ha. Output: Tn hng ho. 10) M t x l 3.2 S 3.2 Tn: t hng, thm hng vo kho. Dng d liu vo: Thng tin hng ho. Dng d liu ra: Thng tin mi ca hng ho. Din gii: Xut ra thng tin mi ca hng ho v lu vo c s d liu. Input: M s, s lng, tn hng ho. X l: Cp nht li s lng hng ho, thm hng ho mi. Output: Thng tin hng ho sau khi cp nht.

Trng HKHTN 2008

11) M t x l 3.3 S 3.3 Tn: Cp nht s lng. Dng d liu vo: Thng tin hng ho trong kho. Dng d liu ra: Thng tin hng ho sau khi nhp hng. Din gii: Xut ra thng tin hng ho sau khi cp nht. Tm tt. Input: M s hng ho, s lng hng ho nhp vo, xut ra, tn hng ho. X l: Cp nht li s lng hng ho sau khi nhp hoc xut ra. Output: Thng tin hng ho sau khi cp nht.

Trang 18 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

12) M t x l 4.1 S 4.1 Tn: Xut tt c thng tin trng thi nhn vin. Dng d liu vo: M s nhn vin. Dng d liu ra: Thng tin nhn vin. Din gii: To ra bng chi tit v nhn vin. Tm tt. Input: M s nhn vin, ngy ngh, tn nhn vin, lng, tnh trng nhn vin. X l: Xem thng tin nhn vin. Output: Chi tit tnh trng nhn vin. 13) M t x l 4.2 S 4.2 Tn: iu phi nhn vin. Dng d liu vo: Thng tin nhn vin. Dng d liu ra: Thng tin nhn vin sau khi iu phi. Din gii: iu phi nhn vin ti khu vc khc. Tm tt. Input: Tnh trng nhn vin cc khu vc cn tuyn, iu phi nhn vin. X l: iu phi nhn vin n khu vc thiu ngi. Output: Tnh trng nhn vin sau khi iu phi. 14) M t x l 4.3 S 4.3 Tn: Xo nhn vin ngh. Dng d liu vo: Thng tin nhn vin hin c. Dng d liu ra: xut thng tin nhn vin sau khi xo. Din gii: Xo nhn vin ngh. Tm tt. Input: Tnh trng, m s, tn nhn vin. X l: Xo nhng nhn vin ngh lm. Output: Chi tit nhn vin sau khi xo, lu vo c s d liu. 15) M t x l 4.4 S 4.4 Tn: Thm nhn vin k thut. Dng d liu vo: Thng tin nhn vin hin c. Dng d liu ra: Thng tin nhn vin k thut sau khi thm. Din gii: Thm nhn vin k thut mi. Tm tt. Input: M s, tn nhn vin. X l: Thm nhn vin k thut mi. Output: Thng tin nhn vin sau khi thm.

Trang 19 trong 50 trang

Phn tch thit k h thng qun l bn hng

16) M t x l 4.5 S 4.5 Tn: Thm nhn vin hnh chnh. Dng d liu vo: Thng tin nhn vin hin c. Dng d liu ra: Thng tin nhn vin hnh chnh sau khi thm. Din gii: Thm nhn vin hnh chnh mi. Tm tt. Input: M s, tn nhn vin. X l: Thm nhn vin k thut mi. Output: Thng tin nhn vin sau khi thm. 17) M t x l 4.6 S 4.6 Tn: Chnh sa thng tin nhn vin. Dng d liu vo: Thng tin nhn vin hin c. Dng d liu ra: Thng tin nhn vin sau khi chnh sa. Din gii: Cp nht li thng tin nhn vin. Tm tt. Input: M s, tn, lng, s ngy ngh, tnh trng nhn vin. X l: Cp nht thng tin sau lu vo c s d liu. Output: Thng tin nhn vin sau khi cp nht. 18) M t x l 4.7 S 4.7 Tn: Theo di Feedback ca khch hng. DDL vo: Thng tin nhn vin. DDL ra: Thng tin Feedback cho mi nhn vin. DG: Theo di Feedback ca khch hng nh gi mi nhn vin. Tm tt. Input: M s, tn Feedback cho mi nhn vin. X l: kim tra Feedback ca nhn vin. Output: Xut ra thng tin Feedbackmi nhn vin lu vo CSDL.

Trng HKHTN 2008

19) M t x l 4.8 S 4.8 Tn: Theo di ngy ngh, lng nhn vin. DDL vo: Thng tin nhn vin. DDL ra: S ngy ngh, tin lng sau khi cp nht. DG: Theo di ngy ngh nhn vin trong thng v cp nht li tin lng. Tm tt. Input: M s, tn, s ngy ngh, lng ca nhn vin. X l: Da theo s ngy ngh, tr tin lng, cp nht li lng nhn vin. Output: Xut ra lng thng nhn vin v lu vo CSDL.

Trang 20 trong 50 trang

Phn tch thit k h thng qun l bn hng

20) M t x l 5.1 S 5.1 Tn: Phn loi hng ho. DDL vo: Thng tin hng ho. DDL ra: Thng tin v loi hng ho cho nhn vin. DG: Phn loi hng ho da theo m s hng ho. Tm tt. Input: M s hng ho hoc tn hng ho. X l: Phn loi m s hng ho. Output: Xut ra loi hng ho v lu vo CSDL. 21) M t x l 5.2 S 5.2 Tn: Cp nht s lng hng ho trong kho. DDL vo: Thng tin hng ha nhp vo kho. DDL ra: Thng tin s lng hng ho trong kho. DG: Cp nht li s lng hng ho sau khi nhp kho. Tm tt. Input: M s, loi hng, s lng. X l: Cp nht li s lng hng ho sau khi nhp kho. Output: Thng tin s lng tng cng, lu vo CSDL.

Trng HKHTN 2008

22) Kho d liu n t hng. Tn kho d liu: DON_DAT_HANG Din gii: Lu tr thng tin chi tit n t hng. Cu trc d liu: MaDon, MaNhaCungCap, MaNhanVien, NgayDat, NgayChuyenDen, MaPhuongThucChuyen, CuocPhiVanChuyen, MaDatHang.

23) Kho d liu nhn vin hnh chnh. Tn kho d liu: NV_HANH_CHINH Din gii: Lu tr thng tin chi tit ca nhn vin hnh chnh. Cu trc d liu: TrinhDoHocVan, NamKN, BacLuong
24) Kho d liu ho n giao dch. Tn kho d liu: HOA_DON_GIAO_DICH Din gii: Lu tr thng tin chi tit ca ho n giao dch. Cu trc d liu: MaGiaoDich, NgayGiaoDich, MaMatHang, MaDon, MieuTaGiaoDich, SoLuongDatHang, SoLuongNhan, TongSoTien 25) Kho d liu khch hng. Tn kho d liu: KHACH_HANG Din gii: Lu tr thng tin chi tit ca khch hng. Cu trc d liu: MaKhachHang, HoVaTen, DiaChi, SoPhone, Email. 26) Kho d liu mt hng. Tn kho d liu: MAT_HANG Din gii: Lu tr thng tin chi tit v hng ho. Cu trc d liu: MaMathang, TenMatHang, MaPhanLoai, DonGia, CapDoMatHang (A, B, C), SoLuongTrongKho.

Trang 21 trong 50 trang

Phn tch thit k h thng qun l bn hng

27) Tn kho d liu nhn vin. Tn kho d liu: NHAN_VIEN Din gii: Lu tr thng tin chi tit v nhn vin. Cu trc d liu: MaNhanVien, HoVaTen, SoPhone, DiaChi.

Trng HKHTN 2008

28) Tn kho d liu nh cung cp. Tn kho d liu: NHA_CUNG_CAP Din gii: Lu tr thng tin chi tit v nh cung cp hng ho. Cu trc d liu: MaNhaCungCap, TenNhaCungCap, DiaChi, ThanhPho, MaVung, QuocGia, SoPhone. 29) Tn kho d liu phn loi hng ho. Tn kho d liu: PHAN_LOAI Din gii: Lu tr thng tin chi tit v cc loi mt hng. Cu trc d liu: MaPhanLoai, MoTaCuThe.

30) Th tc tm kim ngi t hng. Th tc: TimNguoiDatHang(x: string, y: string, z: string) Procedure TimNguoiDatHang(x: string, y: string, x: string) Begin Select MaNDH, Ten, DiaChi From NGUOI_DAT_HANG Where MaNDH= x and Ten= y and DiaChi= z End
31) Th tc tm kim khch hng. Th tc: TimKhachHang(x: string, y: string, z: int, l: string, m: string) Procedure TimKhachHang(x: string, y: string, z: int, l: string, m:string) Begin Select MaKhachHang, HoVaTen, SoPhone, DiaChi, Email From KHACH_HANG Where MaKhachHang=x and HoVaTen= y and SoPhone= z and DiaChi= l and Email= m End 32) Th tc tm nhn vin. Tn th tc: TimNhanVien(x: string, y: string, z: int, k: string) Procedure TimNhanVien(x: string, y: string, z: int, k: string) Begin Select MaNhanVien, HoVaTen, SoPhone, DiaChi From NHAN_VIEN Where MaNhanVien= x and HoVaTen= y and SoPhone= z and DiaChi= k End

Trang 22 trong 50 trang

Phn tch thit k h thng qun l bn hng

2.8> M hnh FlowChart 2> x l 1.2 S 1.2 Tn x l: Tm kim, cp nht ngi t hng

Trng HKHTN 2008

Ma: m Ten: t Boolean: b = false

M table NGUOI_DAT_HANG

S Cha ht d liu c tng dng X X.Ma = m X.Ten = t b = true

ng table NGUOI_DAT_HANG

Trang 23 trong 50 trang

Phn tch thit k h thng qun l bn hng

3> x l 1.3.1 S: 1.3.1 Tn x l: To ngi t hng

Trng HKHTN 2008

Ten: t MaNDH: m Sdt: sdt DiaChi: Dc

M table NGUOI_DAT_HANG

To m s ngi t hng: MsNDH

Thm vo dng X; X.MsNDH = m X.Ten = t X.Ten = t X.Sdt = sdt X.DiaChi = Dc

Trang 24 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

4> x l 1.3.2 S 1.3.2 Tn x l: Lp ha n

SoLuongDatHang :N Array : MaMH [N] Array : TongTien [N] Array : NgayGD [N] Array : MaNV [N] Int : I = 1

M table HOA _DON _GIAO _DICH

To m s ha n : MsHD

Thm vo dng X ; X.MaMH = MaMH [i] X.TongTien = TongTien [i] X.NgayGD = NgayGD [i] X.MaNV = MaNV [i]

I=I+1

I <= N

ng table HOA _DON _GIAO _DICH

Trang 25 trong 50 trang

Phn tch thit k h thng qun l bn hng

5> x l 2.1 S 2.1 Tn: Tm kim khch hng

Trng HKHTN 2008

MaKH: m Ten: t Boolean: b =false

M table KHACH_HANG

Cha ht d liu

c tng dng X

X.MaKH = m X.Ten = t

b = true

ng table KHACH_HANG

6> x l 2.2.1 S 2.2.1 Tn: To khch hng

MaKH: m SoLuong: s MaHang: Ma GiaTien: Gia

M table KHACH_HANG

Tao M s khch hng: MaKH

Thm vo dng X: X..MaKH = m X.SoLuong = s X.MaHang = Ma X.GiaTien = Gia

ng table: KHACH_HANG

Trang 26 trong 50 trang

Phn tch thit k h thng qun l bn hng

7> xl 2.2.2 S 2.2.2 Tn: Lp ha n bn hng

Trng HKHTN 2008

SoLuong : N Array : MaMH [N] Array : NgayGD [N] Array : SoLuongMH [N] Array : Tien [N] Int: i = 1 Int: TongTien = 0

M table HOA _DON _BAN _HANG

To m s ha n

To mt dng d liu X ; X.MaMH = MaMH [i] X.NgayGD [i] X.SoLuongMH = SoLuongMH [i] X.Tien = Tien [i]

TongTien = TongTien + Tien [i]

i= i+1

i <= N

ng table HOA _DON _BAN _HANG

Trang 27 trong 50 trang

Phn tch thit k h thng qun l bn hng

8> x l 3.1 S 3.1 Tn: Xem m s khch hng

Trng HKHTN 2008

MaMatHang: MaMH TenMatHang: TenMH

M table MAT_HANG

S Cha ht d liu c tng dng X X.MaMatHang = MaMH X.TenMatHang = TenMH b = true

ng table MAT_HANG

Trang 28 trong 50 trang

Phn tch thit k h thng qun l bn hng

9> x l 3.2 S 3.2 Tn: t hng, Thm vo kho

Trng HKHTN 2008

MaMatHang: MaMH TenMatHang: TenMH MaPL: MPL DGia: DG CDMH (A,B,C): CD SoLuong: SL

M table MAT_HANG

Thm mt dng d liu X: X.MaMatHang = MaMH X.TenMatHang = TenMH X.MaPL = MPL X.DGia = DG X.CDMH (A,B,C) = CD X.SoLuong = SL

ng table MAT_HANG

Trang 29 trong 50 trang

Phn tch thit k h thng qun l bn hng

10> x l 4.1 S 4.1 Tn x l: Xem tt c thng tin trng thi nhn vin

Trng HKHTN 2008

M table NHAN_VIEN

Cha ht d liu

c dng d liu X

ng table NHAN_VIEN

Trang 30 trong 50 trang

Phn tch thit k h thng qun l bn hng

11> x l 4.3 S 4.3 Tn: Xa nhn vin ngh

Trng HKHTN 2008

TrThai TrT :

M table NHAN_VIEN

S Cha ht d liu c dng d liu X X.TrangThai = Nghi Xa dng X

ng table NHAN_VIEN

Trang 31 trong 50 trang

Phn tch thit k h thng qun l bn hng

12> x l 4.4 S 4.4 Tn: Thm nhn vin k thut

Trng HKHTN 2008

MaNV: MNV HoTen: HT SoPhone: SP DiaChi: DC TrThai; TT BCKT: BC NamKN: NKN Bluong: BL

M table NHAN_VIEN

Thm d liu X vo: X.MaNV = MNV X.HoTen = HT X.SoPhone = SP X.DiaChi = DC X.TrThai = TT

ng table NHAN_VIEN

M table NHAN_VIEN_KT

Thm d liu X vo : X.BCKT = BCKT X.NamKN = NKN X.Bluong = BL

ng table NHAN_VIEN_KT

Trang 32 trong 50 trang

Phn tch thit k h thng qun l bn hng

13> x l 4.5 S 4.5 Tn: Thm Nhn vin hnh chnh

Trng HKHTN 2008

MaNV: MNV HoTen: HT SoPhone: SP DiaChi: DC TrThai; TT TDHV: TD NamKN: NKN Bluong: BL

M table NHAN_VIEN

Thm d liu X vo: X.MaNV = MNV X.HoTen = HT X.SoPhone = SP X.DiaChi = DC X.TrThai = TT

ng table NHAN_VIEN

M table NHAN_VIEN_HC

Thm d liu X vo : X.TDHV = TD X.NamKN = NKN X.Bluong = BL

ng table NHAN_VIEN_HC

Trang 33 trong 50 trang

Phn tch thit k h thng qun l bn hng

14> x l 4.6 S 4.6 Tn: Chnh sa thng tin nhn vin

Trng HKHTN 2008

MaNV: MNV HoTen: HT SoPhone: SP DiaChi: DC TrThai: TT

M table NHAN_VIEN

S Khi cha ht d liu c d liu X X.MaVN = MaNV

Sa dng X: d.MaNV = MaNV d.HoTen = HT d.SoPhone = SP d.DiaChi = DC D.TrThai = TT

ng table NHAN_VIEN

Trang 34 trong 50 trang

Phn tch thit k h thng qun l bn hng

15> x l 5.1 S 5.1 Tn: Phn lai hng ha

Trng HKHTN 2008

MaMH : MMH TenMH : TMH MaPL : MPL MoTa:MT

M table MAT _HANG

Khi cha ht d liu

c d liu X

M table PHAN _LOAI

Thm dng d : d.MaPL = MPL d.MoTa = MT

ng table PHAN _LOAI

ng table MAT _HANG

ng table NHAN _VIEN

Trang 35 trong 50 trang

Phn tch thit k h thng qun l bn hng

16> x l 5.2 S 5.2 Tn: Cp nht s lng hng ha trong kho

Trng HKHTN 2008

SoLuong: SL

M table MAT_HANG

Sa dng X: d.SoLuong = X.SL

ng table MAT_HANG

Trang 36 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

3> Thit k giao din a> Chc nng Login y l trang login vo h thng , c phn quyn admin v user. Admin c mi quyn nh: xem, tm kim, thm, xa, sa, xut report. User ch c quyn xem v tm kim thng tin.

Trong c s d liu s kim tra user v password nu ng v l admin s cho php nhng quyn admin, nu ng nhp sai s bo li v sau 3 ln sai s t ng that khi chng trnh

Trang 37 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

b> Chc nng View Cho php xem thng tin nhn vin, thng tin sn phm, ha n giao dch, ha n bn hng v chi tit khch hng, nh cung cp chng em demo view chi tit nhn vin

Trang 38 trong 50 trang

Phn tch thit k h thng qun l bn hng

c> Chc nng edit

Trng HKHTN 2008

Chc nng thm mi: khi click v menu Addnew chng ta s nhp thm mi v click save lu v c s d liu. y m nhn vin t pht sinh phng trng hp c qu nhiu nhn vin tn nhiu thi gian nhp.

Trang 39 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

Chc nng xa: khi click delete s t ng xa v click save lu li. Demo xa nhn vin c m l 7

Trang 40 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

d> Chc nng search H thng c kh nng search theo tng bng trong c s d liu v tng field v sau s l search theo t kha. 1> Search tng bng

2> Search theo tng field vi mt t kha t nhp

Trang 41 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

e> To report: menu to report cho php xut ra report ca chi tit nhn vin, sn phm,
ha n giao dch, ha n bn hng, khch hng v ngi cung cp.

Report c th in ra tin cho vic qun l:

Trang 42 trong 50 trang

Phn tch thit k h thng qun l bn hng f> Menu File: ch c exit that khi chng trnh

Trng HKHTN 2008

g> Menu Help: To bng file CHM gip ngi dng hiu r hn c ch ca h thng

Trang 43 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

h> Menu Logout: c chc nng that ra khi quyn ng nhp trc ng nhp mi, khi
click vo logout t ng s xut hin trang ng nhp mi

i> ng nhp vi quyn user: ch hin nhng menu View v Search, chc nng ca 2
menu ny tng t quyn admin

Trang 44 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

j> Rng buc trong form: Khi ngi dng nhp sai, h thng bt phi nhp li.

Trang 45 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

Trang 46 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

4> u v khuyt im u im: han thnh cc chc nng ca bi, thit k giao din ng thi to lun c s d liu kt ni vi giao din v vit code bi han chnh hn. ng thi phn mm ny c th ng gi em s dng. Khuyt im: bi lm khng c k do vn cha c kinh nghim trong lnh vc bun bn hng, giao din cn th s.

Trang 47 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

5> Cc phn mm v cu hnh my lm n Cu hnh: Pentium IV 2,4 GHZ, 256MB RAM, 80 GB HDD Phn mm s dng: Microsoft word 2003, Microsoft Visio 2003, SQL Server 2000, VisualStudio 2005

Trang 48 trong 50 trang

Phn tch thit k h thng qun l bn hng

6> Phn cng Ngi lm Nguyn Hi ng (nt)

Trng HKHTN 2008

Kt qu 1> Xy dng m hnh ERD,DFD 2> Pht hin thc th, chuyn m hnh quan h, pht hin cc rng buc 3> M t x l, kho d liu (50%) 4> M hnh FlowChart (50%) 5> Thit k giao din v vit code 6> Lm document 1> Xy dng c s d liu 2> Xy dng m hnh ERD,DFD 3> Pht hin thc th, chuyn m hnh quan h, pht hin cc rng buc 4> M t x l, kho d liu (50%) 5> M hnh FlowChart (50%) 6> Thit k giao din v vit code

Thi gian 3 ngy 3 ngy 3 ngy 3 ngy 3 ngy 2 tun 2 ngy 3 ngy 3 ngy 3 ngy 3 ngy 3 ngy 2 tun

Lng Nguyn Hng Nht

Trang 49 trong 50 trang

Phn tch thit k h thng qun l bn hng

Trng HKHTN 2008

LI CM N Chng em chn thnh cm n thy to c hi v tn tnh gip chng em hon thnh n ny, chc chn s c rt nhiu sai st mong thy gp ti em c thm kinh nghim sau ny han thnh mt cch tt p hn.

Trang 50 trong 50 trang