Realize the school department information, position, title and staff information management;
Realization of one's status as a student teacher experience management;
To realize the family relationship management of teachers;
To realize the rewards and punishment information management of teachers;
Create a stored procedure query various titles of every unit number of the staff;
Teachers create a trigger when increase, delete and modify faculty department information automatically modify the corresponding department staff;
Create rules are used to ensure staff E-mail input format correct;
Establish a database of referential integrity constraints between related tables,

CodePudding user response:

Good coincidence, I made this was last year

CodePudding user response:

reference 1st floor zgh27 response:

good coincidence, I'm last year to do this

You can do it, share, email to 1711420791 @qq.com