It sounded easy at first.
I am trying to create a database to keep track of the software an employee needs depending on the job position. And also be able to add additional duties software to the employees list.
I have created the following tables:
Employee
Position (Junction table)
AddDuties (junction table)
Software
Created 2 Many-Many relationships between the Employee - Software using the 2 junction tables.
But the results are not what I expected.
Any design help would be greatly appreciated.