With the rapid development of information technology, especially the development of database technology, computers have become a key tool in the information age. Database technology is an important part of computer application technology. For a large amount of data, it is more efficient to store and manage it with a database than with a file. After several generations of changes in database technology, a database era with relational database products as the mainstream has emerged. Access 2000 is a relational database product launched by Microsoft. As one of Microsoft's office suite products, Access has sold nearly 7 million copies, making it the most popular desktop database system in the world. Access, like many excellent relational databases, allows you to easily connect related information and supplement other database systems. As a "sharp weapon" for application development, Visual Basic is also manifested in the development of database applications. Its good interface and powerful control function make database programming easier. Visual Basic provides powerful database access ability, which organically combines various advanced functions of Windows with powerful database management functions.
This graduation project-personnel management system is designed and developed by using ADO technology, and a large number of SQL statements are used to add, query and delete. This system uses Access 2000 as the background database, and uses the database development platform provided by Visual Basic 6.0 to develop the foreground part.
Chapter II System Requirements Analysis
Section 1 Introduction of System Design Background
Management information system is what we often call m is (Management Information System), which is becoming more and more popular in the modern society that emphasizes management and information. Combining information management system with enterprise automation equipment is the development trend of modern enterprises in today's society. Through this management method, employees in various departments such as managers, technicians and statisticians can be freed from a large number of tedious materials and data, and only need to deal with the data and content they need, without knowing everything in each link. This can save manpower and material resources to a certain extent, and greatly enhance the timeliness and accuracy of data processing.
The content of this development-personnel management system is an example of the combination of information management and modern office equipment. The development of this system hopes to liberate personnel management personnel from the work of entry, calculation and statistics year after year. Due to the large number of personnel data, it is extremely inconvenient to input and count, and the amount of input and calculation is large. It will be time-consuming and laborious to complete these tasks by manpower, and it is easy to make mistakes and omissions. After inputting information once, the system can be reused in different information bases. All input information will be classified in detail by department, major, attendance date, pay date, etc. , so that customers can manage according to their own needs.
Therefore, the purpose of this management system is to use computers to store and process complex data, and use the connection between computers and modern office equipment to refresh data in real time, thus improving the work efficiency of enterprises.
Section 2 System Function Analysis
The heating network management system mainly has the following functional requirements:
* according to different permissions login system.
* Add, query, modify and delete the department information provided by them.
* Add, query, modify and delete the personnel information provided by them.
* Add, query, modify and delete the attendance data provided by them, and classify them by attendance month.
* Add, calculate, query, modify and delete the salary information provided by it, and classify it by salary month.
* You can add a new user, modify the user's original username and password, and delete the original user.
......
Section 1 System Design
3. Functional analysis of1.1system
* according to different permissions login system.
* Add, query, modify and delete the department information provided by them.
* Add, query, modify and delete the personnel information provided by them.
* Add, query, modify and delete the attendance data provided by them, and classify them by attendance month.
* Add, calculate, query, modify and delete the salary information provided by it, and classify it by salary month. As far as courses are concerned: course credit inquiry system
I. Introduction
The necessity of establishing a new system.
In the teaching process of the school, the recruitment and inquiry of grades is a daily work, and the school's academic staff need to recruit the relevant information of students' grades in time so that students can find their own personal grades in time and effectively.
In this school, due to the large number of students and courses, it is not timely to manually hire or count the students' course scores, so it is necessary to establish a course inspection system. In the teaching process of the school, the operation of the academic affairs office is the same as that of the students, which saves a lot of time for the academic affairs office and brings convenience to the students.
2) The goal of system design
The Academic Affairs Office allows teachers to input students' course scores by themselves, and students can input and query their own related scores through the computer course search system and print them out.
Second, the system analysis
2. 1 Analysis of organizational structure and functions
Organizational structure and function analysis is the simplest part of the whole system analysis. Organizational structure and function analysis mainly includes three parts: organizational structure analysis, relationship analysis between business process and organizational structure, and business function list. Among them, the analysis of organizational structure is usually realized through the organizational chart, which depicts the organizational structure learned from the investigation in detail on the chart as a reference for subsequent analysis and design. The analysis of the relationship between business process and organizational structure is usually realized through the business and organizational relationship diagram, which uses the information obtained from system investigation to focus on the analysis of the relationship between management business process and organizational structure, and is the basis for subsequent analysis and design of new systems. The business function list lists all the management business functions in an organization in the form of a table, which is the basis for future function/data analysis, determination of management functions to be realized by the new system, analysis and establishment of management data index system.
A. description of data flow
1. data stream number: A-0 1
Data Stream Name: Course Summary Table
Introduction: The course introduction entered by the teacher.
Source of data stream: teachers
Data flow: educational administrators
Composition of data stream: course number+credits+teachers+class hours.
Data flow: 100 sheets/day
Peak flow: 500 sheets/day
2. Data stream number: A-02
Data stream name: curriculum
Introduction: the curriculum schedule output by the educational administrator
Source of data stream: educational administrators
Data stream: students
Composition of data stream: course number+credits+teachers+class hours.
Data flow: 100 sheets/day
Peak flow: 500 sheets/day
B. Processing logic description:
1. Processing logic number: B-0 1
Processing Logical Name: Course Introduction Entry
Introduction: Teaching will introduce the courses taught by itself.
Input data stream: course introduction table
Description: According to the course information, the teacher enters the course introduction and submits it to the educational administrator for review.
Output data stream: course introduction table
Processing frequency: 200 sheets/day
2. Processing logic number: B-02
Processing Logical Name: Generate Curriculum Schedule
Introduction: The educational administrator makes the curriculum schedule according to the teacher's curriculum introduction table.
Input data stream: course introduction table
Note: the educational administrator makes the curriculum schedule according to the teacher's curriculum introduction table.
Output data stream: curriculum
Processing frequency: 200 sheets/day
C. description of data storage
Data storage number: C-0 1
Name of data storage: curriculum
Description: Detailed information about the course.
Composition of data storage: credits+class hours+teachers+course name+course number.
Keywords: course number+credits
D. description of external entities
1. External entity number: D-0 1
External Entity Name: Teacher
Description: School educators
2. External entity number: D-02
Name of external entity: student
Description: The main part of the school, the most important part.
3.3 System operating environment design (software and hardware)
System running environment design (software and hardware)
A. software environment:
Client: Windows2000, Windows2003, Windows XP.
Server: WindowsNT/Windows2000 and above operating systems.
Programming language: SOL
Database: Access2003
Hardware environment:
There are high-performance electronic computers, large-capacity storage devices, personal computers (terminals) and connected network cables. , thus forming a computer network sharing information resources, printers, scanners, etc.
3.4 Data storage design
1) Teachers submit scores of all subjects to the Academic Affairs Office, and staff record the scores to form a database system.
2) Students can use the computer grade inquiry system.
3) Teachers have the right to update and maintain their systems, and students can query and print their grades.
Answer, supplement, continue