Suppose you have just opened a file pFile on permit request records with the following data formats COP2510 84652123 pending COP3514 17680087 approved ...(more data) The first field in a row is the course id, the second is the student id, the third is the status of the request (pending or approved). What statement is correct for reading a row of data? Assume student_id is an int variable, course_id is a string variable, and status is a string variable.

Suppose you have just opened a file pFile on permit request records with the following data formats COP2510 84652123 pending COP3514 17680087 approved ...(more data) The first field in a row is the course id, the second is the student id, the third is the status of the request (pending or approved). What statement is correct for reading a row of data? Assume student_id is an int variable, course_id is a string variable, and status is a string variable.

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 15RQ

See similar textbooks

Similar questions

5: Create the GET_CREDIT_LIMIT procedure to obtain the full name and credit limit of the customer whose ID currently is stored in I_CUST_ID. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. When the procedure is called it should output the contents of I_CUSTOMER_NAME and I_CREDIT_LIMIT. HERE'S MY QUERY -- create a procedure named GET_CREDIT_LIMIT -- use I_CUST_ID as a input parameter -- use I_CUSTOMER_NAME, I_CREDIT_LIMIT as output parameters -- select columns CONCAT(FIRST_NAME, ' ', LAST_NAME), CREDIT_LIMIT and store the values in I_CUSTOMER_NAME, I_CREDIT_LIMIT -- using where clause to match the CUST_ID to currently stored in I_CUST_ID(provided as a parameter) DELIMITER // CREATE PROCEDURE GET_CREDIT_LIMIT ( IN I_CUST_ID int, OUT I_CUSTOMER_NAME varchar(75), OUT I_CREDIT_LIMIT decimal(10,2) ) BEGIN SELECT CONCAT(FIRST_NAME, ' ', LAST_NAME), CREDIT_LIMIT INTO I_CUSTOMER_NAME, I_CREDIT_LIMIT FROM CUSTOMER WHERE CUST_ID = I_CUST_ID; END // DELIMITER…
you are required to read input file containing data of countries or region, to compute and display the data in decreasing order, and some statistics in an output file. Structure of input file: The first two lines of input files contains the region information, date of taken data, and heading of the records. Each line of the rest in the input file contains country name, confirmed and death total cases. COVID_19_data class: used to store records from input file. You should provide generic methods to compute average of confirmed cases, to sort list in descending order using selection sortii , and any additional method(s) to solve the problem. Tester Class: your main method should class two methods to read the data and to display the result as shown below. Your class should be user friendly and control any unchecked errors
You are given a file called detention.txt with a list of students names and ID numbers. The data will be stored as shown below: Erin Shaw,36425109 Aldo Montes,8736542 Jessica,587963 Logan,22587 Leo Alvera,6544836 etc... Note that not all the students will have their last names in the detention.txt (names will not repeat in the file) Your job is to create a c++ program for teachers to look up a students name and display their student ID. Example output. (Input is highlighted) Welcome Staff! Please enter a student's name: Leo Alvera Searching for Leo Alvera... We found the Student ID: 6544836 for Leo Alvera Please enter a student's name: Jessica Alvera Searching for Jessica Alvera... Jessica Alvera not in detention.txt system Please enter a student's name: Please give proper explanation and typed answer only.
Suppose that the file inData.txt, data set 1, contains the following data: Giselle Robinson Accounting 5600 5 30 450 9 75 1.5 The first line contains a person’s first name, last name, and the department the person works in. In the second line, the first number represents the monthly gross salary, the bonus (as a percent), and the taxes (as a percent). The third line contains the distance traveled and the traveling time. The fourth line contains the number of coffee cups sold and the cost of each coffee cup. Write statements so that after the program executes, the contents of the file outData.txt are as shown below. If necessary, declare additional variables. Your statements should be general enough so that if the content of the input file changes and the program is run again (without editing and recompiling), it outputs the appropriate results. Name: Giselle Robinson, Department: Accounting Monthly Gross Salary: $5600.00, Monthly Bonus: 5.00%, Taxes: 30.00% Paycheck: $4116.00…
This is for C++: Assume that you have a file that contains the weekly average prices for a gallon of gas in the United States for the past 3 years. The data is stored in the file as records. Each record contains the average price of a gallon of gas on a specific date. Each record contains the following fields: The month, stored as an integer. January = 1, February = 2, etc. The day of the month, stored as an integer. The year, stored as an integer. The average price of a gallon of gas on the specified date, stored as a real number, rounded to 3 decimal places. Design a program that reads the file and displays the lowest and highest gas prices, as well as the dates for those prices.
3. Create a stored procedure named spDateRange that accepts two parameters, @DateMin and @DateMax, with data type varchar and default value null. If called with no parameters or with null values, raise an error that describes the problem. If called with non-null values, validate the parameters. Test that the literal strings are valid dates and test that @DateMin is earlier than @DateMax. If the parameters are valid, return a result set that includes the InvoiceNumber, InvoiceDate, InvoiceTotal, and Balance for each invoice for which the InvoiceDate is within the date range, sorted with earliest invoice first.
Suppose you have a file Monster.txt that lists the Monster Energy Drinks the company offers, on one line and the price for a case of 24, with the customer ratings on a scale of 1-5 on the second line. The following shows the first few lines of the file: Monster Energy Nitro Super Dry Maximum Strength Drink 39.99 4.5 Monster Energy Ultra Red, Sugar Free Energy Drink 39.99 5 Red Bull Energy Drink, Zero 92.23 4.5 Red Bull Energy Drink, Coconut Berry 41.18 5 Monster Energy Juice, Pipeline Punch 34.98 5 Red Bull Energy Drink, Coconut Berry 41.18 5 The first line means the drink name is: Monster Energy Nitro Super Dry Maximum Strength and the second line means that a case of 24 cost $39.99 and it was rated 4.5/5. NOTE: WE DO NOT KNOW HOW MANY LINES THERE ARE IN THE FILE. Write the C++ program (with comments) that reads the data from the file, lists only those drinks rated 5 stars, and indicates if the five star drink comes with a free six pack or not.The customer gets a free six…
I need help with the last part of this code : print("Davy's auto shop services")print("Oil change -- $35")print("Tire rotation -- $19")print("Car wash -- $7")print("Car wax -- $12")print()service1=input("Select first service:")print()service2=input("Select second service:")print() dic={"Oil change":"35","Tire rotation":"19","Car wash":"7","Car wax":"12"}total = 0print() print("Davy's auto shop invoice")print()for key,value in dic.items(): if(service1 == key): print("Service 1:",key+str(", $")+dic[key]) total = total + int(dic[key]) if(service2 == key): print("Service 2:",key+str(", $")+dic[key]) total = total + int(dic[key])if(service1 == "-"): print("Service 1:", "No service")if(service2 == "-"): print("Service 2:", "No service")print()print("Total: $"+str(total)) Error : Davy's auto shop services Oil change -- $35 Tire rotation -- $19 Car wash -- $7 Car wax -- $12 Select first service: Select second service: Davy's auto shop invoice Service…
What is the most a book has been sold for? CREATE TABLE `volume` (`inventory_id` int(11) NOT NULL,`ISBN` char(17) DEFAULT NULL,`condition_code` int(11) DEFAULT NULL,`date_acquired` date DEFAULT NULL,`asking_price` decimal(7,2) DEFAULT NULL,`selling_price` decimal(7,2) DEFAULT NULL,`sale_id` int(11) DEFAULT NULL); INSERT INTO `volume` (`inventory_id`, `ISBN`, `condition_code`, `date_acquired`, `asking_price`, `selling_price`, `sale_id`) VALUES(1, '978-1-11111-111-1', 3, '2019-06-12', '175.00', '175.00', 1),(2, '978-1-11111-131-1', 4, '2019-01-23', '50.00', '50.00', 1),(3, '978-1-11111-133-1', 2, '2018-04-05', '300.00', '285.00', 1),(4, '978-1-11111-142-1', 1, '2018-05-05', '25.95', '25.95', 2),(5, '978-1-11111-146-1', 1, '2018-05-05', '22.95', '22.95', 2),(6, '978-1-11111-144-1', 2, '2019-05-15', '80.00', '76.10', 2),(7, '978-1-11111-137-1', 2, '2019-06-20', '80.00', NULL, NULL),(8, '978-1-11111-137-1', 3, '2019-06-20', '50.00', NULL, NULL),(9, '978-1-11111-136-1', 1, '2018-12-20',…
10. Write another function called db_consistent that takes a dictionary of dictionariesin the format described in the previous question and returns Trueif and only if every one of the inner dictionaries has exactly the same keys.(This function would return False for the previous example, since RosalindFranklin's entry doesn't contain the 'author' key.)
*In R please How many non-NA and how many NA values are there in the table? Create a new variable ans of class table that gives total number of non-NA as well as NA entries. The first component should be number of non-NA's, the second should be number of NA's. (You should have just one line of a code). New York Air Quality Measurements Description Daily air quality measurements in New York, May to September 1973. Usage airquality Format A data frame with 153 observations on 6 variables. [,1]OzonenumericOzone (ppb)[,2]Solar.RnumericSolar R (lang)[,3]WindnumericWind (mph)[,4]TempnumericTemperature (degrees F)[,5]MonthnumericMonth (1--12)[,6]DaynumericDay of month (1--31) Details Daily readings of the following air quality values for May 1, 1973 (a Tuesday) to September 30, 1973. Ozone: Mean ozone in parts per billion from 1300 to 1500 hours at Roosevelt Island Solar.R: Solar radiation in Langleys in the frequency band 4000–7700 Angstroms from 0800 to 1200 hours at Central Park Wind:…
Your client wishes to have a program that would generate a student database in a form of Excel spreadsheet. In order to save a record to the spreadsheet, client will enter student data at the prompt, one record at a time.Every record in the database is represented by student data; record number, first name, last name, ID, GPA. Your assignment is to write the program that would get user input, one line at the time, and write them to a Comma Separated Values file. In addition, the program will need to save student record as a single string to a vector of strings, one record at a time. When user is done entering records, program should display all the lines entered by the user to the screen. Things to consider when implementing the program: 1.write_file(vector<string> &v): (1)Open file for writing (2)check if file can be open for writing (due to memory problems) (3)Prompt user to enter student records. NOTE: number of records is unknown, so program must repeatedly prompt user…