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
Transcribed Image Text:Problem:
Write a Python program that reads from an input file given by a user students information after a summer
semester which allow students to take two courses. The program will calculate the accumulated semester
grade point average (GPA) according to the courses grades and the number of credit hours of the courses.
The GPA scores are shown in table 1. The accumulate GPA is calculated as the following equation
GPAcourse 1 Creditscourse 1 + GPAcourse 2 • Credits.course 2
A Credits.course 1 + Creditscourse 2
Accumulate GPA =
The input file contains student id and student name in the first line. The rest lines contain courses
information (course code, course credit hours, student grade). Suppose the input files always in the same
format as in the given sample inputs in Figures 2 and 3.
The program should display the result in an output file with name "result ID.txt" where ID is the student
Id. Your output files should be in the same format as shown in the given sample outputs in Figures 2 and
3. The first line contains student name and id followed by a table of courses information and at the end the
accumulated GPA.
Figure I shows a sample run on a console window.
Table 1 GPA scores
Grade
A GPA
4.0
3.0
2.0
D
1.0
F
0.0
Enter the file name of a students: st 15577.txt
The output file named 'result 15577.txt has been successfully created.
Figure 1 Console window
st15577 tt-Notepad
result 15577.tt - Notepad
File Edit Format View Help
15577ar Mohammed Al zidi
ENGESe:3:C
MATHI301:3:D
File Edit Format View Help
Student ID: 15577
ww *
Student Name: Amar Mohammed Al zidi
Course Code
ENGE3780
Credits
Grade
3.
MATHI301
Total Attempted: 6
CUM GPA: 1.5e
Figure
Samplel input file (left) and output file (right)
result 23410.txt - Notepad
st 23410 bt
File Edit Format View Help
23410:Maryan Abdullah Al Amri
MATH2202:3:8
ARAB1100:2:A
File Edit Format View Help
student ID: 23410
Student Name: Maryan Abdullah Al Amri
Course Code
Credits
Grade
MATH2202
ARAB1100
Total Attempted: 5
CUM GPA: 3.40
Figure 3 Sampl@2 input file (left) and output file (right)
Expert Solution
Check MarkThis question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
bartleby
This is a popular solution
bartleby
Trending nowThis is a popular solution!
bartleby
Step by stepSolved in 4 steps with 5 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
- Write a python application to simulate an Online Book Shop. Notes: Option 1 and Option 2 must display the list of books to the user. The Main function accounts for invalid options. Program displays error message for invalid user option, invalid ISBN number or any invalid title.The programmer can create the book title, price, and ISBN information for the books. Each item consists only one string of comma-separated data: book ISBN number, title, and price. A customer can purchase some books either by ISBN number and/or by title. If the user input an invalid number or book title, the program should display an error message. The user can stop shopping with "checkout" option , which triggers the checkout() function that computes the total cost of the books in the cart. A customer will be provided the following menu option while shopping at the book shop: Option 1. Purchase by ISBN: User can purchase a book by its ISBN number. ISBN stands for International Standard Book Number. This is a...arrow_forwardpython Now write another program that reads the text file created in the program above and calculates the user's weekly pay. The program should begin by prompting the user for the regular hourly pay rate. The program should then loop through the file and report the days and hours worked. The program should finish by calling a custom void function named calc_pay that calculates and prints the weekly pay, including overtime, if applicable. By law, weekly hours in excess of 40 should be paid at 1.5 times the regular hourly rate. The calc_pay function takes two arguments, total hours and hourly pay rate, and it must be imported from a separate module file. Note that three outputs are required for the pay.Sample Output 1Enter your hourly pay rate 25.00Here are your hours this weekMonday hours : 10.0Tuesday hours : 8.0Wednesday hours : 12.0Friday hours : 12.0Saturday hours : 8.0You worked 50.0 hours this weekYou worked 10.0 hours overtimeYour hourly pay rate is 25ドル.00 Regular pay :...arrow_forwardjust do the first step. and the program should be in python and includ as many different functions as possible .arrow_forward
- please code in python You place a pawn at the top left corner of an n-by-n chess board, labeled (0,0). For each move, you have a choice: move the pawn down a single space, or move the pawn down one space and right one space. That is, if the pawn is at position (i,j), you can move the pawn to (i+1,j) or (i+1, j+1). Ask the user for the size of a chessboard, n (integer). Find the number of different paths starting from (0,0) that the pawn could take to reach each position on the chess board. For example, there are two different paths the pawn can take to reach (2,1). Look at the diagrams below to convince yourself of this. You can see the four paths that you can take by move 2. Start -> Move 1 -> Move 2 (0,0) -> (1,0) -> (2,1) (0,0) -> (1,0) -> (2,0) (0,0) -> (1,1) -> (2,1) (0,0) -> (1,1) -> (2,2) Print the board with the number of ways to reach each square labeled as shown below. For example: Enter a board size: 4 1 0 0 0 1 1 0 0 1 2 1 0 1 3 3 1arrow_forwardComputer Science Part C: Interactive Driver Program Write an interactive driver program that creates a Course object (you can decide the name and roster/waitlist sizes). Then, use a loop to interactively allow the user to add students, drop students, or view the course. Display the result (success/failure) of each add/drop.arrow_forwardC++ Programming Language: Enhance the code given by outputting: The largest number of the sequence a0 ,a1 ,a2 , ..., ak. The position of the largest number Test your program for the following values of x: 75, 111, 678, 732, 873, 2048, and 65535. Example: "For example, for the input sequence: 75, 226, 113, 340, 170, 85, 256, 128, 64, 32, 16, 8, 4, 2, 1, the program output should contain the following: The largest number of the sequence is 340 The position of the largest number is 4" Code Given: #include <iostream> #include <iomanip> using namespace std; int main() { long x; int count; long a_n; cout << "Enter a nonnegative integer: "; cin >> x; cout << endl; count = 0; a_n = x; cout << a_n << ", "; while (a_n !=1) { if (a_n %2==0) a_n = a_n / 2; else a_n = 3 * a_n + 1; count++; cout << a_n <<", "; } cout << endl; cout << "The integer k such that a_k = 1 is " << count << endl; return0; }arrow_forward
- ⦁ Perfect Pizza wants to install a system to record orders for pizza and chicken wings. When regular customers call Perfect Pizza on the phone, they are asked their phone number. When the number is typed into a computer, the name, address, and last order date is automatically brought up on the screen. Once the order is taken, the total, including tax and delivery, is calculated. Then the order is given to the cook. A receipt is printed. Occasionally, special offers (coupons) are printed so the customer can get a discount. Drivers who make deliveries give customers a copy of the receipt and a coupon (if any). Weekly totals are kept for comparison with last year’s performance. ⦁ Write a summary of business activities for taking an order at Perfect Pizza.⦁ Draw a context-level data flow diagram for Perfect Pizza⦁ Explode the context-level diagram in b showing all the major processes. Call this Diagram 0. ⦁ Draw a logical child diagram for Diagram 0 in c for the process...arrow_forwardPythonarrow_forward
arrow_back_ios
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