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

Establish 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,

"Staff basic information including: staff number, employee name, date of birth, domicile of origin, phone number, subordinate to the organization code

"Salary information including: staff number, base pay, merit pay, real pay

"Organization" include: organization code, name of organization, organization 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:

This kind of simple architecture, even couldn't write the code, can also try to draw a flow diagram,

CodePudding user response:

You should use the computer speaking to this,
Table fields have, you have to learn to build table statements and query the basic grammar,
Recommend you a self-taught web site https://www.runoob.com/sql/sql-tutorial.html