University Library management system based on VB

1. Overview

In order to meet the urgent demands of the education modernization, we should improve the modern management level of the University library, improve the efficiency of the library, allocate the book Resources better, reduce the labor intensity, and develop the software with my actual interest and knowledge.

2. Detailed design

2. 1. system function Module diagram

2. 2. Data Flow diagram:

3. Database design

3.1 Database Conceptual structure design:

Design of logical structure of 3.2 database

Including System User table Yonghu, reader table Duzhe, Book table Tushu, Borrow table Jieshu, set table Shez.

Book Table Tushu

Field name	Type	Description
Book Number	Text
Title	Text
Author	Text
Press	Text
Price	Text
The number	Text
Have borrowed	Text
The number of loans	Text

Reader Table Duzhe

Field name	Type	Description
Reader number	Text
Name	Text
Class	Text
Phone number	Text
Borrowing times	Text
Borrowed this number	Text
Has paid a fine	Text

Borrow Table Jieshu

Field name	Type	Description
Reader number	Text
Book Number	Text
Library Date	Date/Time
Book Date	Date/Time
Due Date	Date/Time
Renew	Text

Set Table Shez

Field name	Type	Description
Return period	Integral type
Renewal period	Integral type
Maximum number of books borrowed	Integral type