You need to relate two entities, Employee and Skill, in the data structure. You want to adhere to Appian best practices.
Employees can have multiple skills, and a single skill can relate to multiple employees.
What type of relationship do these entities represent, and what is the minimum number of tables required to implement the design?
Employee table
Skill table
EmployeeSkill (junction/association) table - contains foreign keys referencing both Employee and Skill to manage the many-to-many relationship.
Submit