Gimme Shelter Roofers maintains a file of past customers, including a customer number, name, address, date of job, and price of the job. It also maintains a file of estimates given for jobs not yet performed; this file contains a customer number, name, address, proposed date of job, and proposed price. Each file is in customer number order. Design the logic that merges the two files to produce one combined file of all customers whether past or proposed with no duplicates; when a customer who has been given an estimate is also a past customer, use the proposed data. (flowchart or pseudocode)

Gimme Shelter Roofers maintains a file of past customers, including a customer number, name, address, date of job, and price of the job. It also maintains a file of estimates given for jobs not yet performed; this file contains a customer number, name, address, proposed date of job, and proposed price. Each file is in customer number order. Design the logic that merges the two files to produce one combined file of all customers whether past or proposed with no duplicates; when a customer who has been given an estimate is also a past customer, use the proposed data. (flowchart or pseudocode)

Programming Logic & Design Comprehensive

9th Edition

ISBN:9781337669405

Author:FARRELL

Publisher:FARRELL

Chapter7: File Handling And Applications

Section: Chapter Questions

Problem 3PE

See similar textbooks

Similar questions

Given the 5 records below stored in a file, write a code snippet that will extract two elements (fields) from a single record into two separate variables. Use string functions to identify the delimeter and extract the sub strings. Show the declaration of variables. Mohammed Farook;56 Asiphe Ndokani;75 David Johns;62 Craig Smith;81 Katlhego Ntshidi;45
-Inventory given through picture -Language from C++03 The fill will have the following specifications: Each record consists of two lines. The first line contains the name of the product, which may be more than one word long. The second line contains the wholesale price as a decimal, the markup as a percentage, and three quantities, for counter, shelf, and warehouse. If the first line of a record contains the word END all by itself, that is the end of the file. Your task is to read each record into the program, as a string for the name, and numbers for the price and markup, and as an array of numbers for the quantities. Then calculate the total profit for each item: (wholesale price) * (markup, converted into a decimal) * (total quantity). Print out a report on one line for each item: Name, total profit. Format the output nicely: names should fit in 30 characters and the prices should line up and should have two decimal places. Hints: You’ll want to use getline to read multi-word…
Using the python code below. Identify the Variabale, Conditional Statement,Operators,Loops and Functions used in the code below. PYTHON CODE: file1 = open('database.txt', 'r') count = 0 name = [] age = [] dep = [] address = [] sr_code = [] status = [] condition = [] while True: count += 1 line = file1.readline() # if line is empty # end of file is reached if not line: break else: try: data = line.split(",") name.append(data[0]) age.append(data[1]) dep.append(data[2]) address.append(data[3]) sr_code.append(data[4]) status.append(data[5]) condition.append(data[6]) except: none = "" file1.close() def dataUp(): with open("database.txt", "w") as f: for i in range(0,len(name)): f.write(name[i]+","…
Give Advantages of using pointers in file organization as compare to sequential file organization.
Problem:A company has stock of many goods, and they want to filter the stock so that some of the materials can go on sale. The stock information recorded in a file"data.txt" as shown in the sample. (in the following sequence)(item name, price_perunit, profit, months_of_stocking, customer_reviews )The sale policy of the company depends on many factors according to the following. • if item in stock more than 8 months and item profit is more than average profit of all items o yes - if customer reviews low quality ● yes – sale 50% ● no – if customer reviews medium quality o yes – sale 30% o no – sale 15% o no- if item profit more than 8% of the item price ● Yes – if in stock more than 1 year o yes-sale 40% o no- not on sale ● No - not on sale Write a C++ program that reads the information from “data.txt” input file into 5 arrays, then processes these arrays to produce three arrays, first array holds the items on sale, second array holds percentage of sale , and the third one holds the…
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.
Suppose you have a text file named admission.txt that consists of applicants who have applied for admission in an IT institute. Data of file consist of multiple rows and each row represents one record separated by comma character in the following order. First Name Last Name CNIC Inter marks Percentage Age Phone Number Subjects in Inter (Major Subjects) There are 200 available seats for current session and first come first served model will be followed. Admission Eligibility criteria is: Percentage must be greater than 60 Age must be less than 30 Candidate must have studied Math/Stat or Computer in Inter. You are required to read and process the text file in a way that data of qualified candidates should be copied in a file qualified.txt. The data of new file must be comma separated…
393. File organization system that uses two files for every data file is said to be a. Cluster sequential files b. Indexed sequential files c. Cluster random files d. Indexed random files
Give the benefits of employing pointers in file organization over sequential file structure.
A database has four transactions. Let min sup = 60% and min conf = 80%.cust ID TID items bought (in the form of brand-item category)01 T100 {King’s-Crab, Sunset-Milk, Dairyland-Cheese, Best-Bread}02 T200 {Best-Cheese, Dairyland-Milk, Goldenfarm-Apple, Tasty-Pie, Wonder-Bread}01 T300 {Westcoast-Apple, Dairyland-Milk, Wonder-Bread, Tasty-Pie}03 T400 {Wonder-Bread, Sunset-Milk, Dairyland-Cheese}(a) At the granularity of item category (e.g., itemi could be “Milk”), for the ruletemplate,∀X ∈ transaction, buys(X,item1) ∧ buys(X,item2) ⇒ buys(X,item3) [s,c],list the frequent k-itemset for the largest k, and all the strong association rules(with their support s and confidence c) containing the frequent k-itemset for thelargest k.(b) At the granularity of brand-item category (e.g., itemi could be “Sunset-Milk”),for the rule template,∀X ∈ customer, buys(X,item1) ∧ buys(X,item2) ⇒ buys(X,item3),list the frequent k-itemset for the largest k (but do not print any rules).
Question 5: Complete the below function that takes the name of two files, inFilename and outFilename as arguments and reads the text from the inFilename. In this file each line contains the Turkish Republic Identity Number (TCNO), name, surname and telephone number of a person. Your function should sort all persons according to their TCNO, write the sorted data into outFilename. If the file inFilename does not exist, then the function must create an empty file named outFilename. For example, if the function is called such as readText("in.txt", "out.txt") and in.txt is as follows: ===== in.txt ===== 12345678904 Barış Manço 0555-999-99-66 12345678902 Ahmet Kaya 0555-999-99-88 12345678901 Burkay Genç 0555-999-99-99 12345678903 Erkin Koray 0555-999-99-77 ================== Then, the function writes the sorted information into "out.txt" as follows: ===== out.txt ===== 12345678901 Burkay Genç 0555-999-99-99 12345678902 Ahmet Kaya 0555-999-99-88 12345678903 Erkin Koray 0555-999-99-77…
Do not copy paste from any source else downvote Write a void function that will merge the contents of two text files containing chemical elements sorted by atomic number and will produce a sorted file of binary records. The function’s parameters will be three file pointers. Each text file line will contain an integer atomic number followed by the element name, chemical symbol, and atomic weight. Here are two sample lines: 11 Sodium Na 22.99 20 Calcium Ca 40.08 The function can assume that one file does not have two copies of the same element and that the binary output file should have this same property. Hint: When one of the input files is exhausted, do not forget to copy the remaining elements of the other input file to the result file.