CSC 350 Database Programming Assignment 3 (25 points) Due Date: As posted in Canvas Life without SQL (25 points). A comma separated values (csv) file is given on Canvas: employee-sample.csv. It contains a dataset with employee salary information, which includes Full Name, Current Annual Salary, Gross Pay Received, Overtime Pay, Department (This is the abbreviation of department name; for example BOA stands for Board of Appeals), Division, Assignment Category (Parttime-Regular, Fulltime-Regular), Position Title (Supervisor, Manager, Social worker, Library assistant, ...), and Date First Hired. Note: A comma separated values (csv) file is a plain text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A csv file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields. Below is a sample taken from the employee-sample.csv file (the header line and two data lines): Full Name. Current_Annual_Salary, Gross_Pay_Received. Overtime_Pay Department Division, Assignment_Category Position_Title, Date_First_Hired Bisrat Abnet, 48835,55601,9310,DLC., Purchasing, Fulltime-Regular Alcohol Beverage Purchasing Specialist 5/3/04 Bista Gopal,45040,43238,0, LIB, Bethesda Library,Fulltime-Regular,Library Assistant 11,4/10/02 Problem: You have to write a Java program to answer one of queries a) or b) below. Your code must process the csv data file directly (meaning, solve the problem without importing the data in a DBMS and using SQL.) a) Query: Search for and list the names of all employees who work in the same department as Adcock Sr Gerald W- himself excluded. Note: The department in which Adcock works must be found programmatically, by searching the csv file - it must not be hardcoded in your program, the same applies for finding the employees working in that department. Hint: there are 29 employees that your code should find. b) Query. List all the department codes and the total number of employees working in each department. Note: the department codes (= abbreviations) and the count of employees in each department must| be determined programmatically, by processing the csv file in an appropriate manner. Hint: there are 31 departments that your code should find. What to turn in: Your source code file(s) for data retrieval task Query a) or Query b), which processes the given csv file directly. A readme file to explain how to run your code from command line; indicate any parameters the code expects, paths to any files / resources that the code uses. How to submit: Your Java source code file(s) and readme file must be submitted in a zip file named HW3_YourLastName.zip (substitute your last name and use the link Assignment 3 in the module for Chapter 2). CSC 350 Database Programming Assignment 3 (25 points) Due Date: As posted in Canvas Life without SQL (25 points). A comma separated values (csv) file is given on Canvas: employee-sample.csv. It contains a dataset with employee salary information, which includes Full Name, Current Annual Salary, Gross Pay Received, Overtime Pay, Department (This is the abbreviation of department name; for example BOA stands for Board of Appeals), Division, Assignment Category (Parttime-Regular, Fulltime-Regular), Position Title (Supervisor, Manager, Social worker, Library assistant, ...), and Date First Hired. Note: A comma separated values (csv) file is a plain text file that uses a comma to separate values. Each line of the file is a data record. Each record consists of one or more fields, separated by commas. The use of the comma as a field separator is the source of the name for this file format. A csv file typically stores tabular data (numbers and text) in plain text, in which case each line will have the same number of fields. Below is a sample taken from the employee-sample.csv file (the header line and two data lines): Full Name. Current_Annual_Salary, Gross_Pay_Received. Overtime_Pay Department Division, Assignment_Category Position_Title, Date_First_Hired Bisrat Abnet, 48835,55601,9310,DLC., Purchasing, Fulltime-Regular Alcohol Beverage Purchasing Specialist 5/3/04 Bista Gopal,45040,43238,0, LIB, Bethesda Library,Fulltime-Regular,Library Assistant 11,4/10/02 Problem: You have to write a Java program to answer one of queries a) or b) below. Your code must process the csv data file directly (meaning, solve the problem without importing the data in a DBMS and using SQL.) a) Query: Search for and list the names of all employees who work in the same department as Adcock Sr Gerald W- himself excluded. Note: The department in which Adcock works must be found programmatically, by searching the csv file - it must not be hardcoded in your program, the same applies for finding the employees working in that department. Hint: there are 29 employees that your code should find. b) Query. List all the department codes and the total number of employees working in each department. Note: the department codes (= abbreviations) and the count of employees in each department must| be determined programmatically, by processing the csv file in an appropriate manner. Hint: there are 31 departments that your code should find. What to turn in: Your source code file(s) for data retrieval task Query a) or Query b), which processes the given csv file directly. A readme file to explain how to run your code from command line; indicate any parameters the code expects, paths to any files / resources that the code uses. How to submit: Your Java source code file(s) and readme file must be submitted in a zip file named HW3_YourLastName.zip (substitute your last name and use the link Assignment 3 in the module for Chapter 2)