
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
Concept explainers
Question
Write algorithms to solve different
Problem:
The program will display the following when run: | |
1. Display Pass/Fail Data | |
2. Display Final Grade Classification | |
3. Display Mean and Median Score | |
Call the following function when the user selects from the menu: | |
1. Determine the number of students who passed (>=75%) and failed (<75%). Plot also the pass/fail data using a pie chart. | |
2. Classify and plot (using bar graph) the final grades based on the following: | |
- Expert (95%-100%) | |
- Competent (85%-94%) | |
- Novice (75%-84%) | |
- Beginner (<75%) | |
3. Calculate the mean and median final grade. Plot the mean and median score with the plot of all the final grades. |
Create an
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps

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.Similar questions
- 4-5 A Girl Scout needs to calculate the total dollar amount of her cookie orders. User input should be used to find the quantities sold of Smores, Thin Mints, Caramel DeLites, Shortbread, and Peanut Butter Patties. Use a selling price of $5 per box for Smores and Caramel DeLites, $4 per box for Thin Mints and Peanut Butter Patties, and $3 per box for Shortbread cookies. Print the total number of boxes sold, the total revenue for each flavor, and the total amount collected for all cookies. Use the main function and a function to calculate the sales. python 3 or above please.arrow_forwardStudent Number, Grade 101029383,90 192736611,10 109800384,0 292833315,80 Complete the function below. If a line is long, you may write it in multiple lines at one blank, but please only write a single statement. def write_final_grades (assignment_grades: Dict, resubmit_grades: Dict, fname: str) -> None: """Write final marks to a final grade file named fname. assignment_grades maps student numbers to grades for the original assignment submission. resubmit_grades maps student numbers to grades for the resubmission of the same assignment. The resubmit penalty of 20% has not been applied within resubmit_grades. The higher mark, after resubmit penalties are applied, is the final mark for a student. Assume that the same student IDs are in both dictionaries. Assuming "grades.txt" is the original grade file shown (on the previous page) and "resubmit.txt" is the file above this function header: >>> original = make_dictionary ("grades.txt") >>> resubmit = make_dictionary ("resubmit.txt") >>>…arrow_forwardmenu(): Takes no inputs and does not return a value. It prints the two options available to the user and asks them to enter a number corresponding to their desired option. It then asks the user for the required inputs and then calls the appropriate function and prints the return value with an appropriate message (see below). If the user enters a number corresponding to an invalid option, Invalid choice. should be printed and the program should end. When the program ends, Have a nice day! should be printed to the user. If the user asks the program to solve an equation, then the program should ask the user to type in the equation (without spaces). If a solution is found, then print Solution found: followed by the solution as a list. If no solution was found, print No solution found. If the user asks the program to create an equation, then the program should ask the user to enter the number of tries, length of the equation and percentage for a number to have additional digits. If an…arrow_forward
- calcAverage function: This is function that returns no value and accept no parameters. This function will do the following: Ask the user to enter how many integers to enter. This has to be a positive integer and you need to validate that Write a “for” loop to accept this many integers and write the needed logic to calculate the average of these numbers and print that out Then the function will return back to the main functionarrow_forwardProgram Purpose - Professional Athletes often hire other professionals to help take care of matters for them. We will group them in four categories: Lawyers, Personal Assistants, Agents, and Trainers. They all get paid a percentage of the athlete's total yearly salary. Lawyers - 10%, Personal Assistants - 3%, Agents - 7%, and Trainers - 5% . Prompt the user to enter the athlete's salary for the year (ensure that the entered value is positive). The user should then enter the name and category of each of the hired professionals. The athlete should be able to hire as many professionals in each category as he/she wants, even if it is more than he/she can afford. Based on the category, calculate the amount that each professional should be paid. After all data has been entered, print the names of each professional hired, how much each is being paid, the total amount the athlete paid, and how much the athlete has left.arrow_forwardAn integer n is passed as argument to a function named convert0to5. This function returns an integer by replacing all 0's in the number by 5. Note: Do not convert the number to string.arrow_forward
- LAB ASSIGNMENTS IMPORTANT: you should complete the PDP thinking process for each program. Turn in items: 1) fullname_regex.py - Ask the user to enter the source text to search, such as the name_source variable here: name_source = input('Enter full name in this format - first middle last'). Then, you can adapt the first two code lines from lesson slide 13, to search this new source. Edit the code to match the new situation and change the regex pattern to identify text that could be a full name. Hints: Initially write your regex pattern to check if the user enters three words separated by a space. Then, strive to make the regex adaptable if the person's full name has more than or less than 3 words. Then, think about allowing (not requiring) common characters like a period, hyphen or '. Slides 11-13 should be helpful. 08 For printing, end with a conditional block that provides an appropriate message if there is a match or not. Match Enter your full name: first middle last Betty Lou Who…arrow_forwardCreate a function using a "while" loop. The function asks the user to input a number between 10 and 20. If the number is not within the specified limits, the user must change his/her input until he/she enters the correct value.arrow_forwardPYTHON QUESTION ASSIGNMENT REQUIREMENTS This assignment requires a dictionary of state abbreviations and their capital cities. The abbreviations are the keys and the state capitals are the values. Start by entering data for any four states of your choice. Then, report this count but use a function to get the count. Use a while loop to add more abbreviations and capitals. The loop should continue until the user presses Enter when prompted for an abbreviation. Inside the while loop: If the state entered is already in the dictionary, report its capital. If it is not in the dictionary, prompt the user to enter the capital for that state and add it to the dictionary After the while loop ends: Report again the count of the number of states in the dictionary. Using another loop and the items() method, display all the state abbreviations and their capitals. In the same Python program write this code, although it has nothing to do with the states code. Using a dictionary…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education

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