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

2. Create a view named Top10PaidInvoices that returns three columns for each vendor: VendorName, LastInvoice (the most recent invoice date), and SumOfInvoices (the sum of the InvoiceTotal column). Return only the 10 vendors with the largest SumOfInvoices and include only paid invoices.
Show how to create a view tot credits (year, num credits) that returns the total amount of credits taken in each year.
Create a view named ITEM_INVOICE. It consists of the item ID, description, price, invoice number, invoice date, number ordered, and quoted price for all invoice lines currently on file.
Using the Winners table from Figure 12-2, write a parameter query that selects only an actor’s Picture field.
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.
I am working on Task 7. Task 7: Create a view named MONTHLY_RENTS. It consists of three columns: the first is the number of bedrooms, the second is the average square feet, and the third is the average monthly rent for all properties in the PROPERTY table that have that number of bedrooms. Use BEDROOMS, AVG_SQUARE_FEET, and AVG_MONTHLY_RENT as the column names. Group and order the rows by number of bedrooms. Here is Tasks 1-7 and what I wrote for Task 8. When I input Task 8, I am not getting results at all. Expected Results Tables_in_StayWell Table_type MONTHLY_RENTS VIEW
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.
Create a report of employees within the Research department showing First Name, Last Name, sorted alphabetically A-Z.
The screenshot of the query and the results below is from the question of each number, and saved with the file name: UAS_35200103.docx or UAS_35200103.pdf Enter the data in the table as follows:
Create a view, using JOBS, DEPARTMENTS, and JOB_HISTORY tables that will include department name (not ID), job title (not jobID), start date, and end date for all rows in the JOB_HISTORY table Using your view, write a query that shows the number of rows (count) for each department. Write a query that uses your view from above to select the columns department name, job title, and end date for all rows where the department name includes the string “Sale” that is NOT case-sensitive. Use a function. i.e. SALE, SaLe, Sale, sAle, etc. should all match a row