please help with 1/2/4

For this assignment you will use the attached data concerning employee salary data. Make a class to hold each record of employee data. Then make a test class, and in this class you will use an ArrayList to hold the data. Then answer the following questions in your test class: 1. What is the top employee that made the most money, and what was their name, job title, and department. 2. Search for the following employees and retrieve their records: Brian S Murphy, Eric D Clark, Lisa M Hall, Pedro Adame. 3. What was the average pay for all employees that work in the police department. 4. Check to see if any 2 employees in the data have the same name. We will complete one of the questions in class, question 2 is answered in the lecture video, and you are responsible for making methods to answer at least 2 of the other questions. The data used for our project - note that you should put this file in your project folder so that it can be read in by the program. EmployeeData-1.csv a For this assignment you will use the attached data concerning employee salary data. Make a class to hold each record of employee data. Then make a test class, and in this class you will use an ArrayList to hold the data. Then answer the following questions in your test class: 1. What is the top employee that made the most money, and what was their name, job title, and department. 2. Search for the following employees and retrieve their records: Brian S Murphy, Eric D Clark, Lisa M Hall, Pedro Adame. 3. What was the average pay for all employees that work in the police department. 4. Check to see if any 2 employees in the data have the same name. We will complete one of the questions in class, question 2 is answered in the lecture video, and you are responsible for making methods to answer at least 2 of the other questions. The data used for our project - note that you should put this file in your project folder so that it can be read in by the program. EmployeeData-1.csv a