ISC/ITE 285 – Stream Writer In Class ExerciseTracing the variables, files & location pointerFor this exercise, we will be working with a text file that holds students' course averages. Each record is madeof 2 fields: JagNumber and Course Average. The current records in "Average.txt" file are:upJ00768567,98.54J00546344, 72.35J00123565,89.20Add Event Code:Dim jagNumber As StringDim average As DecimalGetInput (jagNumber, average)Dim record As StringrecordNewCSV(jagNumber, average)IO. File. AppendText("Average.txt")Dim sw As StreamWritersw. Writeline(record)sw.Close()Sub GetInput reads values in from textboxes into variables. The inputted value for jagNumber is J00998877.The inputted value for average is 92.50.Function NewCSV created a comma separated value record using the two inputted fields.Walk through the code and show the values for the variables and location pointer as the code is executed.Average.txtJO0768567,98.54J00546344,72.35J00123565,89.20JO0998877,92.50jagNumberaveragerecord

Dear Student, the code walkthrough has been marked as comments Dim jagNumber As String Dim //…

ng For this exercise, we will be working with a text file that holds students' course averages. Each record is made up of 2 fields: JagNumber and Course Average. The current records in "Average.txt" file are: J00768567,98.54 J00546344,72.35 J00123565,89.20 Add Event Code: Dim jagNumber As String Dim average As Decimal GetInput (jagNumber, average) Dim record As String record = NewCSV(jagNumber, average) Dim sw As StreamWriter = I0.File.AppendText("Average.txt") sw.Writeline(record) sw.Close() Sub GetInput reads values in from textboxes into variables. The inputted value for jagNumber is JO0998877. The inputted value for average is 92.50. Function NewCSV created a comma separated value record using the two inputted fields. Walk through the code and show the values for the variables and location pointer as the code is executed. Average.txt J00768567,98.54 J00546344,72.35 J00123565,89.20 J00998877,92.50 jagNumber average record

ng For this exercise, we will be working with a text file that holds students' course averages. Each record is made up of 2 fields: JagNumber and Course Average. The current records in "Average.txt" file are: J00768567,98.54 J00546344,72.35 J00123565,89.20 Add Event Code: Dim jagNumber As String Dim average As Decimal GetInput (jagNumber, average) Dim record As String record = NewCSV(jagNumber, average) Dim sw As StreamWriter = I0.File.AppendText("Average.txt") sw.Writeline(record) sw.Close() Sub GetInput reads values in from textboxes into variables. The inputted value for jagNumber is JO0998877. The inputted value for average is 92.50. Function NewCSV created a comma separated value record using the two inputted fields. Walk through the code and show the values for the variables and location pointer as the code is executed. Average.txt J00768567,98.54 J00546344,72.35 J00123565,89.20 J00998877,92.50 jagNumber average record

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

Create a class of records for a gradebook called Rec. The data should be private, and should include a firstname, lastname, array of three grades, and a field for average grade. Build two constructors: a default constructor and a constructor that takes the first and last name. Build a function to read the data, either from a file or from cin. The read function reads the two names and three grades, but does not read the average grade. Build a write function that writes the data either to a file or to cout. The write function prints all of the data on one line with spaces between fields. Build a function to calculate the average grade field. I will provide you with a driver called hw1.cpp in ~cthorpe/public/142 and with a test file HW1.txt in the same directory HW1.txt contains: Pete Jones 1 2 4 This is what I have done so far: #include <iostream>#include <fstream>#include <string> using namespace std; class Rec {private:string fname;string lname;int grades[3];int…
The 2 pictures are the beginning of the lab. The below is for part 2. read_file(0, clear_file); // Read in a file with of unknown length, getting the length from the file read. clear_file is a string containing the path to the clear text file. This function returns a char array created with memory allocation. read_file(len, clear_file); // Where len > zero, reads len chars from a file. clear_file is a string containing the path to the clear text file. This function returns a char array created with memory allocation. write_file(0, key, key_file); // Writes a string to file until the \0 char is reached. key is the string of random chars and key_file is a string containing the path of the text file. write_file(len, cipher, cipher_file); // Where len > zero, writes len chars to a file. cipher is the cipher string of chars and cipher_file is a string containing the path of the text file. The menu in main() should look like: Encrypt a file: 1Decrypt a file: 2Exit:…
First programming homework Create a class of records for a gradebook called Rec. The data should be private, and should include a firstname, lastname, array of three grades, and a field for average grade. Build two constructors: a default constructor and a constructor that takes the first and last name. Build a function to read the data, either from a file or from cin. The read function reads the two names and three grades, but does not read the average grade. Build a write function that writes the data either to a file or to cout. The write function prints all of the data on one line with spaces between fields. Build a function to calculate the average grade field. Build an overloaded operator == to compare two records. This should be implemented as a friend function. Declare the constructors and functions in the body of the class, but implement them outside the class. I will provide you with a driver called hw1.cpp in ~cthorpe/public/142 and with a test file HW1.txt in the same…
Print Person Information from file In this lab you are asked to complete the function : print_person_from_file(person_name, filename). This function should read in data from the file filename and print the information for person_name if it is found in the file. The file filename contains lines, in comma separated format (with a 'csv' extension) For each line, the items in each field are as follows: Field 1 3 4 Name Place of Birth Date of Birth Children For Children: • a person can have 0, 1 or multiple Children Multiple children are semi-colon separated If a person has no children the field contains 'NA' For example, consider the following lines froma .csv file, where Fletcher_Margaret has 3 children, and Baker_Jill has 0 children (field 4 contains the string 'NA') Fletcher Margaret,Sydney,30-09-1921,Green Bob;Green Nancy;William Tom Baker_Jill, Melbourne,08-09-1973, NA Format for Printing If the person_name is found in the file, the format for printing the person information is as…
Python - Next Birthdate In this task, we will write a program that reads birthdate data from a given CSV file, and given the current date, determines which person's birthday will be celebrated next. Create a function with the following signature: nextBirthdate(filename, date) filename: parameter, which represents the CSV filename. date: parameter, which represents the current date. The function should open the CSV file, read the birthdate data, and determine which person's birthday will be celebrated next, given the current date. The name of the person should be returned. In other words, given a date, find the person whose birthday is next. Sample Run birthdates.csv Draven Brock, 01/21/1952 Easton Mclean, 09/02/1954 Destiny Pacheco, 10/10/1958 Ariella Wood, 12/20/1961 Keely Sanders, 08/03/1985 Bryan Sloan,04/06/1986 Shannon Brewer, 05/11/1986 Julianne Farrell,01/29/2000 Makhi Weeks, 03/20/2000 Lucian Fields, 08/02/2018 Function Call nextBirthdate("birthdates.csv", "01/01/2022") Output…
Milestone #1 - Ask Quiz Type In a file called main.py, implement a program that asks the user for a quiz type and prints the file name for that quiz type. The program should have one input prompt: the integer value of the personality quiz number. Your program should print the welcome message and the list of the personality quizzes, ask for the test number, and then print the file name. You are required to use the provided dictionary with the personality quizzes names. The list of the personality quizzes should be printed in alphabetical order. See example below. Welcome to the Personality Quiz! What type of Personality Quiz do you want to run? 1 BabyAnimals 2 Brooklyn99 3 Disney 4 Hogwarts 5 MyersBriggs 6 Sesame Street 7 - StarWars 8 - Vegetables
DescriptionWrite a program to compute average grades for a course. The course records are in a single file and are organized according to the following format: each line contains a student's first name, then one space, then the student's last name, then one space, then some number of quiz scores that, if they exist, are separated by one space. Each student will have zero to ten scores, and each score is an integer not greater than 100. Your program will read data from this file and write its output to a second file. The date in the output file will be nearly the same as the data in the input file except that you will print the names as last-name, first-name; each quiz score, and there will be one additional number at the end of each line:the average of the student's ten quiz scores.Both files are parameters. You can access the name of the input file with argv[1]. and the name of the output file with argv[2].The output file must be formatted as described below: 1. First and last names…
### QUESTION FIVE ### def select_lines_from_file(filename, query): pass
Part B - reading CSV files You will need a Python repl to solve part B. Define a Python function named cheapest_rent_per_state that has one parameter. The parameter is a string representing the name of a CSV file. The CSV file will be portion of a dataset published by the US government showing the median (middle) rent in every county in the US. Each row in the CSV file has the same format Area Name, Efficiency, 1-Bedroom, 2-Bedroom, 3-Bedroom, 4-Bedroom, State Code The data in the Area Name and State Code columns are text. The data in all of the other columns are decimal numbers. Your function will need to use the accumulator pattern to return a dictionary. The keys of that dictionary will be the state codes read in from the file (state codes are at index 6). For each key in the dictionary, it's value should be the smallest median rent for an efficiency in that state (median rents for an efficiency are at index 1). Important Hints: * You will really, really want to use the built-in csv…
In python please! I am struggling
A movie file has the following record structure:name ofthe movie producer director type productioncostAssume that the name of the movie is the primary key of the file. Thefield type refers to the type of the movie, for example, drama, sci-fi, horror, crimethriller, comedy and so forth. Input a sample set of records of your choice into themovie file.i) Implement a primary index-based ISAM file organization.ii) Implement secondary indexes on director, type and productioncost.
Add Dist.txt functions in this code Note: Whenever a vaccine is distributed to hospitals, its code and the quantity distributed need to be recorded into a text file named as dist.txt. Each vaccine is expected to be distributed more than once. Hence, while testing the program, there should be at least 10 records created in the dist.txt file. Produce a list of all vaccines and their distributed quantities . The system should allow the employees to list all distributed vaccines and their accumulated quantities read from the dist.txt file.Note: The vaccines and their distributed quantities need to be sorted descendingly (with highest quantity listed first followed by second highest and so on) using Bubble sortbefore displaying on the screen #include <stdio.h> #include <stdlib.h> #include <string.h> // Function Declarations void create_inventory(); void update_vacc_qty(); int search_vaccine(); void display_vaccine(); // Main Function starts here int main() {…