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
100%

just do the first step. and the program should be in python and includ as many different functions as possible .

[画像: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 ]
expand button
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." ]
expand button
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
Check Mark
Knowledge Booster
Background pattern image
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
    SEE MORE 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