Write a program that enters data of 10 bank accounts and write on a file Account.txt file. Account (Account_No, First Name, Last Name, Balance, Account_Type). Then read data from Account.txt file and display the Account Details, which have the Highest Balance among the Account Type of "Current". Note: You Can enter following Account Type: Current, Saving, Freedom, Islamic Your program should work as following: Enter Account No, First Name, Last Name, Balance, Account Type? 1001 Muhammad Ali 15000 Current Enter Account No, First Name, Last Name, Balance, Account Type? 1002 Sarmad Aziz 25000 Saving Enter Account No, First Name, Last Name, Balance, Account Type? 1003 Mubashir Ramzan 17000 Current Up to 10 records.. Then display the final output: Account No 1003 First Name Mubashir Last Name Ramzan Balance 17000 Account Type Current

Write a program that enters data of 10 bank accounts and write on a file Account.txt file. Account (Account_No, First Name, Last Name, Balance, Account_Type). Then read data from Account.txt file and display the Account Details, which have the Highest Balance among the Account Type of "Current". Note: You Can enter following Account Type: Current, Saving, Freedom, Islamic Your program should work as following: Enter Account No, First Name, Last Name, Balance, Account Type? 1001 Muhammad Ali 15000 Current Enter Account No, First Name, Last Name, Balance, Account Type? 1002 Sarmad Aziz 25000 Saving Enter Account No, First Name, Last Name, Balance, Account Type? 1003 Mubashir Ramzan 17000 Current Up to 10 records.. Then display the final output: Account No 1003 First Name Mubashir Last Name Ramzan Balance 17000 Account Type Current

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

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…
A MyPetStore sells many pets and their accessories. As new pets are added to the MyPetStore, theirinformation is entered into a flat text file. Each month, the manager requests a listing of all pets sorted bytheir price. You must write a program to produce a report of MyPetStore and their types sorted by their pricesfrom the data in the flat text file. Below is a description of the information on the text file:• The first entry is the number of animals on the file (numeric) •The fields below repeat for each animal:o Pet name (String)o Birthdate (java.time.LocalDate)o Price (numeric)o Species Type (String)o Special feature (boolean or String)The animals sold by the MyPetStore are of six types: Dogs & Cats, Reptiles, Birds, Rabbits & SmallAnimals.For Dogs & Cats, the special feature field on the flat file is the breed of the animal (String).For Reptiles, the special feature field is the blood type (warm vs cold-blooded, String).For Birds, the special feature field is the…
IN C++ VISUAL STUDIO Create two classes one to read data from file, and the other to write data into a file. The data can be about employees having information about employee name, id and designation. You must create a class for employee. There is a total of 3 classes in your program. In the second class, which is about file writing, you have to write data about 10 employees in file. You can get data from user. In reading class, you have to read information about a specific employee whose id is given by user. Finally write a function to show data about employees whose designation is “manager”.
Create a file in your project named employees.txt with the following data (you can simply create the file by hand rather than with Python code): 123 Bob Smith345 Anne Jones256 Carol Lee845 Steve Robert Anderson132 Jill Thompson From your program's main function, give the user the following options: lookup a name based on ID number, lookup an ID number based on name, and quit the program. OPTION 1: The user chooses to lookup a name based on ID number: Use a try/except and ask the user to enter an integer. If they don't enter an integer, print an error message. If they do enter an integer, call a function named lookup_employee which takes the id as a parameter. If an employee with the given id number is found, return the name. Otherwise, return the string “Employee not found” Back in main, print the return result. OPTION 2: The user chooses to lookup an ID based on name: Ask the user to enter the first and last name (don't ask for the middle name). Call a function named…
Python Please! Create a program that will allow a user to do either of the following things: Get input from the user to write the following information to a file: Student name Assignment average grade Mid-term test grade Fi-nal project grade Fi-nal test grade Allow the user to search the file by student name and output a weighted average (15%, 25%, 25%, and 35%, respectively) based on the grades for that student in the file. The user should be able to choose either of the two options until they want to stop.
Task: Loading data from files This exercise will require you to load some information from files and use it in your program. scene.txt contains a description of a series of shapes and colours to draw. You need to write code to read in the file data and draw the requested shapes in the correct colour. Each line in scene.txt will contain one of the following starting keywords followed by some data:  COLOUR followed by 3 values: R, G, B  CIRCLE followed by 3 values: X, Y, RADIUS  RECT Followed by 4 values: X, Y, W, H  LINE Followed by 4 values: X1, Y1, X2, Y2 CIRCLES are defined from the center. RECT's are defined from the top left. All values are space separated, and you can assume all input is correct (no errors). Please solve this program to draw the scene. I can't upload the file scene.txt, so I decide to screenshot a file for you. Subject: Java Programming
Program a python program that demonstrates reading and comparing Create a python program that demonstrates reading and comparing multiple files, processes the input files based on the business rules, and produces an output file. Needed Files 1. The timeclock.txt Download timeclock.txtfile contains the hours worked data for every employee as well as the shift they worked. The layout for the file is as follows: EMPLOYEE_NUMBER, HOURS_WORKED, SHIFTTimeclock.txt 22476, 45, 3 24987, 30, 148283, 50, 285437, 25, 3 2. The personnel.txt Download personnel.txtfile contains the names of all employees and their hourly pay rates. The layout for the file is as follows: EMPLOYEE_NUMBER, EMPLOYEE_NAME, PAY_RATEPersonnel.txt 11235, Bob Smith, 10.50 22476, John Roberts, 12.3524987, Mary Johnson, 15.9032743, Brad Carson, 11.2548283, Alice Martin, 14.2085437, Aaron James,15.15 Note: Both the timeclock.txt and payroll.txt files are pre-sorted by EMPLOYEE_NUMBER in ascending order. Business…
Data File: Example #1AAAAABBBBBCCCCCDDDDDAAEBCBAFBBCDCECDADDEFEEFFFExample #2AAATAABTBBBBCCCCTCDDTDDDAASAABBSBBCCSCCDSDDDEEEAEEFBFFFDDF Write a program that will give the user a brief introduction, then allow the user to type in the name of the file to be analyzed, the name of the data file to generate, and then process the data to match the output that is shown below. This DNA test measures the various parts of the sequence and assigns them a letter. While the letters could be anything from A to Z, the only letters that matter for this test are the letters {A,B,C,D} all other letters can be ignored completely. A sample will be tested, given a length of time and then tested again. Each time the scientist will generate a line of data. Here is one Example: Example #1 AAAAABBBBBCCCCCDDDDD AAEBCBAFBBCDCECDADDEFEEFFF At first glance the sample looks significantly different after the second test. But if you look at the data, you will note that since we only care about A,B,C,D’s that the…
Body Mass Index Write a program that reads names, weights, and heights from bmi.dat (provided with starter code; do not change the file name). Use the information to calculate and displays a person’s body mass index (BMI). The BMI is often used to determine whether a person with a sedentary lifestyle is overweight or underweight for his or her height. A person’s BMI is calculated with the following formula: BMI = weight × 703 / height2 where weight is measured in pounds and height is measured in inches. The file is in the format name weightInKG heightInCM You will read the name, weight and height for 4 people from the file, and you will need to convert the weights in the file to pounds (note that 1 kilogram = 2.2 pounds) and the heights to inches (2.54 cm = 1 inch). The program should display the person's name along with the calculated BMI and a message indicating whether the person has optimal weight, is underweight, or is overweight. Your output should look like A person’s weight…
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…
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…
Write the code in python Create an application that can create, display, search and maintain the book information for a bookstore. Requirements: 1) you need to use functions to write code for each menu item. 2) Information of books will be saved in a file, e.g,, books.txt. 3)User can add any number of books to the booklist. There can be 5 books or 500 books. In order for your program to handle it without any changes in the code, you cannot hardcode the number of books in your program.