yee number, in,

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

Java Program OOP

Input File
----------
employee.csv - employee number, last name, first name, middle name, rate

trans.csv - employee number, in, out

Output File
-----------
comptrans.csv - employee number, total hours, overtime, pay

1. Open the two input files for reading. Use the statement below to convert each
   line read to an array:

   String[] objEmployee = strLine.split(",")

2. Compute for the following:

   total hours = out - in
   overtime = total hours - 8
   pay = total hours * (rate + 15%)

3. Write to the output file only those employees with transaction and display the
   following on screen:

   Employee number  Full name                    in    out  total overtime  pay
   ---------------  --------------------------   ---   ---  ----- --------  ---
   xxxxxx           last, first middle initial

 

 

employee csv
E0010023 Crisostomo
14 Galvez
E0010027 Bernardo
Jay
Ongpin
E0030034 Garcia
Rodolfo
Mejia
E0050078 Librador
Charmaigne Arnulfo
E0050087 Lander
Vera
Perez
E0070054 Meno
Arvie
Тoрacio
E0070061 Menandro Jenny
Corpuz
E0080070 Nono
Grace
Picache
E0080095 Patricio
Luzviminda Pelaez
Trans.csv
E0010027
6.3
14
E0050078
8
16.5
E0050087
7.3
16.45
E0070061
5.5
2.05
E0080095
8.02
16
Transcribed Image Text:employee csv E0010023 Crisostomo 14 Galvez E0010027 Bernardo Jay Ongpin E0030034 Garcia Rodolfo Mejia E0050078 Librador Charmaigne Arnulfo E0050087 Lander Vera Perez E0070054 Meno Arvie Тoрacio E0070061 Menandro Jenny Corpuz E0080070 Nono Grace Picache E0080095 Patricio Luzviminda Pelaez Trans.csv E0010027 6.3 14 E0050078 8 16.5 E0050087 7.3 16.45 E0070061 5.5 2.05 E0080095 8.02 16
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Knowledge Booster
Binary numbers
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education