Database design questions
New project coming up which will need Security Assist for employees to log into system. Database will contain information on clients who are assigned to an employee. Employee table which uses employee_ID. Client table which uses client_ID. Client table will include employee_ID. Is this logic correct so when employee 1 logs in she will only see clients assigned to her? Employee 2 only can see those assigned to him? And finally, how will the master admin see all clients? I am guessing one of the entries in employee table is an admin, and then all clients have 2 employees assigned, one of which is the admin employee_ID? Set to autofill in database? Or is there an easier way?