Ñîâðåìåííûå èíôîðìàöèîííûå òåõíîëîãèè/ 3. Ïðîãðàììíîå
îáåñïå÷åíèå
Gevel A., Zavitova T.Y.,
Lifenko V.M.
Kostanay State University, Kazakhstan
Automated
complex "Educational subscription" software
Abstract: In the article
description of control system is given by the infobase of data
"Educational library subscription", that allows to unite, assort and define
the information about a reader fund and demand on literature.
Keywords: information
database, software, management system.
Introduction: Automation of
functioning of library subscription not only promotes economic efficiency of
educational establishments but also influences on quality of mastering of
information and level of preparation of specialists. For this purpose software
is developed for libraries.
The proposed
program object management database (DB) is implemented in Delphi on
SQL-platform and includes options Borland Database Engine and Borland SQL Link,
so access to the database management system Oracle, Sybase, Informix and
InterBase is featured by high efficiency [1,2].
Functional
possibilities of the program: Entrance information in the worked out program are
data about readers (last name, name, patronymic, address of residence, contact
telephone number) and about literature (code, name, author, genre, year of
edition, presence in a fund, amount of copies).
Output
information of the program is
represented as a well-organized table in Microsoft Excel with a selection:
"on present literature", "on a genre", "on the date of
reception of books", "on notification". Literature being in a
presence is specified the fund of library grouped on genres and the amount of requested
copies, and is represented in a report, and also is formed the list of readers visiting a library and with the untimely return of literature.
Components
of the program: The main menu contains all the necessary tools to manage the project
with used components such as: TStatusBar, TGroupBox, TtoolButton, TBitBtn,
TEdit,, TStringGrid, TLabel, TTimer, TChart. Main menu options provide access
to the second level drop down menu.
Basic procedures and
functions:
procedure TForm6.BitBtn1Click
(Sender: TObject); - fragment of program code adds a new literature into the main
form.
procedure TForm2.BitBtn4Click
(Sender: TObject); - removes literature from the database.
procedure TForm2.Button1Click
(Sender: TObject); - searches for literature.
procedure TForm2.BitBtn6Click
(Sender: TObject); - removes data reader.
procedure TForm9.BitBtn1Click
(Sender: TObject); - stores the database.
User's guide: For the start of the program
the file of Project1.exe. is activated. An operation "Load" allows to place file data in a table (Picture
1). A function "Search", is carried out with "On the name",
"On an author", "On the year of edition". (Picture 2).
Picture 1. Basic
window of the program with high-usage data
Picture 2. Search
of literature
By means of the buttons «Delete"
and «Save" the operations of moving away of literature will be realized
from DB and maintenance of DB in a file.
By means of the button
"Move", the list of literature is carried in the personal card of
reader. There is possibility to produce the selection of literature and readers
on different criteria. Button "Create a report", allows forming a
report on a selection as a well-organized table in Microsoft Excel. For an exit from an appendix it is
necessary to activate the button "Close".
Realization of control system by
informative DB gives an opportunity to automatize registration of the personal
card of reader and its search, control a library fund and consumer demand, form
the list of active readers or assuming violation on the term of the use of
literature.
Conclusion: The worked out
program allows to promote efficiency of maintenance of consumers the special
literature on a paper carrier and optimize organization of educational process.
Literature
1. Practical Programming Guide. Translated from English.
B. Mick, P. Heath, H. Rabshi etc. - M.: Radio and Communications 1986
2. Sorokin AV \ Delphi. Database Development \ \ St. -
Petersburg, 2005.