Okay... so I am working on building out a database that stores information for employees and their entitlements to different systems. Each system has different entitlements. I have created an Employee Table, System Table, and have consolidated table that had every entitlement possible. Employees were listed multiple times because 1 employee can have access to multiple systems.
The idea is for the users to be able to change employee entitlements if needed. I can create a lookup table to show all the systems but my question is, what would be the best way to setup the DB so that only the entitlements that are unique to the system show up...or are able to be chosen for each system.
As of now... there are 40 systems and if I consolidate all the entitlements (some overlap) there are 200ish entitlements.
The idea is for the users to be able to change employee entitlements if needed. I can create a lookup table to show all the systems but my question is, what would be the best way to setup the DB so that only the entitlements that are unique to the system show up...or are able to be chosen for each system.
As of now... there are 40 systems and if I consolidate all the entitlements (some overlap) there are 200ish entitlements.