Question $36$

I have created a relationship between two tables, Employee and Payroll.

There are $5$ employees in this dataset.

One employee can be paid multiple times $($in different months$).$

I want to see how many employees are paid each salary.

As shown below, I therefore create a column chart which has Payroll$[$Salary$]$ on the X$-$axis, and count of $[$Employee$]$EmployeeID on the Y$-$axis.

It incorrectly shows all $5$ employees being paid $$1,000,$$$2,000,$ and $$3,000.$

What do I need to do to correct this visual, to show how many employees are paid each salary accurately?

Change the Cardinality of the relationship to "Many to many $()".$

Change Salary to be in the $Y-$axis, and Count of EmployeeID to $x-$axis.