With the rapid development of database technology and Internet, they have become an important part of modern information technology and the foundation and core of computer information system and computer application system. For any enterprise, data is an important asset of the enterprise, and how to effectively use these data plays an extremely important role in the development of the enterprise. With the rapid development of China's market economy and the continuous improvement of people's living standards, the number of trees in libraries has gradually increased, which also poses a challenge to book management technology. The previous manual management mode is no longer suitable for the current environment, and it is replaced by an advanced book management system. The book management system created by PowerBuilder can make managers manage, query, borrow and input conveniently and quickly.
2. Demand analysis
2. 1 system target
Book management information system is a typical information management system (m is), and its development mainly includes the establishment and maintenance of background database and the development of front-end application programs. For the former, it is required to establish a database with strong data consistency and integrity and good data security. For the latter, the application is required to be fully functional and easy to use.
The overall task of system development is to realize the systematization, standardization and automation of all kinds of information.
2.2 Definition of requirements
Development of library management system. The overall design goal of system development is to realize the systematization, standardization and automation of book management, and realize the centralized and unified management of books and materials.
This system mainly realizes the management of book information, and its main function is to manage information such as readers, books, borrowing, querying, deleting and administrators. The structure of this system is divided into reader category management, reader file management, book type management, book file management and book process management. Reader management can browse and maintain reader information. Library management can browse and maintain the information of books. Borrowing management can display the borrowing situation of books in the current database and maintain the borrowing information. The main problem solved by this system is to use keywords to query the database.
The functional module diagram of the system is as follows:
Figure 2- 1 System Function Module Diagram
According to the requirements of general library management information system, the following data items are designed by analyzing the content and data flow of library management workflow:
Reader information
Attribute: reader's student number, reader's name, reader's gender, contact telephone number, department, effective date, expiration date, illegal situation, and cumulative borrowing times.
Primary key: the reader's student ID card
Book information
Attribute: ISBN, title, author, publishing house, publication date, introduction.
Primary key: ISBN
Administrator information
Attribute: work number, name, gender, telephone number and home address.
Primary Key: Work Order Number
2.3 data flow
2.3. 1 reader
As a student, the requirements for the library management system are:
1. You can query the books in the library in various ways (such as title, book number and author).
It is convenient to borrow, renew and return books.
3. Be able to query your basic information and borrow books.
4. Familiar with the use of the book management system.
The flow chart for readers to enter the system is as follows:
2- 1 Enter the system flow chart
librarian
As librarians, their requirements for the book management system are:
1. It is convenient to enter and register books and cancel outdated books.
2. It is convenient for freshmen to register or cancel the information of graduated students (basic information, borrowing information).
3. Be able to release some information at any time, such as the overdue borrowing of books by students from various colleges, the collection of books in the library and the borrowing situation. , so that colleges can keep abreast of some book borrowing information of students in our college.
The librarian's work flow chart is as follows:
2-2 librarian work flow chart
3. Function description
The system function analysis is completed on the basis of the overall task of system development. The system needs to complete five main functions:
(1) Basic operations such as book entry, modification and deletion.
1. Formulation of book category standards and input of category information, including category number, category name, keywords, remark information, etc.
2. Query and modification of book category information, including category number, category name, keywords, remarks, etc.
3. Input of book information, including book number, book title, book category, author's name, publisher's name, publication date, book page number, keywords, registration date, remark information, etc.
(2) Handling the library card module.
1. Freshmen apply for a library card.
I lost my library card.
(3) Realize the function of borrowing books.
1. Input of borrowing information, including borrowing information number, reading number, reader's name, book number, title, borrowing date, remark information, etc.
2. Query and modification of borrowing information, including borrowing information number, reader number, reader name, book number, book title, borrowing date and remark information.
(4) realize the function of returning books.
1. Input of book return information, including book return information number, reader number, reader's name, book number, book title, book borrowing date, book return date, remark information, etc.
2. Query and modification of book return information, including book return information number, reading number, reader's name, book number, book name, book borrowing date, book return date, remark information, etc.
(5) The book query is convenient. Prompt information can be given automatically after the deadline.
4. Conceptual model design
The E-R diagram of each part is as follows:
(1) E-R diagram of reader information category entity
E-R diagram of 4- 1 reader class entity
(2) E-R diagram of book information category entities
4-2 E-R Diagram of Book Category Entity
(3) E-R diagram of book lending entity:
4-3 E-R Diagram of Book Lending Entity
(4) E-R diagram of complaint management entity:
4-4 E-R diagram of complaint management entity
4-5 E-R diagram of the relationship between entities
Borrowing relationship (ternary relationship among readers, administrators and books)
Figure 4-6 CDM diagram
5. Logical model design and optimization
From the theoretical "E-R model" to the theoretical "relational model", the following relational models can be obtained through the transformation from the E-R model to the relational model:
Lending relationship
Attributes: work number, reader's student number, ISBN, whether to renew the book, date of borrowing the book, date of returning the book, and remarks.
Primary key: job number, reader ID, ISBN.
Administrator _ Book Relationship
Attribute: job number, ISBN, adding time, whether it is in the library.
Primary key: job number, ISBN
Administrator _ student relationship
Attribute: work number, reader's student number, borrowing and returning confirmation.
Primary key: work number, reader's student number
The CDM diagram design by that conceptual model is transformed into the correspond PDM diagram by powerdesigner: