.net role authorization and authentication

See more:

.NET

Sir I want to do .net core based project to maintain staff data in the Educational Institution. Each staff should be able to create update their own records. Staff details are maintained in multiple tables. Admin can approve and delete the records. Staff should be able to see other colleagues approved records. Can someone help me with role authorization convention for this scenario.
Department(1:* with Staff)
DeptId
Name
StartDT
Image
HOD
Staff
StaffId
Name
JoinDt
DeptId
Project(*:1 with Staff)
Id
StaffId
Title
Url
Personal(1:1 with Staff)
Id
StaffId
BirthDT
Marital

What I have tried:

Unable to use authentication and authorization concepts for the above database