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
Transcribed Image Text:If the person_name is found in the file, and has no children (e.g. Baker_Jill shown above), the output is:
Person Information for Jill Baker:
Born: Melbourne
Date of Birth: 08-09-1973
Children: None
• If the person_name is NOT found in the file, the expected output is shown below. For example, for the name Smith_John Which is
not contained in filename the output is:
Person John Smith: information not found
377344.2021754.qx3zqy7
LAB
17.3.1: Challenge Exercise II
0/5
АCTIVITY
Downloadable files
person_info.csv
Download
main.py
Load default template...
1 ############*#
2 # Complete this function
###
3 ################################
4 def print_person_from_file(person, filename):
5
#3
# your code goes here
#3
7
return
9
10
11 if
-name__
'-_main__':
12
try:
13
person
input()
14
print_person_from_file(person, 'person_info.csv')
15
except FileNotFoundError:
print('File not found error.\n')
16
17
Transcribed Image Text: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 shown below. For the following call:
print_person_from_file (Fletcher_Margaret, person_information.csv)
the expected output is:
Person Information for Margaret Fletcher:
Born: Sydney
Date of Birth: 30-09-1921
Children:
Bob Green
Nancy Green
Tom William
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 with 2 images
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
- Option 2: Display the Record of a particular PatientWhen a user selects option 2, The main function prompts for and reads a PatientID. Then it calls the thefunction getPatient(patientID), which then searches for this PatientID in the text-file. If the Patient is notfound, an appropriate error message is displayed, otherwise; the Patient’s information is displayed. Inboth cases, the option waits for the Enter key to be pressed before returning control to the main menu.Please select your choice: 2Enter Patient ID: 1002Patient ID Patient Name Weight Ave. Weight Visits1002 Majed Sameer 18 .6 18 .2 2Press Enter key to continue . . .Please select your choice: 2Enter Patient ID: 1552Error: Invalid PatientPress Enter key to continue . . . Option 3: Display all Patient WeightIt prompts for- and reads a maximum weight from the user. Then it displays all patients with weight lessthan or equal to the give weight. Also, it displays the percentage weight increase (with a + sign) ordecrease (with a…arrow_forwardcode this file with c programming to output and file comprasionarrow_forwardBody 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…arrow_forward
- C++ Visual Studio 2019 Write a program that asks the user for the name of a file. The program should display the contents of the file on the screen. Each line of screen output should be preceded with a line number, followed by a colon. The line numbering should start at 1. Here is an example: George Rolland 127 Academy Street Brasstown, NC 28706 If the file's contents won't fit on a single screen, the program should display 24 lines of output at a time, and then pause. Each time the program pauses, it should wait for the user to strike a key before the next 24 lines are displayed. Note: Save text below as the file to use and name it forChap12.txt file for this assignment. The line numbers should NOT be reset for each screen. Text: No one is unaware of the name of that famous English shipowner, Cunard. In 1840 this shrewd industrialist founded a postal service between Liverpool and Halifax, featuring three wooden ships with 400-horsepower paddle wheels and a burden of 1,162 metric…arrow_forwardWord Puzzle GameIn this assignment is only for individual. You are going to decode the scrambled word into correct orderin this game. One round of play is as follows:1. Computer reads a text file named words.txt2. Computer randomly picks one word in the file and randomly scrambles characters in the wordmany times to hide the word3. Computer displays the scrambled word to user with indexes and gives the user options to1. Swap two letters in word based on index given2. Solve the puzzle directly3. Quit the game4. If a player chooses to swap letters, the computer reads two indexes and swaps the letters. Thegame resume to step 3 with the newly guessed word. If the resulted word after swapping is thesecret word, the game is over.5. If a user chooses to solve directly, computer prompts the user to enter the guessed word. If it’scorrect, the game is over, otherwise goes to step 3.6. After game is over, display how many times the player has tried to solve the puzzle.The following is sample…arrow_forwardC Sharp Random Number File writer and Reader Create an application that writes a series of random numbers to a file. Each random number should be in the range of 1 through 100. The application should let the user specify how many randome numbers the file will hold and should use a SaveFileDialog control to let the user specify the file's name and Location. Create another application that uses an OpenFileDialog control to let the user select the file that was created above. This application should read the numbers from the file, display the numbers in a ListBox control and display: the total of the numbers and the number of random numbers read from the file.arrow_forward
- BAGGINS 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_forwardC++arrays, c-strings, functions with arrays as parameters 1. Create a file that contains 20 integers or download the attached file twenty_integers.txt Create a program that: 2. Declares a c-style string array that will store a filename. 3. Prompts the user to enter a filename. Store the file name declared in the c-string. 4. Opens the file. Write code to check the file state. If the file fails to open, display a message and exit the program. 5. Declare an array that holds 20 integers. Read the 20 integers from the fileinto the array.6. Write a function that accepts the filled array as a parameter and determines the MAXIMUM value in the array.Return the maximum value from the function (the function will be of type int).7. Print ALL the array values AND print the maximum value in the array using a range-based for loop. Use informational messages.Ensure the output is readable.arrow_forwardFile Handling Assignment -2 Write a program to generate a file numbers.txt that contains the first 50 odd natural numbers and each line in the file should contain 5 numbers only. Attach the screenshot of numbers.txt. In C or C++arrow_forward
- Add comments for Program 04arrow_forwardpython 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_forwardDefine the following data structures: Record File Array Stringarrow_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