Authorization in .net

Question

Want to do .net core based web project for educational Institution. Each staff should be able to create, update his record. Staff details maintained in multiple tables. Admin can approve, reject records. Staff should be able to view other colleagues records. I want to implement

authorization along with authentication for this case study.

 

Department(1:* with Staff) DeptId StartDt Image Hod

Staff StaffId DeptId JoinDT Image

Personal(1:1 with Staff) Id StaffId BirthDt Marital Address

Project(*:1 with Staff) Id StaffId Title Url Duration