Bao Cao Do an Quan Ly Thu Vien

8/3/2019 Bao Cao Do an Quan Ly Thu Vien

1/21

TRNG CAO NG NGH CNG NGH THNG TIN iSPACE

NQUN L THViN

Khoa Cng Ngh Thng tin


2/21

TRNG CAO NG NGH CNTT iSPACE Website: http://www.ispace.edu.vn

MC CH N

Gip sinh vin nghin cu, n tp v trin khaikin thc mn c s d liu SQLTng hp kin th hc xy dng c s dliu, ng dng thc t trong cng vic


3/21


NNI DUNG CHNHI DUNG CHNH

I - Mc ch ng dng ca s s d liuII Thit k CSDL

1. Phn tch nhu cu thit k

2. M t thc th3. Xy dng m hnh ERD4. M hnh quan h

III Thit k d liu, x l d liu

1. To bng2. To kha chnh, kha ngoi3. Insert d liu4. Truy xut d liu


4/21


MC CH NG DNG CA C S D LIU

MC CH NG DNG CA C S D LIU

H thng c s dng qun l vic mn tr sch trongth vin

Qun l cc loi sch theo nhu cu ngi mn, qun l nsch v tr sch ca ngi mn.

Xc nh c v tr ca sch cn nm trong th vin,

Theo di s lng sch cho nhu cu th vin


5/21


THIT K CSDL

1. Phn tch nhu cu thit k

- Sch cho c gi mn nm trong kho sch c cc thuc tnhl m sch, tn sch

- Qun l sch theo yu cu nh: Tn Tc Gi, th loi, nhxut bn hay tn sch cn tm.

- V tr lu tr cn cho ta bit chnh sch quyn sch nm v tr no chnh xc n tng ngn, k, khu.

- Thng tin sch mn, khi no tr, ht hn bao lu, hn thmn n khi no

- Xem thng tin ca ngi c trong d liu th vin.


6/21


THIT K CSDL

2.Mt thc th

- TheLoai ( Maloai, Tentl)

- TacGia (Mstg,TenTG)

- ViTri (MSVT, Khu, Ke, Ngan)- Sach (Masach, #Maloai, Tensach, #Mstg, #Msvt, Tacgia,

Namxb, Nhaxb, Tongso)

- BanDoc (Mathe, Hoten, Ngaysinh, Phai, Diachi, Dienthoai,

Masv, Hantu, Den)- Muon (Mamuon, #Mathe, Masach, Soluong, Tungay,

Denngay)


7/21


THIT K CSDL

3. M Hnh ERD


8/21


THIT K CSDL

4. M HnhQuan H


9/21


THIT K D LIU X L D LIU

1. To Bng


10/21



1. To Bng (tt)


11/21



2. To kha chnh, kha ngoi

- Hoc to trc tip trn bng


12/21



2. To kha chnh, kha ngoi (tt)


13/21



3. Insert d liu


14/21



3. Insert d liu Sch


15/21



4. Truy vn d liu

- Xem tng s sch c trong kho

- Xem s sch CNTT c trong kho

- Tm Sch v mn internet


16/21



4. Truy vn d liu (tt)- Xem trong kho sch no cn >8 quyn v


17/21



4. Truy vn d liu (tt)

- Xem tn NGUYEN A mn sch g , bao nhiu

- Xem c bao nhiu sch CNTT c trong th vin


18/21




- Mi Nhm sch c bao nhiu loi, s lng

- Xem quyn sch ton ng dng nm v tr no trong kho


19/21




- Lu ra sch ca B Gio Dc xut bn trc nam 2007

- Xem ngi c tui hn 25


20/21


TM LC TI

u im:

ti c bn p ng c nhu cu ca mt th vin.

C th ng dng vo thc t qun l mt th vin trng hc

Qun l chi tit lng sch v v tr quyn sch trong th vin

Khuyt im:

C s d liu cha c tnh logic cao

Cha a ht cc thc th cn thit c th qun l th vinln hn.


21/21

TRNG CAO NG NGH CNG NGH THNG TIN iSPACE

Bao Cao Do an Quan Ly Thu Vien

Documents

Transcript of Bao Cao Do an Quan Ly Thu Vien