Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

Question

3.5: This problem will require your program to read a file of student records.
Before you the coding part, manually create a text file named cs521_3_5_input.txt Populate the file with rows of comma separated records in of the format:

  Name of Student

  Student ID

  GPA

For example (you can use your own names and data): Jerry Seinfeld, 1, 3.7
Elaine Benes, 52, 2.8
George Costanza, 13, 3.9

Cosmo Kramer, 24, 3.4

Now write a python program that performs the following steps:

a. Open and read the file created above line by line

 The text file must be stored in the same directory as your program

Parse the data in each row (records of one student) into a 3 element tuple

Store each tuple in a single list, making an array that will contain all student records

After the input file is completely processed, print the list of tuples

  Include an appropriate description

  The list object does not need to be formatted

  There is no output file!

Example Output:
Student Records: [(Jerry Seinfeld, 1, 3.7), (Elaine Benes, 52, 2.8), <you fill in the rest>]

Note:

Remember to properly close all files.

 You will lose 0.5 pts for including a text file

Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education