3. Laramie Park District has files of participants in its summer and winter programs this year. Each file is in participant ID number order and contains additional fields for first name, last name, age, and class taken (for example, Beginning Swimming). a. Design the logic for a program that merges the files for summer and winter programs to create a list of the first and last names of all participants for the year in ID number order.

3. Laramie Park District has files of participants in its summer and winter programs this year. Each file is in participant ID number order and contains additional fields for first name, last name, age, and class taken (for example, Beginning Swimming). a. Design the logic for a program that merges the files for summer and winter programs to create a list of the first and last names of all participants for the year in ID number order.

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

Parson's Problem Rearrange the code blocks below into the proper order by dragging drop them in the yellow box below. Tip: The program using struct will accept input for the records such as id, name and rate. Note: NOT all of the code blocks will be used. Drag from here int id; printf("Name: "); #include printf("Rate: "); ); int rate; printf("ID: "); scanf("%d", &emp.id); { printf("Name: "); scanf("%s", &name); { } void main() Struct Records emp; }; Structure Records #include scanf("%d", &emp->id); struct Records employee; Struct Records employee; scanf("%d", &emp.rate); scanf("%d", &id); printf("ID: "); struct Records struct Records emp; Struct Records scanf("%s", &emp.name); char name[50]; scanf("%d", &rate); int rate; scanf("%s", &emp->name); structure Records scanf("%s", &emp.name); scanf("%d", &emp->rate); int main() printf("Rate: "); char name [50]; scanf("%d", &emp.rate); { { scanf("%d", &emp.id); }; struct Records emp; int id; Construct your solution here Check It!
Complete the following sentence. If more than one function is present in a file, the top function is a normal or function, while the ones below it are called local functions.
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…
Problem 4 a. Import into MATLAB the US_Presidents.xlsx file using readtable() You'll find this file on Canvas 1 b. Convert the columns containing date to MATLAB's datetime format. You will certainly need to lookup details on the datetime function documentation page. An example of how to do this might be: datetime(POTUS_Table.BirthDate,'InputFormat, 'yyyy-MM-dd') c. Use this to determine who was the longest living president (i.e. who died at the oldest age) Note: Use 30 days in a month and 365 days in a year for any age conversions
Please help me write the following function (see the photos for context of the problem): follow_trail(filename, treasure_map, start_row, start_col): Takes as inputs a string corresponding to a filename, a list of lists corresponding to a treasure map, and two non-negative integers representing a row and column index. Follows the trail in the given treasure map, starting at the given row and column index. Following the trail means to look at each character of the trail and perform the appropriate operation for that character: '>', '<', 'v', ' ∧': Continues following the trail by moving to the character to the right, left, below or above the current trail character, respectively. '.': Creates a new map file, with 'new_' prepended to the current map filename, and stores the same treasure map but with an X at the current position. Then, returns a tuple of three elements: the first being -1, and the latter two being the current row and column index. '*': Returns a tuple of three…
Write a complete program in C to solve this problem.
Write SAS code for the following task: 1) Read in the excel file "Data.xlsx" to create a temporary SAS dataset 2) Based on the DOB column, create a new column called Age 3) Based on Admission Date and LengthOfStay, create a new column called DischargeDate 4) Based on BaseCharge and DiscountRate, create a new column called DiscountAmount 5) Based on DiscountAmount and BaseCharge, create a new column called TotalCharge 6) Remove the LengthOfStay and DiscountRate columns and ensure all columns, including the original and new, are in the correct format to represent the data, i.e., date, money 7) Checking the data type and displaying the final data table with PROC CONTENTS and PROC PRINT 8) The final dataset should be exported as a csv file named "Output Data.csv"
Question 4: Complete the below function that takes a file name and a list as arguments and reads the text within the corresponding file, then creates a dictionary whose keys are the characters of the provided list, and the values are the counts of these characters within the text. If a character in the list is not included in the text, "0" should be written in the dictionary as the value of this character. The function returns the created dictionary as a result. If the file does not exist, then the function returns an empty dictionary. Here is an example case, assuming a file named "sample.txt" exists with the following content: sample.txt This is an example sentence. This is yet another sentence. ----. >> text2dict("sample.txt", ['a', 'b', 'c', 't']) {'a':3, 'b':0, 'c':2, 't':4} def text2dict(filename, characters):
please answer in the C program
Question 3. We want to implement a flex like system to carry information about students and the courses they are currently enrolled in. The input data will be present in two text files called student.txt and courses.txt. The structure of the student.txt file will be (rollnumber, name, date of birth , batch, major) as shown below: 18L-1112, Ali Maqsood, 02-feb-2000, 20, CV 19L-2113, Haider Saqib, 31-Mar-1999, 19, CS 20L-1111, Fatima Ahmed, 01-Jan-2000, 20, EE The structure of the courses.txt file will be (rollnumber, course code, coursename, credit hours) 18L-1112, CV314, Soil Mechanics, 3 19L-2113, CS210, Data Structures, 3 19L-2113, CS213, Databases, 3 19L-2113, CS217, Analysis of Algorithms, 3 20L-1111, EE111, Circuit Analysis, 3 201-1111. CSL10. Introduction to Computing. 2 As shown above both the files will be sorted by the rollnumber and a student could be enrolled in any number of courses. Your system should be able to cater for any number of students. You have to i. Decide the…
Assignment 2 will require Array of records (structs) with file I/O is needed. the program will read its data from a text file named coins.txt. There can be 0 and up to 10 input lines, each line is formatted like the example below; Jane 30 cents in AU$ Joe 85 cents in EUR Jane 15 cents in US$ Names are one-word strings. The same name can be repeated in the data file but the coin values/currencies can be different. If the name is the same, your program must assume it relates to the same individual. You are asked to write a program that reads the data from this file. For each individual, the program must add up the coin amounts that belong to the same currency to obtain a total amount for that individual in that currency. It needs to compute the change to be given for that individual for each currency that individual owns. e.g, the example above shows Jane has 30 + 25 = 55 cents in AU$ and 15 cents in US$. The program needs to calculate how many coins (hereinafter referred to as change)…