Summary design manual
Fan Yongwei
1. Introduction
1.1 Writing
In the previous stage of the human resource management system project, it is in the demand analysis phase, and the system user has made detailed description of the demand of this system. These user needs have obtained the company and customer field research in the previous stage. And in the demand specification specification, detailed narrative and clarification.
Based on the analysis of the system's demand analysis, it is a summary design of the human resource management system. It mainly solves the design problem of program module implementing the system requirements. Includes how to divide the system into a number of modules, determine the information between the interfaces between each module, the information transmitted between the modules, and the design of the module structure, etc. The following summary design reports will be described in detail in this stage.
In the detailed design of the next phase, the program designer can refer to this profile design report, on the basis of the module structure design made by the Human Resource Management System, in the professional design of the module structure design made by the Human Resource Management System. This manual can also be refer to this manual in the future software test and software maintenance phase to facilitate the design structure of each module completed during a summary design, or find out or errors in this stage design during modification.
1.2 project background
This project (Human Resource Management System) is entrusted by Shanghai Lock Electromechanical Company, which is responsible for development by the seventh development group.
The Human Resource Management System will consist of two parts: a front desk client placed in the management, and a database server placed in the company. The relationship between the system and other systems is as follows:
: (Locke Electric Company)
Finance department
Server and program
1.3 definition
1.3.1 Specialized terminology
SQL Server: The Database Management System (DBMS) used by the System Server.
SQL: A language for accessing the query database
Transaction stream: There may be multiple paths after the data enters the module.
Primary key: Key fields in the database table. The value is different from each other.
External primary key: Domain associated with other table primary keys in the database table.
Rollback: The error recovery mechanism for the database.
1.3.2 abbreviation
System: If it is not particularly pointed, it is not particularly referred to.
SQL: Structured Query Language (Structured Query Language).
ATM: Asynchronous Transfer Mode (Asynchronous Transfer Mode).
1.4 Reference
The information used in the summary design process is listed below:
1. Demand Specifications "" Software Development Group 1999/3
2. User Operation Manual (Premier Draft) "" Software Development Group 1999/4
3. Software Engineering and Its Application Zhou Su, Wang Wen and other Tianjin Science and Technology Press, 1992/1
4. Software Engineering Zhang Hai Tsinghua University Publishing House 1990/11
The standards used in the document are referred to as "Software Engineering Introduction" Shen Ming's "Computer Software Development Document Writing Guide".
2. Task overview
2.1 goals
2.2 Operation Environment
The system will consist of two partial programs, installed on customer programs and data server programs in the company's clients.
Based on the investigation to learn that all travel agencies are in the Pentium 133 level, the client program should be able to run in the Pentium 133 level, Win NT environment.
2.3 Demand Overview
Locke is convenient to manage, you need to develop a human resource management system. In order to facilitate the management of the company's high-level management, the administrator is first allocated by administrators to allocate user names and initial passwords. The personnel department needs employee information (including: employee number, name, gender, date of birth, national, political face, working age, position, department, basic salary, remark), recruitment plan (including: recruitment time, department, number, requirements) Training programs (including: training time, department, number, location, topic) Enter the system's client program, financial sector to take employees' wage information (including: employee number, name, gender) according to the staff of employees , Departmental number, basic salary, real salary, overtime, working day, subsidy, bonus, tax, welfare, deduction, false, sick, payable, payable, enter the system's client program. Require system effective, fast, safe, reliable and error-free completion of the above operations. And ask the client's interface to be simple, easy to operate, server program is beneficial to maintain. 2.4 Conditions and Restrictions
3. Overall design
3.1 Processing Process
The processing flow of the ticket predetermined system will be analyzed using the method for data streaming using (structured design). The system can be divided into two parts: First, the program on the client, two, the program on the server. The following will process the two most of the systems to the system:
3.1.1 Client Process Process
The input information on the client is employee information, training, recruitment plan, and employee wage information. The internal processing process is as follows:
The following modules will be described below:
1. Read the employee recruitment plan and recruit new employees.
2. Read employee wage information.
3. Prepare server data for inquiry.
4. Backup server data, prepare network packets to prepare / encrypt data into network to transfer data packets.
3.1.2 Server program process
The following modules (in digital representation) are described below:
1. Network data reception accepts packets transmitted from the client program to the client through the network.
2. The query will be sent to the client.
The same modules are the same module as the number displayed above; some functional modules are split into each transaction stream due to the convenience of transaction flow processing.
3.2 Overall Structure and Module External Design
The overall structure of the software of the ticket scheduled system is described below with a structural diagram. The name of the module is indicated in the box; the straight line represents the call relationship of the module between the blocks.
Personnel management system
3
. 2
. 1
Client part
3.2.2 Server Program Part
Human resource management system (server part)
Receive data
Data processing, query
Receive client data
Prepare SQL
Database operation
Judgment
Prepare to return data
Judgment
Prepare to return data
Among them, in the data processing, the query is omitted ... only gives a part of the module, which is actually two parts, respectively corresponds to positioning and confirmation.
3.3 Function Assignment
The functions of each module can be referred to in 3.1. The client program has two major blocks: receiving data, and output. Server programs are mainly two major functions: receiving network data, database operations. The server program needs to be interconnected with established SQL Server database, and its interface will be set forth below.
4. Interface design
4.1 External Interface
4.1.1 User Interface
In the user interface part, the user needs a user friendly interface based on the result of the requirements analysis. In the interface design, it should be simply clear, easy to operate, and to note the layout of the interface, it should be highlighted to display important and error information. The appearance should also be reasonable, considering that users are more familiar with the Window style, they should be close to this direction. On the design language, we have decided to use Delphi to program, on the interface, you can use the visual components provided by Delphi, close to the Windows style. The server program interface is simple, easy to manage. Using a drop-down menu mode in the design, the error prompt function in the Delphi library can be called on the error display. In general, the user interface of the system should be reliability, simply, easy to learn and use.
4.1.2 Software Interface
Server programs can use Delphi's interface to SQL Server, all access to the database.
The server program can use the backup command of the database to the database to be saved for the data.
In terms of network software interface, use a waveless transmission protocol to network transmission and reception of data using a sliding window.
4.1.3 Hardware Interface
In terms of input, for the keyboard, the mouse input, the input / output can be processed by Delphi.
In terms of output, the printer is connected and used, or it can be processed by standard input / output of Delphi.
4.2 internal interface
Internal interface, information transfer is performed by function call, parameter delivery, and return value between each module. The structure of the specific parameters will be described in the following data structural design. The information transmitted by the interface will be data encapsulated by the data structure, and is transmitted between each module in the form of parameter delivery or return value.
5. Data structure design
5.1 Database Data Structure Design
The use of SQL Server in the use of DBMS, and the system mainly needs to maintain 6 data sheets:
1. user table
Username Password (Password)
Considering the security of the database, the user table is mainly used for administrators to assign usernames and initial passwords for the administrators.
2. Employee information form
Employee number name Gender department number birth date national political facial working age position basic salary
The employee information table saves the positioned information, the primary key is employee number, and the external primary key is the department number.
3. Employee pay
staff code
Name
gender
Department mark
Basic wage
Working day
Overtime
subsidy
welfare
Taxation
deduction
bonus
sick leave
Hassle
Payable
Employee wage lists save employee wage information, its primary key is employee number, and the external primary key is the department number.
4. Department table
Department mark
Department name
The department information table preserves the numbering of each department and the corresponding department name. Its external primary key is the department number. The server is returned when you enter the new employee and query employee information.
5. Recruitment schedule
Plan number
Recruitment time
department
Number
Specific requirements
The recruitment schedule is mainly used to save the time and department of the recruitment and the number of people and the specific requirements of the candidate.
6. Schedules
Training plan number
training period
Training topics
department
Number
location
The training plan is mainly used for saving the time, department, theme, number, location and other information, and will be called when training is conducted and returned.
5.2 Physical Data Structure Design
The physical data structure design is mainly designed in the form of data in the module. The data is represented in the module.
1. User Info
User name String
Password char
Enter when the administrator user logs in to the system, and the administrator can modify the password by itself.
2. Employee information 1. Employee number String
2. Employee name char
3. Gender char
4. Sector String
5. Date Data Data
6. National char
7. Political face char
8. Working age INT
9. Director char
10. Basic salary Folat
11. Remarks VARCHAR (200)
The server is returned when you enter the new employee and query employee information.
3. Employee wage information
11. Tax Float
12. Dressing Float
13. Master Integer
14. Sick INTEGER
15. Solid wage float
1. Employee number String
2. STRING
3. Gender char
4. Department STRING
5. Basic salary Float
6. Work Day INT
7. Overtime INT
8. Welfare float
9. Subsidy Float
For employee wage input, and the server returns when salary query.
4. Departmental information
Department number String
2. Department name String
Input, and employee information input, and employee pay input, and returned when the employee wage input is input.
5. Recruitment plan information
Recruitment plan number String
2. Recruitment time DATE
3. Recruitment department String
4. Recruitment number INT
5. Recruitment requirements VARCHAR (200)
Used in recruitment workers.
6. Training plan information
1. Training plan number String
2. Training theme String
3. Training time DATA
4. Training place string
5. Training number Int
6. Training department String
Used in employee training.
5.3 Relationship between data structure and procedures
The server program needs to perform queries and modifications to the database database data structure when operating employee information and employee salary, department settings, etc.
The physical data structure is mainly used for information transfer of functions between each module. The information transmitted by the interface will be data encapsulated by the data structure, and is transmitted between each module in the form of parameter delivery or return value.
6. Run design
6.1 Combination of running modules
The client program starts the receiving data module when entering the input, read and format the input through the call between the modules. When receiving the data module gets sufficient data, the network transmission module is called, and the data is sent to the server over the network, and wait for the information returned by the server. The data output module is called after receiving the return information, and the information is processed to generate the corresponding output.
The receiving network data module of the server program must always be active. After receiving the data, call the data processing / query module to access the database, then call the network send module after completing, return the information to the client.
6.2 Running
Running control will be strictly implemented in accordance with various module functions. In each affairs center module, you need to correctly determine the running control, select the correct operating control path. In terms of network pass, after sending data, the confirmation of the waiter receives the signal. After receiving, wait for the server to send answered data, and then confirm the data. The server sends a confirmation signal after receiving the data. After the data processing, after accessing the database, the server will return to the client back to the client, and wait for a confirmation.
6.3 Running time
In the demand analysis of the software, the requirements for running time have a faster response to the operations. Network hardware has the greatest impact on the running time and performs data transfer in the LAN to implement connections between clients and servers. Secondly, the performance of the server will affect the length of the operation time, which affects the operation time of the database, affects the waiting time of the client operation, so high-performance servers must be used, which is recommended to use the Pentium III processor. The speed impact of hardware on this system will be greater than the impact of software.
7. Error handling design
7.1 Error Output Information
Two errors will appear primarily at runtime: 1. Soft errors are called soft errors due to input information or incorrectly when requested. 2. Due to other issues, such as network transmission timeout, etc., is called hard errors.
For soft errors, you must generate a corresponding error prompt statement to send it to the output module.
For pairing, a simple error statement can be output in the failed module and reset the program. Returns the input phase.
The error message must give the corresponding cause, for example:
"I have no other person!"
"User name or password is incorrect", etc.
7.2 Error handling countermeasures
All clients and servers must install uninterruptible power supply to prevent loss of data loss caused by power outage or voltage stabilization. If you really break, there will be no more influence on the client, mainly on the server: The log file of SQL Server can be used after the power-off recovery process, and the data is recovered.
In terms of hardware, choose a more reliable, stable server model to ensure the reliability of the system.
8. Maintenance design
Maintenance is mainly maintained for database data on the server. You can use the SQL Server database maintenance function mechanism. For example, regularly perform backup, maintain management database deadlock problems, and maintain consistency within database data.
