Create a sequential file Students.txt and open it for output. Allow the user to input the ID(integer), Name(string) and GPA(double) until ctrl-z is pressed and make sure store them inside the file Students.txt separated by a space. Read from the file the five GPA values and find the lowest and highest values. Calculate the average GPA. • Store the lowest, highest and average GPA inside another binary file Results.txt • Close Results.txt then open it to read and display the results on the screen. The following is a sample output for the program: Enter the ID, Name and GPA for student 1: 20121111 John 3.5 Enter the ID, Name and GPA for student 2: 20122222 Jane 3.7 Enter the ID, Name and GPA for student 3: 20123333 Alex 3.6 Enter the ID, Name and GPA for student 4: 20124444 Kara 3.4 Enter the ID, Name and GPA for student 5: 20125555 Lana 3.8 Lowest GPA: 3.4 Highest GPA: 3.8 Average GPA: 3.6 Press any key to continue I

Create a sequential file Students.txt and open it for output. Allow the user to input the ID(integer), Name(string) and GPA(double) until ctrl-z is pressed and make sure store them inside the file Students.txt separated by a space. Read from the file the five GPA values and find the lowest and highest values. Calculate the average GPA. • Store the lowest, highest and average GPA inside another binary file Results.txt • Close Results.txt then open it to read and display the results on the screen. The following is a sample output for the program: Enter the ID, Name and GPA for student 1: 20121111 John 3.5 Enter the ID, Name and GPA for student 2: 20122222 Jane 3.7 Enter the ID, Name and GPA for student 3: 20123333 Alex 3.6 Enter the ID, Name and GPA for student 4: 20124444 Kara 3.4 Enter the ID, Name and GPA for student 5: 20125555 Lana 3.8 Lowest GPA: 3.4 Highest GPA: 3.8 Average GPA: 3.6 Press any key to continue I

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

I tried using this and it gives me (Error Code: 1052. Column 'AU_ID' in field list is ambiguous) could you provide fix and explain why MySQL does this?
Please answer it within 5 minutes
17. List the network names and the number of shows per network. Take a screenshot now and paste it here. 18. List the average number of episodes in the table shows. Take a screenshot now and paste it here. 19. List the name of the shows that have more episodes than the average number of episodes in the table shows. Use a subquery. Do not hardcode the average number (that you obtained in the previous question). Take a screenshot now and paste it here.
Correct Query from table given.
Make sure that the SQL script file can be run successfully in MySQL and show the outcome of the whole code on MySQL please
write php codes for an expense track weballow to add income, expense record, and expense summarysave to mysql databaserepresent data in chartjavacripts to validate forms, input fields login and registration php forms
Write a servlet to display a table that contains factorials for thenumbers from 0 to 10, as shown in Figure .
write the code for the following triggers in MySQL following the style shown in the text. A: When adding a customer, add the customer balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. B: When updating a customer, add the difference between the new balance and the old balance multiplied by the sales rep's commission rate to the commission for the corresponding sales rep. C: When deleting a customer, subtract the balance multiplied by the sales rep's commission rate from the commission for the corresponding sales rep. CREATE TABLE REP(REP_NUM CHAR(2) PRIMARY KEY,LAST_NAME CHAR(15),FIRST_NAME CHAR(15),STREET CHAR(15),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),COMMISSION DECIMAL(7,2),RATE DECIMAL(3,2) );CREATE TABLE CUSTOMER(CUSTOMER_NUM CHAR(3) PRIMARY KEY,CUSTOMER_NAME CHAR(35) NOT NULL,STREET CHAR(20),CITY CHAR(15),STATE CHAR(2),POSTAL_CODE CHAR(5),BALANCE DECIMAL(8,2),CREDIT_LIMIT DECIMAL(8,2),REP_NUM CHAR(2) );INSERT INTO…
What does the DELETE command do in mySQL? Why is it important?
Use the appropriate MySQL command to list all tables in the books database
Insert the keys: D, S, T, W, O, F, L, M, I, D into a table of size 10. Use ASCII value for each character. If you have collision, solve it by Linear probing. Hint: ASCII value of A is 65, B is 66 and so on. Attach File Browse My Computer
mysql Create four tables below and populate a sample data.