Design a MySQL database for human resource management platform, requirements are as follows:

1. Set up a used for storing information about human resources application library;

2. The application in the library can be stored separately staff basic information, salary information and organization,

I "staff basic information including: staff number, employee name, date of birth, domicile of origin, phone number, the tail of the organization code salary information including: staff number, basic salary, performance salary, real pay

"Organization" include: organization code, name of organization structure description

To the above three types of information to build data table, write SQL statement

Table 3. The data of all kinds of information for data entry, query, including cross table query) to write SQL statements

4. On the whole library building process in detail, describes the application

CodePudding user response:

Baidu itself: 1. The mysql database statement
2. Mysql built predicate sentence
3. The mysql insert statement
Details 4. Note: payroll information table and staff basic information table of the main foreign key relationships, salary information in the table employee number with staff basic information in the table number corresponding to the employees, staff basic information in the table to code and organization in the table on the corresponding code, need to use three tables joint query,