
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
Question
Write a function called solution() which takes a string and an integer. The string is the name of a company, the integer is the number of months someone has worked at that company. Return the number of vacation days that this person earns per year.
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 3 steps with 1 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.Similar questions
- In C++ Write a function named find_bigfoot which takes a string as an argument, and then determines whether the string "bigfoot" is found in the parameter. Then it returns true or false, depending on whether it was found or not. For example: find_bigfoot("There is no yeti");find_bigfoot("footbig not here"); would both return false, since the string bigfoot isn't part of the string while: find_bigfoot("I believe in bigfoot");find_bigfoot("bigfoot is around here"); would both return true, since the string bigfoot is part of the string.arrow_forwardCreate a function named fnTuition that calculates the tuition for a student. This function accepts one parameter, the student ID, and it calls the fnStudentUnits function that you created in task 2. The tuition value for the student calculated according to the following pseudocode: if (student does not exist) or (student units = 0) tuition = 0 else if (student units >= 9) tuition = (full time cost) + (student units) * (per unit cost) else tuition = (part time cost) + (student units) * (per unit cost) Retrieve values of FullTimeCost, PartTimeCost, and PerUnitCost from table Tuition. If there is no student with the ID passed to the function, the function should return -1. Code two tests: 1) a student who has < 9 student units, and 2) for a student who has >= 9 student units. For each test, display StudentID and the result returned by the function. Also, run supportive SELECT query or queries that prove the results to be correct.arrow_forwardWrite a set of functions that calculate the cost of movie tickets for a family. Using a loop, keep asking: The age of the movie goer. Based on this age, you will charge them these amounts: Under age 3, the ticket is free. If they are between 3 and 12, the ticket is $10.25. If they are over age 12, the ticket is $15.50. If they are 55 or older, the ticket is $12. If they buy at least 4 tickets, they receive a 20% discount. Then, keep a running_total that is output to the screen after each age has been entered. This running_total should be accessed through the functions using a pass-by-reference variable: &running_total The other function parameter variables are to be pass-by-value. Tell them to enter a zero when they want to stop. Finally, calculate the total cost including a 7.5% sales tax. and output it to the screen. Be sure that the code is broken up into functions with good comments. Put as little code in main() as you can get away with and still make sense.…arrow_forward
- One lap around a standard high-school running track is exactly 0.25 miles. Define a function named laps_to_miles that takes a number of laps as a parameter, and returns the number of miles. Then, write a main program that takes a number of laps as an input, calls function laps_to_miles() to calculate the number of miles, and outputs the number of miles. Output each floating-point value with two digits after the decimal point, which can be achieved as follows: print (f' {your_value:.2f}') Ex: If the input is: 7.6 the output is: 1.90 Ex: If the input is: 2.2 the output is: 0.55 The program must define and call the following function: def laps_to_miles (user_laps) 461710.3116374.qx3zqy7 LAB ACTIVITY 1 # Define your function here 21 3 00 Jo UAWN P 4 if ___name__ 5 6 7.8.1: LAB: Track laps to miles 7 8 main.py '__main__': # Type your code here. Your code must call the function. 8/10 Load default template...arrow_forwardWrite a set of functions that calculate the cost of movie tickets for a family. These functions should use a pass-by-reference variable that accesses the double running_total variable in main(). Using a loop, keep displaying the ticket prices for each age group: Something like: Model Hall Movie Ticket Box Office Under Age 3 (free) Ages 3-11 ($10.25) Ages 12-54 ($15.50) Age 55 or older ($12) If 4 tickets are purchased (not counting under age 3) then 20% discount Within the loop: Keep asking the user to input the moviegoer age and to enter a zero for the age when they are finished inputting all the family members. Also, within the loop: Keep a running_total that is output to the screenafter each age has been entered. This running_total should be accessed through the functions using apass-by-reference variable. Finally, after the looping is done: Calculate the total cost, including a 7.5% sales tax, and output it to the screen.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