Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Related questions
Question
Using C# Programming Language
Please display all code and steps for the following program. Store the data of (Customer#, Order#, OrderQty, UnitPrice) has shown below int a text file named Order.txt to be processed.
| Customer# | Order# | OrderQty | UnitPrice |
| 0155 | 76533 | 3 | 10.95 |
| 0140 | 75446 | 12 | 8.50 |
| 0150 | 75550 | 1 | 89.95 |
| 0145 | 75648 | 25 | 2.50 |
| 0130 | 76360 | 5 | 17.90 |
- Create a form, ProcessOrder, that reads each order record, computes the extended cost, and displays
- Cust#, Order#, OrderQty, UnitPrice and ExtendedCost in a ListBox, with the columns aligned.
- An extended cost is the unit price multiplied by the order quantity
- Use a button, named btnDisplayOrders, to display orders (i.e., the records in the data file, Order.txt) – use Resize() method (in case the data file is large)
- Use another button, named btnDisplayExtendedCosts, to display the extended cost of each order (including the original 4 data items)
- Use 4 TextBoxes to allow the user to enter a new order (including its Customer#, Order#, OrderQty, and UnitPrice)
- Use the 3rd button, named btnSaveToFile, to write the new order to the data file, Order.txt – NOTE: do NOT overwrite the existing orders
- Incluse a Clear button and an Exit button
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- In cell B17, enter a function that will count the number of locations the Job Fair was held in 2022.arrow_forward/** * @file main.cpp * @brief This is the main file for the baseball champions program * @author Connor Melton * @date March 12, 2013 * */// INCLUDE THE HEADER FILES NEEDED FOR THE FUNCTIONS TO WORK#include "baseball.h" int main(){ ifstream teamFile; teamFile.open("./Teams.txt"); string teams[30]; int teams_count = 0; while (getline(teamFile, teams[teams_count])) { teams_count++; } teamFile.close(); ifstream winnersFile; winnersFile.open("./WorldSeriesWinners.txt"); // 1. Check if file opened successfully, if not exit the program // 2a. Declare an array of strings to store data for world series winners // 2. Load data from winnersFile to an array by calling loadWinnersFromFileToArray // 3. Close the file stream // Read the instructions on what else you need to finish this program string winners[65]; int winnersCount = 0; while (getline(winnersFile, winners[winnersCount])) { winnersCount++; }…arrow_forwardTraceback (most recent call last): File "C:/app.py", line 20, in main() File "C:/app.py", line 17, in main print_report() File "C:/app.py", line 12, in print_report print_id() File "C:/app.py", line 6, in print_id message = "Your id is:" + id num TypeError: must be str, not int Process finished with exit code 1 Given this stack trace above, on what line was the exception raised? O Line 17 O Line 12 O Line 6 O Line 20arrow_forward
- >> classicVinyls.cpp For the following program, you will use the text file called “vinyls.txt” attached to this assignment. The file stores information about a collection of classic vinyls. The records in the file are like the ones on the following sample: Led_Zeppelin Led_Zeppelin 1969 1000.00 The_Prettiest_Star David_Bowie 1973 2000.00 Speedway Elvis_Presley 1968 5000.00 Spirit_in_the_Night Bruce_Springsteen 1973 5000.00 … Write a declaration for a structure named vinylRec that is to be used to store the records for the classic collection system. The fields in the record should include a title (string), an artist (string), the yearReleased (int), and an estimatedPrice(double). Create the following…arrow_forwardBAGGINS Trucking maintains a trip file in which each record contains the following data:DRIVER nameMILES driven on tripHOURS driven on trip Design an application that inputs records from the file (until reaching "eof") and, for each record, displays the DRIVER's name and the average Miles-per-Hours (MPH) for the trip where MPH is calculated by dividing the MILES by the HOURS. The program should also accumulate a GRAND total of the MILES driven. At the end, the program should display the GRAND total of the MILES driven. For example, if the trip file contained the following:Smith, 300, 5Williams, 750, 10Jones, 880, 11 then the program should display:Smith averaged 60 mphWilliams averaged 75 mphJones averaged 80 mphGrand total of miles is 1,930 Pseudocode:arrow_forwardThe following is a sample of the order data (Customer#, Order#, OrderQty, UnitPrice) to be processed. Store the data in a text file named Order.txt. You may use Notepad to enter the data. 0155, 76533, 3, 10.950140, 75446, 12, 8.500150, 75550, 1, 89.950145, 75648, 25, 2.500130, 76360, 5, 17.90Create a form, ProcessOrder, that reads each order record, computes the extended cost, and displays Cust#, Order#, OrderQty, UnitPrice and ExtendedCost in a ListBox, with the columns aligned.arrow_forward
- python function that creates and saves data in a file. the saved data represents exam grades. in the function , you will create n random numbers in the range 1-100, where n is the number of students. The function can be called as follows: createFile(filename, n) main function, in which the user inputs the file name and the number of students, then the main calls function createfile. the main should preform validation for n (should be > 0), and the filename(should end with .txt)arrow_forwardPYTHON PROGRAMMING LANGUAGE Create a new text document called names.txt (this is done by hand - not using programming) with the following names: Adam, Bryan, Charlie. Each name should be followed by a hard return (do not store them in a list). Main Function. Write a program where the user enters a name. Using the read function, check to see if the name is in the text document. If it is, respond back to the user the name is found within the list. Read Function. The read function should return the contents of the text document as a list. Write Function. The write function should take the list and override the file with the new names list in reverse alphabetical order with a hard return after each name. EXAMPLEPlease enter a name: AdamAdam is found in the list.Enter another name (Y/N): YPlease enter a name: AndrewSorry, Andrew was not found in the list. Would you like to add it? (Y/N): YAndrew has been added to the list.Enter another name (Y/N): N LIST EXAMPLEadambryancharlie Final…arrow_forwardPlease let me know the code for this as I am not able to upload the JSON file The JSON fileprovided, climate.json contains monthly climate data of over one hundred destinations and includes average high and low temperature, dry days, snow days, and rainfall, for every month.Program TasksWrite a program display Climate.py that performs the following functionalitiesa. reads the JSON file climate.jsonb. displays the cities as a listc. prompts the user to enter a city or citiesd. searches for the relevant data and display ((i) the average rainfall for each month as a list(ii) minimum and maximum rainfall per year.(iii) the average rainfall per year.A brief introduction to the JSON fileStructure of the climate JSON file:• JSON data works just like python dictionary and you can access the value usingdictionaryName[key]• The JSON file contains a list of 104 dictionary items and each dictionary item has 4 keys.• The monthlyAvg key has a list as its value, which in return contains 12…arrow_forward
- C programming language Criteria graded: Declare file pointers Open file Read from file Write to file Close file Instructions: Write a segment of code that opens a file called “numbers.txt” for reading. This file is known to have 10 numbers in it. Read in each number and print a ‘*’ to the screen if the number is even. If the number is odd, do nothing. Conclude by closing this file.arrow_forwardprepare a flowchart please # inside data sub subarray[serial, name, amount]; # My data; data = [['01','A',4000],['02','B',8000],['03','C',10000],['04','D',12000],['05','E',16000]] serial = 0 name = 1 amount = 2 #update.... total = 0; for i in data: total = total+i[amount] print(f"The total amount is: {total}")arrow_forwardDesign an application for the ABC Company that will process inventory from a file called ABC_Inventory.txt (attached to this assignment). The file contains Item ID, Description and list price stored on a separate line in the file. The program should display the contents of each record and then calculate and display the average list price. it is important that this is done in Thonny for python warrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON 
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education