QUESTION 2 Given the following text file named Stud FKM.txt in Figure 1 that contains the recruitment data of athlete from FKM, UITM. The data is comprised of students' name, gender, weight and height. StudFKM-Notepad File Edit Format View Help Mohd Azam Awang, Male, 55, 1.68 Abdullah Zakaria, Male, 65, 1.77 Marina Abdul Aziz, Female, 52,1.68 Abdul Sani Hassan, Male, 77,1.84 Nurul Izawani Haron, Female, 45,1.55 Muhammad Nabil Salleh, Male, 60, 1.76 Figure 1: Sample of StudFKM.txt Write a complete Java program using File I/O operation that can perform the following tasks: a) Declare the related file involved. b) Read all records from text file named StudFKM.txt in Figure 1 c) Write all records about female students whose weight is above 60 and height is below 1.6 into text file named Female.txt. I d) Close all file streams in used. e) Use exception-handling operations to deal with possible file input-output error.

QUESTION 2 Given the following text file named Stud FKM.txt in Figure 1 that contains the recruitment data of athlete from FKM, UITM. The data is comprised of students' name, gender, weight and height. StudFKM-Notepad File Edit Format View Help Mohd Azam Awang, Male, 55, 1.68 Abdullah Zakaria, Male, 65, 1.77 Marina Abdul Aziz, Female, 52,1.68 Abdul Sani Hassan, Male, 77,1.84 Nurul Izawani Haron, Female, 45,1.55 Muhammad Nabil Salleh, Male, 60, 1.76 Figure 1: Sample of StudFKM.txt Write a complete Java program using File I/O operation that can perform the following tasks: a) Declare the related file involved. b) Read all records from text file named StudFKM.txt in Figure 1 c) Write all records about female students whose weight is above 60 and height is below 1.6 into text file named Female.txt. I d) Close all file streams in used. e) Use exception-handling operations to deal with possible file input-output error.

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

See similar textbooks

Similar questions

Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASE
Data base
In cell D5, create a formula using the VLOOKUP function to determine the cost per participant for the Game Room workshop based on the Workshop ID in cell A5. Use range H4:I11 as the lookup table and the cost per participant listed in column 2 of the lookup table. Do not enter a calue for the optionional range_lookup argument.
For reading order as a functional test for summarization, fill in the rightmost two columns of the table below. Which Summarizer is the best of the 5 shown, and why? Document Set Document Order Weighted Distance to Original Ranked Order Original ABCDEFGHIJ N/A N/A Summarizer 1 ABFDECHIGJ Summarizer 2 ABCIEHJDGF Summarizer 3 ABDCFEHIGJ Summarizer 4 BACEDGFIHJ Summarizer 5 ADCFEBIGHJ
The pg2.np_2017camping table contains public use statistics for camping in 2017 from the National Park Service. To enable statistics to be calculated for all camping locations, restructure the table as a narrow table.Show results also.
Can anyone help me with this question? Thankyou! I’ll be sure to leave a thumbs up!
Include both your normalized relational dataset as well as finalized tables with relationship into a word document. Attached a cover page with your group members name , Lecturer Name and Submission Date and Time to Blackboard submission link for grading.
1. Create a view that lists the name and phone number of the contact person at eachpublisher. Don’t include the publisher’s ID in the view. Name the view CONTACT. SQL commands
For this problem create a (temporary) table called instructor_course_nums. Write a procedure that accepts an instructor ID as input. The procedure calculates the total number of course sections taught by that instructor, and adds a tuple to the temporary table consisting of the instructors ID number, name, and total courses taught - call these attributes: ID, name, and tot_courses. If the instructor already has an entry in the table,then the procedure makes sure the total number of courses taught in the temporary table is up-to-date. You must name your procedure: Written in PostgreSQL
Please give me correct solution.
Assuming there is a table named payroll, with 1000 rows of data. The table contains attributes staffid (as primary key with values between 1001 and 2000), allowance, and salary. CREATE OR REPLACE TRIGGER trg_salary BEFORE INSERT OR UPDATE OF salary ON payroll FOR EACH ROW BEGIN END; DBMS_OUTPUT.PUT_LINE (`Payroll table changed.'); IF UPDATING THEN ELSE DBMS_OUTPUT.PUT_LINE(New salary: || :NEW.salary); DBMS_OUTPUT.PUT_LINE(ID:||:NEW.staffid); DBMS_OUTPUT.PUT_LINE(Allowance:||: NEW.allowance); DBMS_OUTPUT.PUT_LINE(Salary:'||:NEW.salary); END IF; Given a database trigger as presented above, with the assumption of SET SERVEROUTPUT ON command is enabled, state 'True' or 'False' for each of the following statements: ✓ Trigger trg_salary will be fired after a row is deleted from the payroll table. A. True ✓ Message 'Payroll table changed.' will be displayed ONE THOUSAND (1000) times before a valid SQL statement UPDATE employee SET increment = 1.05 is successfully executed. B. False ✓ Message…
QUESTION 8 Columns added to a table in transform data can be seen in the Data View? O True False