Employee salary management
Background information ：
- A unit has 1000 Employees , Among them are managers 、 financial staff 、 Technicians and salespeople .
- The unit has 4 Departments , The manager's office 、 Finance department 、 Technology section and sales section .
- 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 .
- The basic information of each employee has a name 、 Gender 、 Age 、 Unit and occupation （ As a manager 、 The engineer 、 Salesmen, etc ）.
- 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 ：
- Conduct demand analysis , Write a data dictionary .
- Design E-R chart .
- Realize the entry of personal basic data according to the Department 、 Data on wages and deductions .
- Calculate the actual salary paid by individuals .
- By Department 、 Statistics on the number of people and salary amount by occupation .
- Implement classification query .
- Data of resigned personnel can be deleted