Q4
Single choice
Refer to the exhibits.
An app is built to analyze salesperson performance by department. Departments are unique within the Departments table, but Salespeople often move between departments. A strict business rule states that a
salesperson must be associated with ONLY one department at all times.
The data architect creates a summary of department performance and notices the values are incorrect.
The total sales KPI shows the correct result.
How should the data architect modify the data model to correct this issue?