Database System Concepts
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
Bartleby Related Questions Icon
Related questions
Question
thumb_up100%
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
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 MarkThis question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
Step by stepSolved in 2 steps with 2 images
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
- .Test the function by calling it with the arguments 150 and 300 in your Python program. Paste the function call and the result as text into your Solution document. You should aim to use only the Python features that are introduced in the module. If you decide to use techniques or language features that TM112 does not cover, you must give a justification for your decisions,arrow_forwardUse C++ code and draw a flow chart Write a program that simulates a magic square using 3 one dimensional parallel arrays of integer type. Each one of the arrays corresponds to a row of the magic square. The program asks the user to enter the values of the magic square row by row and informs the user if the grid is a magic square or not. Project Specifications Input for this project: Values of the grid (row by row) Output for this project: Whether or not the grid is a magic square Programmer’s full name Project number Project due date Processing Requirements Use the following template to start your project: #include<iostream> using namespace std; // Global constants const int ROWS = 3; // The number of rows in the array const int COLS = 3; // The number of columns in the array const int MIN = 1; // The value of the smallest number const int MAX = 9; // The value of the largest number // Function prototypes bool isMagicSquare(int arrayRow1[], int...arrow_forwardWith the aid of c++,code a program which read candidates names followed by the marks received by them.The output should display each candidate's name followed by the marks received and the necessary grade received.The candidate with the highest mark name should be printed in the output alongside with the highest mark received . Note: The name should comprise of both First and last namearrow_forward
- Which features distinguish C++, assembly, and Python from one another? Create a flowchart to back up your argument with examples that show why your stance is correct.arrow_forwardI do not know how to do this problem from my Computer Science ZyBooks Chapter 6 assignment. I have attatched an image of the problem, and I need to write the code in Python. I am not sure how to define the functions correctly or how to take a list as a parameter and return a boolean, so any help would be greatly appreciated! Thank you!arrow_forwardPlease answer. This is pythonarrow_forward
- ______ lets you think about the big picture without worry about the details in Python. A. Appending B. Arguments C. Authoring D. Abstraction Which one is correct?arrow_forwardOne of the most important concepts of programming is handling input and output. The following activity will allow you to get familiar with this concept specifically when using Python. Write a function to add two values and display the results. Discuss the steps in your thought process as you created the code, any issues you encountered, and how you solved those issues.arrow_forwardThis is for python, how would i go about doing this?arrow_forward
- Must show it in Python: Please show step by step with comments. Please show it in simplest form. Input and Output must match with the Question Please go through the Question very carefully.arrow_forwardThe answer needs both a C++ and a Python code and the source code for the C++ is a picture attached Design a menu with appropriate user interactions and checks for valid entry. Use C++ to successfully complete this criterion. Your simple program will need a menu that can validate user input and is easy to use. It needs to include options for the display of a multiplication table, doubling a value, and exiting the program. If either of the first two options are selected, then users need to be prompted to input a numeric value. The menu should be displayed using a loop, where the user can choose to exit the program only by selecting option 3. Any user input other than 1, 2, or 3 should result in an error message that returns the user to the menu. An example menu might look like the following:1: Display a Multiplication Table 2: Double a Value 3: Exit Enter your selection as a number 1, 2, or 3. Create code that prints a multiplication table for a given numeric value. Both C++ and...arrow_forwardWrite a function in Python language to take two integer parameters and return whichever value is nearest to the value 10, or return 0 if two integers are equal.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Text book imageDatabase System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationText book imageStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONText book imageDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- Text book imageC How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONText book imageDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningText book imageProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
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