Mysql database design

CSDN Q & A 2022-01-27 07:26:04 阅读数:706

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



Refer to the answer 1:

Design 3 Tables , They are department tables , The employee table , Payroll table




Refer to the answer 2:
copyright:author[CSDN Q & A],Please bring the original link to reprint, thank you. https://en.javamana.com/2022/01/202201270725590110.html