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. 1 d) Close all file streams in used. e) Use exception-handling operations to deal with possible file input-output error.

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. 1 d) Close all file streams in used. e) Use exception-handling operations to deal with possible file input-output error.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 2HOA: Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The...

See similar textbooks

Similar questions

Change the CONTACT view so that no users can accidentally perform DML operations on the view.
Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.
Update the VID_STATUS attribute of the VIDEO table using a subquery to set the VID_STATUS to OUT for all videos that have a null value in the DETAIL_ RETURNDATE attribute of the DETAILRENTAL table.
Create a view named NHTrips. It consists of the trip ID, trip name, start location, distance, maximum group size, type, and season for every trip located in New Hampshire (NH). Display the data in the view
roblem 16 Create the CUSTOMER table structure illustrated in Figure P8.16. The customer number should store integer values. The CUST_FNAME and CUST_LNAME attributes should support variable length character data up to 30 characters each. CUST_BALANCE should support up to eight digits on the left of the decimal place and two digits to the right of the decimal place. Use CUST_NUM as the primary key. Problem 17 Create the INVOICE table structure illustrated in Figure P8.16. INV_NUM should store integer values. INV_DATE should store date values. INV_AMOUNT should support up to eight digits to the left of the decimal place and two digits to the right of the decimal place. Use INV_NUM as the primary key. Note that the CUST_NUM is the foreign key to CUSTOMER, so be certain to enforce referential integrity. Problem 18 Write the set of SQL commands necessary to insert the data into the CUSTOMER table you created in Problem 16, as illustrated in Figure P8.16. Problem 19 Write the set of SQL…
QUESTION 2 Given the following text file named studFKM.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. | d) Close all file streams in used. e) Use exception-handling operations to deal with possible file input-output error.
15. Open the AttendeeFirstName query in Design View and add criteria to select only those records where the FirstName field value begins with Lau followed by any other letters. Save the changes to the query. Open the query in Datasheet View, confirm that two records appear in the query results, and then close it.
create view that view names of professors and name of project
Views: Create a view “customer_guangzhou”, it indicates the customers from the city “guangzhou”; Create a view “ordersum_goods”, it indicates the total quantity of the orders of each product (goods).
Create a view named TopLevelCust view. It consists of the number, name, address, balance, and credit limit ofall clients with credit limits that are greater than or equal to $10,000. Display the data in the view.
Create a view named 'Normal Results' containing the Patient_Name, Patient Surname, Doctor Surname, Test_Date and Test_Result for all patients who obtained a normal blood sugar test result (less than 7.8). Sample Results: PATIENT NAME Nico Andrew PATIENT DOCTOR_ SURNAME SURNAME Baird Crouch Phillips Phillips TEST_DATE TEST RESULT 03.05.2021 6,4 13.02.2021 5,6
Lalal Module Lab Assessment 3 دارد Y O Tasks for properties where their PROPERTY_ID equals 1 using the COLOMBIA_CITY_PROPERT Y VIEW Remove the ... Alter the PROPERTY table by changing the OWNER_NUM field to refer to the OWNER table. Retrieve the first and last names of the residents combined and converted to uppercase, > > Submit 12% FILETREE ⇒-/worksp Drop query. query

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

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

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

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

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS