A. Text File Content Description The student's information is stored in a data file (text files). Each line represents a student record. Each record has student information as illustrated in the Table 1. Table 1 Student Iaformation in a Text File ID NAME Course absences Exam1 Grade Exam 2 Grade Total Marks 202010000 Asem ICSI04 100 100 200 202010000 Asem ICS108 75 -1 75 202010001 Khalid ICS202 -1 -1 -2 In the table above, a student Asem with ID 202010000 is added to the text file. He has no absences so far and scored 100 in both exams of ICS104. His total is 200 (perfect score). However, the same student has two absences in ICS108 and scored 75 in the first exam, while exam 2 has not conducted yet. The negative value in Exam-Grade columns means the exam isn't conducted. Any other value (in a valid range [0,100) means a score. B. Program Tasks Description The target program should perform six essential tasks. In the following the tasks elaborated more 1 Adding Students to a data file This program option allows a use to add new students to the data file. To add a record to the data file, a user should have all required information such as ID, student name, course title, his attendance record etc. In case, exam 1 and 2 or any one of them is not conducted then a negative value (-1) should be entered. The user should run the program and selects this option, then he needs to enter the student information. Your program should create a new record and add it to the text file in new row. No duplication should be allowed. In other words, same student with same information is not allowed, and your program should give an error message to the user like this "The student record is already in che database! Zero records added."
A. Text File Content Description The student's information is stored in a data file (text files). Each line represents a student record. Each record has student information as illustrated in the Table 1. Table 1 Student Iaformation in a Text File ID NAME Course absences Exam1 Grade Exam 2 Grade Total Marks 202010000 Asem ICSI04 100 100 200 202010000 Asem ICS108 75 -1 75 202010001 Khalid ICS202 -1 -1 -2 In the table above, a student Asem with ID 202010000 is added to the text file. He has no absences so far and scored 100 in both exams of ICS104. His total is 200 (perfect score). However, the same student has two absences in ICS108 and scored 75 in the first exam, while exam 2 has not conducted yet. The negative value in Exam-Grade columns means the exam isn't conducted. Any other value (in a valid range [0,100) means a score. B. Program Tasks Description The target program should perform six essential tasks. In the following the tasks elaborated more 1 Adding Students to a data file This program option allows a use to add new students to the data file. To add a record to the data file, a user should have all required information such as ID, student name, course title, his attendance record etc. In case, exam 1 and 2 or any one of them is not conducted then a negative value (-1) should be entered. The user should run the program and selects this option, then he needs to enter the student information. Your program should create a new record and add it to the text file in new row. No duplication should be allowed. In other words, same student with same information is not allowed, and your program should give an error message to the user like this "The student record is already in che database! Zero records added."
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
Related questions
Question
100%
just do the first step. and the program should be in python and includ as many different functions as possible .
Transcribed Image Text:Usually large amount of information is stored in files. Suppose a school wants to convert
its manual systems (using papers to keep and maintain student information) to a
computerized system. The school seeks your help as a programmer to develop and create
such a modern system. After collecting the requirements for the system, you have
identified the following tasks:
1. Adding Students to a data file
2 Removing students from a data file
3. Modifying student information
4. Show students' information to a user
a. All students (sorted in increasing order by student names)
b. Show top 5 students (sorted in decreasing order by total grades)
c. Show top 5 students (sorted in decreasing order by absences)
2- Show all courses registered by a student
a. Given a student ID
b. Given a name
3- Terminate a program
![A. Text File Content Description
The student's information is stored in a data file (text files). Each line represents a
student record. Each record has student information as illustrated in the Table 1.
Table 1 Student Information in a Text File
ID
NAME
Course
absences
Exam1 Grade
Exam 2 Grade
Total Marks
202010000
Asem
ICS104
100
100
200
202010000
Asem
ICS108
2
75
-1
75
202010001
Khalid
ICS202
-1
-1
-2
In the table above, a student Asem with ID 202010000 is added to the text file. He has no
absences so far and scored 100 in both exams of ICS104. His total is 200 (perfect score).
However, the same student has two absences in ICS108 and scored 75 in the first exam,
while exam 2 has not conducted yet. The negative value in Exam-Grade columns means
the exam isn't conducted. Any other value (in a valid range [0,100]) means a score.
B. Program Tasks Description
The target program should perform six essential tasks. In the following the tasks
elaborated more
1. Adding Students to a data file
program option allows a use to add new students to the data file. To add a record to
This
the data file, a user should have all required information such as ID, student name, course
title, his attendance record etc. In case, exam 1 and 2 or any one of them is not conducted
then a negative value (-1) should be entered.
The user should run the program and selects this option, then he needs to enter the student
information. Your program should create a new record and add it to the text file in new
row. No duplication should be allowed. In other words, same student with same
information is not allowed, and your program should give an error message to the user
like this "The student record is already in the database! Zero records added."](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F18c50617-8111-4099-9a07-76b22b8ab934%2Fc8370107-1124-44dc-963d-195122c2845b%2Frfkam3p_processed.png&w=3840&q=75)
Transcribed Image Text:A. Text File Content Description
The student's information is stored in a data file (text files). Each line represents a
student record. Each record has student information as illustrated in the Table 1.
Table 1 Student Information in a Text File
ID
NAME
Course
absences
Exam1 Grade
Exam 2 Grade
Total Marks
202010000
Asem
ICS104
100
100
200
202010000
Asem
ICS108
2
75
-1
75
202010001
Khalid
ICS202
-1
-1
-2
In the table above, a student Asem with ID 202010000 is added to the text file. He has no
absences so far and scored 100 in both exams of ICS104. His total is 200 (perfect score).
However, the same student has two absences in ICS108 and scored 75 in the first exam,
while exam 2 has not conducted yet. The negative value in Exam-Grade columns means
the exam isn't conducted. Any other value (in a valid range [0,100]) means a score.
B. Program Tasks Description
The target program should perform six essential tasks. In the following the tasks
elaborated more
1. Adding Students to a data file
program option allows a use to add new students to the data file. To add a record to
This
the data file, a user should have all required information such as ID, student name, course
title, his attendance record etc. In case, exam 1 and 2 or any one of them is not conducted
then a negative value (-1) should be entered.
The user should run the program and selects this option, then he needs to enter the student
information. Your program should create a new record and add it to the text file in new
row. No duplication should be allowed. In other words, same student with same
information is not allowed, and your program should give an error message to the user
like this "The student record is already in the database! Zero records added."
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 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.Recommended textbooks for you
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
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