Tmember_No
Employee_ID
Booking_ID
Hours

SupervisorID
Employee_ID
Booking_ID
Hours

TempRoleID (PK)
StaffID (FK)
HoursAssigned
Role (as there's two types of roles a temporary staff member may have)
PayRate

PermanentID (PK)
StaffID (Fk)
Salary

EmployeeType (PK)
EmployeeID*
TempRoleID*
PermanentID*

EmployeeID (PK)
First Name
Last Name
NI number
Employee Type *
Phone
Address
Email