| With the rapid growth of information society, the original manual of information management can no longer meet the real needs of society. To this end, how effective management of existing resources, has become one of the main issues to be resolved and social development.Unemployment Insurance Division of Employment Tongliao city (including nine banner) nearly 500 units, 100,000 people in the information management of unemployment insurance and unemployment insurance are paid. Little information previously, the basic manual used by the district each banner management, summary statements for the Council. With the rapid growth of insurance and insurance units, manual management has been far from satisfying the operational requirements of the day-to-day management of information and the dissemination of insurance management and the statements are all collected excessive workload, the low rate of accuracy, efficiency is not high and many other issues. To this end, employment in Tongliao City Board electronic management needs to replace the manual management of computer management, improve management and timely information to improve the rate, accuracy, integrity rates.The design of the database management system to conduct in-depth research and current employment Tongliao City Council to conduct an objective analysis of the business needs and create a framework model for the design. Design details will then become the framework of five subsystems (caretaker management subsystem, unit information management, personal information management system, an annual management system, database management subsystems, etc.), each subsystem to improve the form, Form, financial statements and other content, form the entire management system. According to the unemployment insurance management mechanism, the basic demand of the unemployment insurance system is based on single version of the operating management, it is this thesis through VFP database development tool developed by the management system. The basic design idea is : First, the creation of a unit based on the information insurance information unit, according to the personal information of insured persons unit, there is a certain correlation between the two. Through the program was designed to enable managers of the two tables can be any management operations (such as : an increase, edit, delete, statements, statistics, etc.), the system automatically forms the link between operations and management to achieve the purpose computer. In addition, the management information of a personal insurance expired automatic reminders functions, improving the level of automation in the management of unemployment insurance.The graduation design aims to achieve the following functions :1, can be ESD logging, the management information base (MIB including units and personnel information database).2, database management information to each and every detail, including specific information increases, modify, delete and search operation.3, individual insurance money expired messages are clear signs.4, the branch of standardized template synthesis of information, management problems exist.5, generating statistical reports, system functions can be achieved.6, the system can automatically check the wrong message.7, the annual insurance information preservation phase, and future maintenance and operation management.8, could be conducted in accordance with the needs of database backup and restore operations.9, the database portability, a higher-level management needs of different statements for DBF format, XLS, and other formatted text format conversion.10, concise interface, fast and user-friendly.The whole system from Table 4, Form 8, the two statements, the two menus :Table 4 were :①store managers for information ccipt.dbf;②danwei.dbf information storage unit;③to store personal information ren.dbf;④year.dbf annual information storage.Form 8 were:①Form login.scx download manager, whose main function is to ensure that users can access authority, the right to prohibit users download.②Form danwei.scx information management unit, whose main function is to visit units of information, increase, modification, deletion.③Information Form dwseach.scx unit, whose main function is a unit of information inquiries and printing.④Form luru.scx personal information management, its main function is to achieve personal information browsing, increase, modification, deletion.⑤Seach.scx Personal Information Form, and its main function is to achieve personal information query, and print.⑥Copyright copyright.scx Information Form, and its main function is a statement of copyright information to provide products and author information.⑦Management Form year.scx year, the main annual information to add, delete, change, etc..⑧Form hecheng.scx database management, data backup and restore main table synthesis.Two statements were :①Information tables danwei.frx insurance unit, whose main function is the statistical and other information units.②Ren.frx insured personal information tables, and its main function is the statistical statements and other personal information.Two of the menu :①Insurance information unit operated Form danwei.mnx;②Form ren.mnx insurance operation and management of personal information.With the successful completion of the above functions of the design process, according to actual needs, the system operators in the classification management, system optimization statements on the effective attempt to achieve the desired results.The unemployment insurance system is a computer-based database management system, which can save humanity from the heavy and monotonous labor plots were freed, improve labor efficiency and information database for the accuracy, completeness and timeliness.With the continuous development of society, will be more widely used database management system. Network-based, distributed database management systems will become mainstream. Therefore, in future work to study, I will gradually transform the existing system based on the network model for database management systems to ensure that they meet the broader and stronger overall. |
