Mysql database design

Employee salary management
Background information ：

1. A unit has 1000 Employees , Among them are managers 、 financial staff 、 Technicians and salespeople .
2. The unit has 4 Departments , The manager's office 、 Finance department 、 Technology section and sales section .
3. The salary consists of the basic salary 、 The composition of welfare subsidies and incentive wages , Unemployment insurance and housing accumulation fund are deducted from wages .
4. The basic information of each employee has a name 、 Gender 、 Age 、 Unit and occupation （ As a manager 、 The engineer 、 Salesmen, etc ）.
5. The maximum monthly salary of an individual shall not exceed 3000 element . Wages are paid on a monthly basis , The amount of salary actually paid is salary minus deduction .
   The design requirements ：
6. Conduct demand analysis , Write a data dictionary .
7. Design E-R chart .
8. Realize the entry of personal basic data according to the Department 、 Data on wages and deductions .
9. Calculate the actual salary paid by individuals .
10. By Department 、 Statistics on the number of people and salary amount by occupation .
11. Implement classification query .
12. Data of resigned personnel can be deleted