A software package for automating the activities of the district division of the bailiff service.
Software package developed as part of the implementation of the automation concept of the Main Directorate of the Ministry of Justice for St. Petersburg and the Leningrad Region.
Project goal
Automation of accounting enforcement proceedings divisions of the bailiff service, automation of enforcement actions of bailiffs; maintaining a service deposit account; office automation; formation statistical reporting about the operation of the service.
Project implementation
The complex is designed taking into account the requirements Federal Law on enforcement proceedings dated 07/21/1997 and the Instructions for office work of the Ministry of Justice of the Russian Federation, approved by order No. 174 dated 05/21/1999.
Development environment - Borland Delphi 5.0, as software server The database is used InterBase 6.0.
The complex includes five automated workstations.
Purpose of workstations
WORKSHOP "SECRETARY": automation of accounting and registration of enforcement documents and enforcement proceedings initiated on their basis; generation of reports to higher authorities.
AWS "CASE PRODUCER": automation of accounting and registration of incoming and outgoing mail, complaints, applications and appeals from citizens.
AWS "ACCOUNTANT": automation of accounting movements cash on a deposit account district unit SSP; automation of accounting of fixed and material and technical assets
AWB "BAILFICER": automation of accounting for execution of enforcement actions by a bailiff prescribed by a writ of execution and generation of official documents for execution.
AWARD "SENIOR BAILIFF": automation of management of the activities of subordinate services.
This report is taken from the website
The “Employees” database was created in access 2010 and converted to access 2003, therefore it will open in different versions: access 2010, access 2007, access 2003.
The data schema of the “Employees” database includes the tables “General Information”, “Education”, “Contacts”, “Documents”, “Family Composition”, “Places” previous work”, “Military registration”, “Units”, “Types of education”, “Forms of education”, “Citizenship”, “Nationalities”, “Marital status”, “Positions”, “Ranks”, “Degrees of relationship”, “Composition of those liable for military service ":
Structure of the table “Military registration”: personnel number, reserve category, rank, composition (profile), military training system, suitability, name of the military registration and enlistment office, mark of withdrawal.
Structure of the “Documents” table: code, personnel number, document, series, number, date of issue, by whom it was issued.
Structure of the “Contacts” table: personnel number, country according to passport, region according to passport, region according to passport, populated area according to the passport, address according to the passport, actual country, actual region, actual district, actual locality, actual address, phone number.
Structure of the table “Places of previous work”: code, personnel number, entered, quit, type of activity, reason for dismissal, reason, position, organization.
Structure of the “Education” table: code, personnel number, type of education, educational institution, qualification according to the document, specialty according to the document, form of study, admission date, graduation date, diploma.
Structure of the “General Information” table: personnel number, department, position, date of admission, date of dismissal, last name, first name, patronymic, gender, photo, citizenship, nationality, date of birth, country of birth, region of birth, district of birth, locality of birth, marital status, PFR insurance certificate number, medical policy number, TIN.
Structure of the table “Family Composition”: code, personnel number, last name, first name, patronymic, date of birth, degree of relationship.
Forms and reports:
This report is taken from the website
Download the ready-made database data access"Employees"
Password for the Employees database
Other ready-made access databases
Download the “Employees” database (DB) MS Access Download the “Employees” database (DB) MS Access
Download the database (DB) Spіvrobitniki Download the database (DB) Spіvrobitniki
Download the database (DB) “Human Resources Department. Calculation of employee shifts" MS Access Download the database (DB) "Human Resources Department. Calculation of employee shifts" MS Access
Download the database (DB) “Human Resources Department” MS Access Download the database (DB) “Human Resources Department” MS Access
Download the database (DB) “Staffing table” MS Access Download the database (DB) “Staffing table” MS Access
Download the database (DB) “Plant Personnel” MS Access Download the “Plant Personnel” database (DB) MS Access
Download the database (DB) “The work place of the health worker for personnel at the plant” MS Access Download the database (DB) “The work place of the health worker for the personnel at the plant” MS Access
Download the database (DB) “Workplace of a private accountant” MS Access Download database (DB) “Workplace of a private accountant” MS Access
Download the database (DB) “Population records” MS Access Download the database (DB) “Population records” MS Access
Download the database (DB) “Accountant's Workplace. Formation calculation sheets employees" MS Access Download database (DB) "Accountant's workstation. Formation of employee payslips" MS Access
Download the database (DB) “Workplace of a private accountant” MS Access Download database (DB) “Workplace of a private accountant” MS Access
Download the “Salary” database (DB) MS Access Download the “Salary” database (DB) MS Access
Download the database (DB) “Functions of an accountant of a private enterprise” MS Access Download the database (DB) “Functions of an accountant of a private enterprise” MS Access
Download database (DB) Calculation of wage deductions Download database (DB) Calculation of wage deductions
Download database (DB) Contacts (by template) Download database (DB) Contacts (by template)
Download database (DB) telephone exchange Download database (DB) Telephone exchange
Download the database (DB) Polyclinic Download the database (DB) Polyclinic
Download database (DB) University Download database (DB) University
Download the database (DB) containing information about the registration of residents in the housing office. Download the database (DB) containing information about the registration of residents in the housing office.
Download the database (DB) containing information about the registration of children in kindergarten/nursery. Download the database (DB) containing information about the registration of children in kindergarten/nursery.
Download the database (DB) containing information about the registration of hotel clients. Download the database (DB) containing information about the registration of hotel clients.
Download the database (DB) “Registration of conscripts at the military registration and enlistment office” MS Access Download the database (DB) “Registration of conscripts at the military registration and enlistment office” MS Access
Download the database (DB) “Registration of marriages and newborns” MS Access Download the database (DB) “Registration of marriages and newborns” MS Access
Download the database (DB) “Voluntary health insurance” MS Access Download the database (DB) “Voluntary health insurance” MS Access
Download the database (DB) “Economy” MS Access Download the database (DB) “Economy” MS Access
abstract
This work outlines theoretical foundations building an automated workstation for a senior bailiff, an automated version of a database and an application using the data was proposed. User instructions for working with the software are provided. The economic and legal issues of using the developed software product.
list of keywords
Automated workstation
Database
Client-server
Model
Resolution
Forced drive
Software tool
Design
Bailiff Service
Bailiff
CONTENT
INTRODUCTION 6
1. PRINCIPLES AND ALGORITHMS FOR CONSTRUCTION OF AN AUTOMATED WORKSTATION FOR SENIOR BAILFICER 13
1.1. Description subject area 13
1.2. The nature of the interaction of the informatization object with external environment 17
1.3. System development and design process 21
1.4. Building an information and logical data model 26
1.5. Development of a datalogical data model 32
Conclusions 45
2. SOFTWARE IMPLEMENTATION OF AN AUTOMATED WORKSTATION FOR A SENIOR BAILFICER 46
2.1. Life cycle automated workstation for senior bailiff 48
2.2. Selecting an application development environment 50
2.3. Using client-server architecture 51
2.4. Software implementation databases 54
2.4.1. Using Query Language 55
2.4.2. Data access mechanisms 58
2.5. Securing an Application 60
2.6. Architecture software tool 62
Conclusions 67
3. ANALYSIS OF THE QUALITY OF DEVELOPED SOFTWARE 67
3.1. Quality indicators of the developed software product 68
3.2. Test results 72
3.3. Suggestions for improving the quality of the software product 75
Conclusions 75
4. ERGONOMICS OF THE CREATED SOFTWARE PRODUCT 76
4.1. Ergonomics of the created software product 77
4.1. Safety precautions when working with computer equipment 81
Conclusions…………………………………………………………………………………..89
5. ECONOMIC AND LEGAL ISSUES IN THE DEVELOPMENT AND USE OF THE CREATED SOFTWARE 89
5.1. Economic indicators 89
5.2. Legal status developed software product 91
Conclusions…………………………………………………………………………………..96
6. DISCIPLINE PROGRAM “SOCIOLOGY” 96
CONCLUSION 110
INTRODUCTION
Currently, the activities of organizations directly depend on awareness and the ability to effectively use available information. To do this it is necessary to carry out great job on collecting, organizing, processing information, as well as its analysis. With a large amount of information, such work becomes very labor-intensive and requires large quantity time and human resources.
Use of modern computer technology makes this task easier. The computer plays the role of an amplifier of the intellectual capabilities of a person and society as a whole, and communication tools integrated with computers serve to communicate and transfer necessary information. The introduction of computer technologies can significantly increase labor productivity and reduce costs.
