Experimental Name: Book Management System
School: School of Electronic Science and Information Technology
Major: Information Security Major
Last name:
Student number:
Grade: Class 05, 1.
Teacher:
July 2008 16
abstract
This design report mainly introduces the design process of developing a small database system-book management system by using database development tool ASP.NET. In the database system development tool, ASP. NET has a good man-machine interface and a reasonable database structure, and it is a visual and object-oriented rapid development tool.
This paper analyzes the relationship between the functional modules in book circulation in detail, and introduces the whole design process of library service subsystem in detail. The specific functions are as follows:
1. Book query: realize the accurate query of all books in the library.
2. Borrowing books: complete the borrowing of designated books by students.
3. Personal borrowing information query: complete the query of the personal borrowing records of the designated students, and display the information of all books borrowed by the students.
4. Book return: complete the return of the designated books borrowed by students.
5. Return of overdue books: In case of overdue, prompt information can be automatically given.
6. Book management: basic operations such as book entry, modification and deletion can be realized.
ASP.NET has a completely object-oriented brand-new visual programming environment, which provides convenient and fast Windows application development tools. It adopts many advanced features and design ideas of Microsoft Windows graphical user interface, flexible and reusable completely object-oriented programming language, the fastest editor and the most advanced database technology in the world today, so I choose ASP.NET as the development tool of my graduation project.
This paper introduces the design and implementation of a university library management system based on B/S mode. The login module is developed by ASP.Net and Microsoft SQL Server 2000, which is mainly used to verify the user's identity and operate effectively. After the verification is passed, the interface module enters each sub-module to perform specific functional operations of each subsystem. The whole system design makes full use of modular design ideas and development methods.
This paper first briefly introduces the background of the system, then analyzes the detailed requirements of the system and determines the functions that the system should have. After determining the functions that this system should have, we design the whole system, determine the best solution, then code and realize the functions of this system, and finally discuss the testing and maintenance of this system.
Keywords ASP.NET SQL 2000 database object property form B/S course design
Software design description of book management system
I. Feasibility study:
The book management system provides a better solution for government agencies, enterprises and institutions to realize work automation. In the development process, according to the steps of software engineering, object-oriented ideas and technologies are adopted from design to development, and SQL SERVER 2000 network database is adopted, so that the system can easily exchange data with other subsystems. At the same time, pay attention to optimize the software quality from the graphical application interface of the software, so that the system has strong operability.
Two. Demand analysis:
1. Task overview:
1. 1 target:
Daily business needs of book information such as book storage, loan registration, loan inquiry and expiration prompt. Efficiency Through the practicality of the system, the old book management mode can be changed, making the management, borrowing and inquiry of books more convenient and effective.
1.2 Operating environment:
Under the Windows 2000/XP/2003 operating system, install and configure the software Microsoft SQL Server 2000 database management system.
2. Data requirements:
2. 1 data stream entry:
Login user = account number+password user = user account number+name+gender+group number+certificate number.
Book = book number+category+title+author+publication date+publisher+pricing+storage location.
Borrowing = user account number+book number+borrowing date+expiration date.
Borrowing information = user account number+book number+borrowing date+expiration date.
2.2 data dictionary (DD):
2.3 database description:
Using SQL SERVER2000 as the background database, user authentication based on network connection can be realized. Therefore, subsystems allocate the right to use databases, so that the databases they use are isolated from each other, thus achieving higher security.
2.4 Data acquisition:
Collect some books related information from the website through the Internet and enter it into the database, so as to establish the database, and test the realization of each functional module in the coding and debugging stage.
3. Functional requirements:
3. 1 Function division:
The book management system mainly realizes the following seven functions:
A. User logs in B. Inquires about the detailed information of books C. Borrows and returns books D. Stores books.
E. Modification and deletion of books F. Prompt for overdue books G. Query the borrowing information of users.
3.2 Function Description:
Book management includes seven functions: user login, book details query, borrowing and returning, warehousing, maintenance, overdue prompt, and user borrowing information query.
When logging in, users must use the correct user name and password to access.
Query the detailed information of books: enter the book name or book number to query the book information.
Book lending, book lending registration; When users want to inquire about their own loans, they can inquire about loans.
Book warehousing mainly realizes warehousing registration.
Book modification and deletion, realize the function of modifying and deleting some book information.
Prompt that the borrowing of books is overdue. When the borrower fails to return the books after the borrowing period has expired, prompt him to go through the return procedures as soon as possible.
Query user borrowing information, you can query user borrowing book information.
3.3 Data Flow Diagram (DFD):
New book storage DFD:
D 1 inventory list
D 1 inventory list
DFD of book lending:
DFD of expired prompt:
Loan inquiry of DFD:
DFD of book return processing:
D 1 inventory list
4. Safety requirements:
Considering that different users have different rights, when entering the system for the first time, you should apply to the administrator to register a user name and password, and fill in the relevant information completely and store it in the database table. In this way, administrators can give different users different permissions. Each user enters a different user interface according to his own identity. Administrators have the right to exercise all management functions, and ordinary users can only make general inquiries.
5. Consistency requirements:
There is a strong correlation between the tables related to the book management system. In order to meet the requirements of consistency, we establish consistency constraints between tables.
6. Integrity requirements:
According to the requirements of library management system, in order to maintain the integrity of data, the transaction mechanism of database is adopted to prevent operational failure.
Three. General design specification:
1. Overall design:
Overall structure and module external design:
1. System flow chart:
2. Interface design:
2. 1 external interface:
The server system is established through certain computer hardware, and the administrator interacts with users through the management server system to achieve the purpose of resource sharing and realize the book management system.
2.2 Internal interface:
Programs need the same data definition and description. This system is a subsystem of intelligent office management system. It must be unified with other subsystems of this system to achieve the best performance of the system, and try to eliminate data redundancy with other subsystems, so as to make the whole intelligent office system efficient and convenient.
3.E-R diagram
E-R diagram clearly describes the relationship between entities in the system and the attributes of each entity, which can make readers clearly understand the overall processing situation of the whole system. In the process of establishing E-R diagram, it mainly goes through the following steps: 1 Select a local application; 2. design E-R diagrams one by one; 3. Combine partial E-R graphs to generate a preliminary E-R graph; 4. Eliminate unnecessary redundancy and design the basic E-R diagram.
4. Operation design:
4. 1 combination of running modules:
The running module is divided into three basic modules, namely, input module, output module and processing module. This makes the maintenance of the whole system easy and simple; The system is simple in structure and easy to understand.
4.2 Operation control:
The system uses three main control modes: sequence, selection and cycle.
5. Safety design:
Considering that different users have different rights, when entering the system for the first time, you should register a user name and password with the administrator, fill in the relevant information completely and store it in the database table. In this way, administrators can give different users different permissions. Before the user logs into the operation interface, we set the user name and password. When the username and password match, we can enter the permission operation interface that the user is allowed to do. Otherwise, you can only see that the login interface administrator has the right to exercise all management functions, and ordinary users can only make general inquiries.
Four. Detailed design:
1. database table
Authority: (authority, name)
Login user: (account number, name, password, authority)
User: (user account number, name, gender, group number, ID number)
Book category: (category, class name)
Books: (book number, category, title, author, publication date, publisher, pricing, total quantity, remaining quantity, remarks)
Borrowing: (user account number, book number, borrowing date, expiration date, quantity, book return date)
Borrowing information: (user account number, book number, borrowing date, expiration date, quantity, book return date)
2. Computer software configuration
Windows 98/ Windows XP/ Windows 2000/ Windows 2003;
Verb (abbreviation of verb) coding and implementation;
Binding language
After having a basic understanding of the development process of management information system, I developed this "book management system" with ASP.NET. The system basically realizes the systematization, standardization and automation of internal book lending management. For example, register account books and destroy old books. Add borrowers and cancel borrowers. Borrow and return books. You can query books according to information such as book name or book number, which can reflect the borrowing situation of books. A simple statistical analysis function is realized, which can show the ratio of books in collection to books borrowed and the types of books in collection. And you can set borrowing rules.
Through the design, development and debugging of the system, on the one hand, I understand the development process and method of the book management system; On the other hand, I have mastered the use of ASP.NET development tools, and I am familiar with the use of windows, menus and some visual controls. At the same time, many problems and difficulties have been encountered in the production process, which has been greatly helped by consulting books and the Internet.
Because of the limitation of conditions, there are still many shortcomings and loopholes in the management system, which can only be corrected and improved as far as possible. Disadvantages, please give some advice.
It has been sent to your email address SN 170.