The task assigned by the teacher, let's create a database table for the personnel management project of a province to express which organizations have positions and who are not on duty. The information should be imported into excel data. when a tag is transferred out, it also indicates where it is to be transferred or when a new person is required to enter. if this person disappears, it needs to be deregistered. statistics should be made to determine the number of leaders in each organization and the number of leaders at each level. how can we create a reasonable and good database for all these requirements? How to establish it? thank you !! Urgent! Mysql design SQL database data
The task assigned by the teacher allows us to create a database for a provincial personnel management project.
To indicate which organizations have positions and who are not on duty or whether the information should be imported into excel data units
If it is called out, there will be a mark for calling out. it will also mark the place where it is transferred, or a new person will have a new person to enter. if this person disappears, it will be canceled.
We also need to make statistics on the number of leaders in each organization and the number of leaders at each level. you can see which position is missing.
How can we establish a reasonable and good database with these requirements? How to establish it? thank you !! Urgent!