349VB1009 periodical Loan Information Management system

Program development software: VB6.0 database: sqlserver2000 (can support 2005/2008 at the same time)

The project of this design system is "periodical Information Management System", which is always confronted with a large number of readers ' information, periodical information and the borrowing information produced by the interaction between them in normal operation, and also the periodical information. Therefore, it is necessary to manage readers ' resources, periodical resources, borrowing information and periodicals information, and to understand the change of information in various links in time, which is helpful to improve management efficiency.
This system is used as a development tool in Visual Basic 6.0 (hereinafter referred to as VB). It is an object-oriented, graphical, interactive development tool developed by Microsoft Corporation that can be applied to client/server (c/s) mode. VB has a powerful integrated development environment, flexible and high efficiency in application development. The database uses SQL Server 2000, and the database provider uses ActiveX Data Objects (ADO).

The management of periodical information Work's own characteristics and special nature, relying on manpower alone, will be engaged in the work of managers over-burdened in the cumbersome business, will inevitably occur many mistakes, difficult to achieve the standardization of management, this does not meet the future development trend of management work. Therefore, the need to develop a full-featured, simple operation of management system software to assist the role of human-machine cooperation, to enable the machine to undertake part of the work, is the administrator gradually get rid of some meaningless, trivial business, which makes full use of the leading role of human resources and make the management work gradually into the standardized track has important significance.

System Data Analysis
(1) The overall task of system development is to realize the systematization, standardization and automation of all kinds of information.
(2) The periodical information can be registered, that is, the basic information of the periodical (such as: ISBN, Mail code, year, month, journal name, price, etc.) pre-deposited into the database, a total of subsequent searches.
(3) To register the basic information of the reader, including information such as reader number, name, department, number of borrowed periodicals, etc.
(4) Records each time the borrowing also behavior, mainly includes: ISBN, reader number, borrow period, the period, whether contains the disk.
(5) Provide convenient method of inquiry. Such as: It is easy to find out all the periodical borrowing records of a reader and the current loan of a periodical is also information.

system function Analysis
According to the above functions, the data of the periodical information Management system are divided into:
A, the data input part, mainly includes the periodical basic information entry, the reader basic information input.
b, the data output part, is mainly a variety of statistical inquiries, including: Reader information query, periodical information query.
C, the data processing part, mainly related to the periodical loan and the return processing, if a periodical loan, must mark the periodical in the database as already lent; Once a periodical has been returned, it must also be marked as returned in the database in order to be loaned again.

349VB1009 periodical Loan Information Management system