Article, add the following five teachers information: job number, name, gender, department, title, salary
Job number
Name
Gender
Department
Title
Monthly salary (RMB)
201901
Liu Ming
Male
Institute of chemical industry
Associate professor
12000
201904
A small
Female
Institute of environmental
Ta
6900
201503
Chae rim
Female
Institute of chemical industry
The lecturer
9200
201805
Li
Female
Institute of chemical industry
Ta
7200
201902
Aihwa ong
Male
Institute of environmental
The lecturer
7900
3, the query function
(1) shows all teachers information
(2) according to the department of information query teacher
(3) query monthly salary & gt;
=8000 teachers of information4, department information input, output the highest monthly salary, the department minimum monthly salary of teachers' information
5, through the keyboard input work number, amend the corresponding working teachers' title and salary
6, through the keyboard input work number, delete the corresponding working teachers information
7, according to the monthly salary information from high to low output teacher
8, the teachers' information in the file
CodePudding user response:
Not a few hours is also done