Completion time of the scheme: June 65438+February 65438+June 2004.
Feasibility analysis report
Our group's information system development course design topic is: library management system development. 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 the information of readers, books, borrowers and managers. The system structure is divided into reader information management module, book information management module, lending information management module and administrator information management module. The reader information management part has two functions, which can browse and maintain the reader information. Book information management can browse and maintain book information. Borrowing information management can display the borrowing situation of books in the current database and maintain the borrowing information. Manager information management can display the manager's situation in the database and maintain the manager's information. It can be seen that this system is not complicated, and the main problem to be solved is to query the database with keywords.
background
In recent years, with the continuous expansion of the library scale, the number of books has also increased correspondingly, and all kinds of information about books have also multiplied. Faced with a huge amount of information, traditional manual management will lead to confusion in library management, excessive waste of manpower and material resources, and increase in library management costs, thus making the library overwhelmed and affecting the operation and maintenance management of the whole library. Therefore, it is necessary to formulate a reasonable, effective, standardized and practical book management system to centrally manage books and materials.
On the other hand, the IT industry and the Internet have developed rapidly, and computer applications have penetrated into various fields, which has caused a revolution in information management, realized the automatic processing of information, and improved the timeliness and correctness of processing.
Facing a large amount of modularized information, book management is an important position of information revolution today. The library management information system developed by our research group is to use modern information management mode instead of manual management mode to improve the efficiency of library management, realize standardized management, scientific statistics and quick query of information, and make the library better serve the school and society.
From the records of manual management in the past, we can find such problems:
1. The retrieval speed is slow and the efficiency is low.
Because there are many kinds of books in the library, it is very difficult to classify them accurately, search them quickly and operate them manually. Often the information of books is finally found, and there are no books in the library or they have been borrowed by others. The bigger the library, the more prominent this problem is.
2. The workload of borrowing and returning books is heavy.
The greater the frequency of borrowing and returning books, the greater the role of the library. However, the subsequent handling of a large number of books borrowed and returned, the renewal of existing books, and the overdue loss of borrowed books is too heavy for manual operation. And there are often such and such mistakes.
3. The book statistics work is difficult, and the book collection update cannot be completed in time.
The books in the library should be supplemented and updated in time according to the development of science and technology and the needs of teaching work. However, due to the increasing number and types of books, natural loss and man-made destruction, it is difficult to complete the statistical work of books in time, to update books in a targeted manner, and to control the knowledge structure of books well.
Emphasis and difficulty of system development
The system has the following technical difficulties:
1. Establish a reasonable table structure to avoid data redundancy.
Each table realizes the data connection of different tables through specific fields to avoid data redundancy, so it is necessary to design a concise and efficient table structure.
2. Establish considerable system security.
The design of login user authentication mechanism and the right protection of operation page.
3. Establish a strict data table operation mechanism.
The same table may be modified in multiple modules, so it is very difficult but necessary to establish a strict data table operation mechanism. In addition to considerable consideration in design, the reliability of program logic and the comprehensiveness of program debugging should be strengthened in compilation.
feasibility analysis
1. Technical feasibility
The development of this information system is a comprehensive application and improvement of university professional knowledge. Our team can complete the system development in the computer room on the fifth floor of Bishop. The computer configuration of this computer room can definitely meet the requirements of system development. Our team can choose two or three computers to set up a system development environment, mainly installing database tools (MS SQL SERVER 2000), application development tools (VISUL BASIC 6.0 or DELPHI), Office program groups and network transmission tools.
Some members of our team have computers of Pentium4 1.5G, with more than 256M of memory and more than 80G of hard disk, so they can surf the Internet. Team members can communicate instantly through QQ or telephone, coordinate development work and solve problems in development work.
As far as technical strength is concerned, our team can complete the development work. There will be many problems in the development process, some of which we expected and some of which we didn't expect, but we are confident to overcome all difficulties. This semester, all members of our team have studied SQL SERVER, and have a systematic understanding of network technology and operating system. Some members are familiar with computer principles and can solve common hardware faults and hardware selection. At present, library management information system has been widely used, and there are many successful systems for reference. And there is a lot of information about VISUL BASIC programming and SQL SERVER on the Internet. From a technical point of view, this information system is feasible.
2. Economic feasibility
The development requirements of the target system are relatively low. With a mature software and hardware environment, the expenditure on software and hardware is very limited. Moreover, the target system is not very complicated, the development cycle is short, and the economic expenditure of personnel is limited. After the system is developed and put into operation, it will greatly improve the functions of the computer, bring convenience to users and create conditions for the further promotion of the system. The economic return will far exceed the expenditure. The most important point is that the development of this software can give us a comprehensive understanding of the development of the system. From the economic point of view, it is feasible to develop this information system.
3. Legally feasible
Because the whole system is developed and used by itself, there is no legal copyright dispute in the system itself. In terms of server software, we should use genuine software, because although the whole system is developed internally, after all, many parts still rely on the Internet. Once the server is connected to the Internet, its operating system may be tracked by Microsoft. If it is not genuine software, it will face the risk of civil litigation.
Conclusion:
According to the above feasibility study, our team thinks that the conditions for developing the system are already met and we can start development.
Systematic investigation
General situation of library
Book management system is an indispensable part of library management, and its content is very important to both managers and users of the library, so the book management system should be able to provide managers or readers with sufficient information and fast data processing means. However, people have been using traditional manual methods for book management and lending management. This management method has many shortcomings, such as low efficiency, forgetfulness and poor confidentiality. In addition, a large number of documents and data will be produced after a long time, which will bring many difficulties to find, update and maintain. With the continuous progress of science and technology, computer science is becoming more and more mature, and its powerful functions have been deeply recognized by people. It has entered all fields of human society and is playing an increasingly important role. As a part of computer application, using computer to manage book information has incomparable advantages over manual management, such as fast retrieval, convenient search, easy modification, high reliability, large storage capacity, fast data processing, good confidentiality, long service life, low cost and easy printing. These advantages can greatly improve the efficiency of book management, and are also important conditions for scientific and standardized library management and integration with the world. Therefore, it is necessary to develop such a set of management software.
System function structure diagram
Demand analysis
System goal
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.
Demand definition
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.
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.
Function declaration
The system function analysis is completed on the basis of the overall task of system development. The system needs to complete five main functions:
A basic operation, 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, remark information, 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.
Processing library card module.
1. Freshmen apply for a library card.
I lost my library card.
C realized 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.
D 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.
E can query books conveniently. Prompt information can be given automatically after the deadline.
Performance requirements
Correctness, reliability, efficiency, integrity, ease of use, maintainability, testability, reusability, security, understandability, portability and interconnection.
Business flow chart (below)
database design
1. database requirements analysis
Users' needs are reflected in the provision, storage, update and query of all kinds of information, which requires the database structure to fully meet the output and input of all kinds of information. The process of collecting basic data and data structure processing forms a detailed data dictionary, which lays the foundation for the later specific design.
According to the requirements of general library management information system, the following data items and data structures are designed by analyzing the content and data flow of library management workflow:
Information about the reader type,
Attribute: category number, category name, book borrowing quantity, book borrowing period, validity period and remarks.
Primary key: category number
● Reader information,
Attributes: reader number, reader name, reader type, reader gender, work unit, home address, telephone number, e-mail, registration date and remarks.
Primary key: card reader number
● Book category information,
Attributes: category number, category name, keywords and comments.
Primary key: category number
● Book information,
Attribute: Book number, title, book category, author's name, publisher's name, publication date, book pages, keywords, registration date, and remarks.
Primary Key: Book Number
● Borrowing materials,
Attributes: borrowing information number, reader number, reader name, book number, title, borrowing date, return date, and remark information.
Primary key: borrowing information number
First of all, through the investigation and feasibility analysis of the system, the data flow chart of the system is drawn:
Basic information input basic information input
D 1 D2
Basic information input basic information input
D3 D4
D5
Borrowing information entry
Reader information return book information return
Data dictionary.
1, DD table of data stream is as follows:
data flow
System Name: Library Management Number:
Project name: reader information alias:
Source: Reader's place of registration: D3
Data flow structure:
Reader registration = {reader number+reader name+reader gender+work unit+...}
Brief description:
Modify record: date of writing
Audit date
2. DD representation of data elements is as follows:
Data element
System Name: Library Management Number
Project Name: Card Reader Number Alias
Belongs to data stream: reader registration storage: D3 reader information table.
Data element value:
Code type: character
Width: 10
Value range and meaning:
Brief Description: Each reader has a unique number.
Modify record: date of writing
Audit date
3. DD used for data storage is as follows:
Data storage
System Name: Library Management Number: D4
Project name: book information table alias:
Storage organization: number of records: about 3000. Key words: ISBN.
Data volume: about 500KB Auxiliary keywords:
Main index by number
Composition of records:
Field Name: Book Number, Book Title … Book Author … Keywords ...
Width: 1432 … 8 … 10 …
Brief description:
Modify record: Write: Date:
Review: Date:
4. DD used for data processing is as follows:
data processing
System Name: Library Management Number:
Project name: Loan information input alias:
Input: borrowing number, reader number … output: basic attributes of borrowing information table.
Processing logic: the borrowing information is stored in the borrowinfo table of the database.
Brief Description: Enter a reader's book borrowing record.
Modify record: Write: Date:
Review: Date:
2. Conceptual structure design of database
The entities included in this plan are: reader category information entity, reader information entity, book category information entity, book information entity and lending information entity.
E-R diagram of the relationship between entities
3. Database logical structure design
(1) Book Basic Information Table
Books:
Field Name Data Type Field Description
Bookid text saves the book number
Book name text saves the title of the book.
Book Type Text saves the type of book.
Book author text preservation saves the author of the book.
Bookpub, a publishing house that keeps books in words.
Book Publication Date/Time Saves the publication date of the book.
Bookpages digitally stores the pages of a book.
Bookkeyword text keyword
Scheduled date/time warehousing time
Is putup text borrowed?
Notes on book list
(2) Library card information table (reader information table)
Readers:
Field Name Data Type Field Description
Readerno text saves the reader number.
Readername text) to save the reader's name
Readersexttext) to save the gender of the reader.
Readertype text saves reader categories.
Readerdep text stores the reader's department.
The address text holds the reader's address.
Readertel text stores the reader's phone number.
E-mail text saves the reader's e-mail address.
Check Date Date/Time Borrowing Date
Reader's note
(3) Borrowing information table
borrowinfo:
Field Name Data Type Field Description
Borrow number for Borrowno text saving
The ReaderID text holds the reader ID.
The Readername text holds the name of the borrower.
Borrowing Date Date/Time Save the borrowing date.
Returndate date/time Save and return the book.
Memo remarks
(4) Book Classification Information Table
Book type:
Field Name Data Type Field Description
Book type No text to save the book classification number.
Typename text saves the category name.
Keywords text keywords
Memo remarks
5] reader classification information table
Reader type:
Field Name Data Type Field Description
No text to save the reader classification number.
Typename text saves the category name.
Booknumber keeps the number of books allowed to borrow.
Book day digital storage allows borrowing days.
User's complete life number saves professional ID.
Memo remarks
[6] User information table
User information:
Field Name Data Type Field Description
User_ID text holds the user ID.
The User_PWD text holds the user password.
User_Des text ...
The schematic diagram of the program module is as follows: (This diagram is for reference only)
pay attention to
System hardware requirements
In order to ensure the stable and high-speed operation of the library management system, it is necessary to add hardware and transform the existing hardware, and put forward the following hardware requirements. (Note: The hardware here refers to a complete hardware system, part of which contains the requirements for software, which is necessary for the normal operation of the management system. )
I. Requirements for servers
The central processing unit (CPU) of 1. server is recommended to use PIII 1G (above) Xeon processor chip.
2. The server memory must use the ECC memory dedicated to the server.
3. In order to ensure the absolute reliability of data storage, the hard disk should use a redundant array of disks (RAID 0 1).
4. In order to prevent the server from unexpected failure or the impact of regular maintenance on the company's overall business, it is recommended to use two servers. Two servers should constitute a dual-machine hot backup. The watchdog circuit is used in the middle. This structure can ensure that the whole system can work continuously for a long time, even when the server is regularly maintained, another backup server can be used to work.
5. The server should support hot plug power supply.
6. The server must be equipped with UPS (Uninterruptible Power Supply).
7. The server should be placed in the school. Otherwise, the program cannot be debugged.
8. The server should have a fixed IP address.
9. Other performance When economic conditions permit, try to use high-speed and stable accessories.
Second, the software that should be equipped on the server.
A) Operating system: Microsoft Windows 2000 server or Microsoft Windows 2000 advanced server.
B) database: Microsoft SQL Server 2000 (simplified Chinese version)
C) The server must use professional firewall and antivirus software.
D) It is recommended not to install other irrelevant programs on the server as far as possible, except for the programs that must be equipped in order to run, so as to reduce the confusion of programs or accidental conflicts of programs.
E) The operating systems of all departments should be unified as much as possible. (Windows 9x series or Windows 2000 series). This can avoid the extra overhead caused by inconsistent operating system versions when the management software comes out.
F) Anti-virus software and firewall must also be installed on the machines of all departments. To prevent worms on the network from spreading throughout the network.
G) If you want to print reports involving multiple fields, you should be equipped with a stylus printer.
Network design (as follows)