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

Queries is used to discover new added network node. A) Broadcast B) Anycast C) Multicast D) Unicast
please give the definitons of NC,CNC,DNC and ONC?
7. Add a foreign key constraint to the shows table: the column net_id is the foreign key, referencing the column id from the networks table. Take a screenshot now and paste it here. 8. Show the structure of your table shows. Take a screenshot now and paste it here. 9. Insert the following data in your database. You may use more than one INSERT statement. title num_episodes country start end network Daniel Tiger 105 USA 2012 NULL PBS Handy Manny 113 USA 2006 2013 Disney
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?
Country ISO Code2 NO Name Area1 Area2 Norway 127000 14000 SY Syria 50000 21000 BD Bangladesh 15000 NULL ΤΗΝ Honduras NULL 13000 AR Argentina 317000 NULL SELECT MAX(Areal + Area2) FROM Country; Enter the result: Ex: 12345 SELECT MAX (Areal) + MAX (Area2) FROM Country; Enter the result: Ex: 12345
Please answer it within 5 minutes
Write an XML file that describes information of students in a class. The following table has the students' details: Name ID Ahmed 1000 Muhammad 2000 Note that the root element start and end tags are provided
Please answer ASAP
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.
What is an important caution to keep in mind when deleting rows, columns, and tables?
Correct Query from table given.
Please answer questions