HW3

docx

School

Northern Kentucky University *

*We aren’t endorsed by this school

Course

285

Subject

Computer Science

Date

Apr 3, 2024

Type

docx

Pages

2

Uploaded by Lukem11568

Report
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 the 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 II,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 “Johnson Jared”- himself excluded . Note: The department in which Johnson 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 division names and the total number of employees working in each “Transportation” division (= divisions whose names start with “Transportation”.) Note: the division names and the count of employees in each division must be determined programmatically , by processing the csv file in an appropriate manner. Hint: there are 9 “Transportation” divisions 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) .
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help

Related Documents

3.3 System Hacking Lab Report.docx
Malware Threats and Sniffing Lab Report.docx
Social Engineering and Denial of Service Lab Report.docx
Malware and Sniffing Lab Report.docx
Homework-6-Q-2 p1.pdf
LucianoRosario_IT640_IP5.pptx
Laudando_Sara_Hardware_Shopping.docx
Sachin veldi APCS-P ModuleSixLessonTwoActivityGuide.docx
LAB 1 EC2-3_09_03_2023 (1).docx
Lab3_S3-1.docx
HW8_SQL_AdvQueries.docx
Assignment 4.docx
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning
SEE MORE TEXTBOOKS