(a) Write a user-defined function called SumStop which takes an integer n as an input and adds up the values of the cells in row 2 (starting from cell B2) until the value of the sum exceeds n, and then outputs the number of cells used. You may assume that all of the cells in row 2 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code. (b) Write a user-defined function called NoSpace which takes a string as input and outputs the same string with all of the spaces removed. For example, given the string The quick brown fox it should return the string Thequickbrownfox Use a a suitable loop, declare all variable types, and include appropriate comments in your code.

(a) Write a user-defined function called SumStop which takes an integer n as an input and adds up the values of the cells in row 2 (starting from cell B2) until the value of the sum exceeds n, and then outputs the number of cells used. You may assume that all of the cells in row 2 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code. (b) Write a user-defined function called NoSpace which takes a string as input and outputs the same string with all of the spaces removed. For example, given the string The quick brown fox it should return the string Thequickbrownfox Use a a suitable loop, declare all variable types, and include appropriate comments in your code.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Pleaser fix the code below: Since functions should do a single logical task, there is no need for the userInputCalc function to collect the info and also do the summary calculations, so move line 61 to line 72. Then, place line 67-72 inside a main() function, and place a call to this function at the end of the program file. Also, fix the names of the menu items (in menu_items) with spaces so they all have the same size. also, there is a simpler way: change {:<15} with {:<20} in lines 22 and 25. Also, use format for the “Subtotal” and “Grand total” (just like you did for “Sales tax” and “Suggested tip”) Also, the $ should go in front of the each amount. PLEASE MAKE THOSE CHANGES IN THE CODE BELOW: SummaryThis program will create a new version of the restaurant ordering programthat uses lists to look up menu items, record the items ordered by the user,and print a full receipt.''' def Menu(menu_items,menu_prices):print("Menu Card")count = 1for i,j in…
In python, Old-fashioned photographs from the nineteenth century are not quite black and white and not quite color, but seem to have shades of gray, brown, and blue. This effect is known as sepia, as shown in the figures below. Original Sepia Original Image & Sepia Image Write and test a function named sepia that converts a color image to sepia. This function should first call grayscale to convert the color image to grayscale. A code segment for transforming the grayscale values to achieve a sepia effect follows.Note that the value for green does not change. (red, green, blue) = image.getPixel(x, y)if red < 63: red = int(red * 1.1) blue = int(blue * 0.9)elif red < 192: red = int(red * 1.15) blue = int(blue * 0.85)else: red = min(int(red * 1.08), 255) blue = int(blue * 0. 1. GUI TEST 2. CUSTOM TEST 3. IMAGE TEST
A cantilever beam is under a concentrate load P (N), the beam has a length of L (m). P L y Complete the Python function below to find the support reaction force in y direction RF (N) and reaction moment RM (N*m) at the clamped end of the beam x = 0. Be careful of the sign of force and moment.
8. Which among the following show a valid use of the Color enumeration as a parameter to the setPixel function? Select all that apply. Take note that this is a right minus wrong question. enum Color { case red, green, blue}func setPixel(x: Int, y: Int, color: Color) {// code here} Which among the following show a valid use of the Color enumeration as a parameter to the setPixel function? Select all that apply. Take note that this is a right minus wrong question. enum Color { case red, green, blue}func setPixel(x: Int, y: Int, color: Color) {// code here} 1. setPixel(x: 0, y: 0, color: .blue) 2. setPixel(x: 0, y: 0, color: .orange) 3. setPixel(x: 0, y: 0, color: Color.green) 4. setPixel(x: 0, y: 0, color: Color.yellow)
Old-fashioned photographs from the nineteenth century are not quite black and white and not quite color, but seem to have shades of gray, brown, and blue. This effect is known as sepia, as shown in the figures below. Original Sepia Original Image & Sepia Image Write and test a function named sepia that converts a color image to sepia. This function should first call grayscale to convert the color image to grayscale. A code segment for transforming the grayscale values to achieve a sepia effect follows.Note that the value for green does not change. (red, green, blue) = image.getPixel(x, y)if red < 63: red = int(red * 1.1) blue = int(blue * 0.9)elif red < 192: red = int(red * 1.15) blue = int(blue * 0.85)else: red = min(int(red * 1.08), 255) blue = int(blue * 0.93) 1.GUI Test Generate sepia image 2.Convert gif to png 3.Image Test Image has been converted to sepia
Suppose you have to make a game which 3 users can play. Write a function set_details that will ask the user to set their password. Then in main function you have to apply a loop upto 10 iterations in which the random number is generated between the range of 1-3. . Apply switch statement on the above generated random number to call the function of each player's total score. (Hint: You have to make a function for each player.) Now in the total score function the program should ask the user his password. If he enters correct password, then he is capable of entering a number form 1-9 otherwise the function will display wrong password. Finally, after terminating from the loop program should display the total numbers of each player. Note: Solve in c programming language.
Exercise 6A Write a function Estimate SuperEllipse (m,n) which samples n points randomly in the square, tests whether each lies inside the superellipse, and returns an estimate of the superellipse's area. You can use the command random.uniform(-1, 1) to generate random numbers between -1 and 1. (For technical reasons to assist in marking, please leave the first line of your function as random.seed (1234).)
Write a user-defined function called SumStop which takes an integer n as an input and adds up the values of the cells in row 1 (starting from cell A1) until the value of the sum exceeds n, and then outputs the number of cells used. You may assume that all of the cells in row 1 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code. Write code in Excel VBA Code has to be for a function not a macro.
Add a function to get the CPI values from the user and validate that they are greater than 0. 1. Declare and implement a void function called getCPIValues that takes two float reference parameters for the old_cpi and new_cpi. 2. Move the code that reads in the old_cpi and new_cpi into this function. 3. Add a do-while loop that validates the input, making sure that the old_cpi and new_cpi are valid values. + if there is an input error, print "Error: CPI values must be greater than 0." and try to get data again. 4. Replace the code that was moved with a call to this new function. - Add an array to accumulate the computed inflation rates 1. Declare a constant called MAX_RATES and set it to 20. 2. Declare an array of double values having size MAX_RATES that will be used to accumulate the computed inflation rates. 3. Add code to main that inserts the computed inflation rate into the next position in the array. 4. Be careful to make sure the program does not overflow the array. - Add a…
Old-fashioned photographs from the nineteenth century are not quite black and white and not quite color, but seem to have shades of gray, brown, and blue. This effect is known as sepia, as shown in the figures below. Write and test a function named sepia that converts a color image to sepia. This function should first call grayscale to convert the color image to grayscale. A code segment for transforming the grayscale values to achieve a sepia effect follows.Note that the value for green does not change. (red, green, blue) = image.getPixel(x, y)if red < 63: red = int(red * 1.1) blue = int(blue * 0.9)elif red < 192: red = int(red * 1.15) blue = int(blue * 0.85)else: red = min(int(red * 1.08), 255) blue = int(blue * 0.93)
Write a function, named randomPassword, that generates a random password that takes no parameter. It will return the randomly generated password as its ONLY result. Display the randomly generated password in the main program. Password Criteria: o The password should have a random length of between 7 and 10 characters. o Each character should be randomly selected from positions 33 to 126 from the ASCII table You must import randint function directly and inline within the random package and it must be the first line of code in your program, after your program header comment. o Declaring and using FOUR constants. Constants must be named appropriately and intuitively. o You must use the chr built-in function within your randomPassword function: o Declaring the main function and invoking randomPassword function. o Logical approach to problem solving, computation, and displaying appropriate output.
Any help would be greatly appreciated!! If you could attached screenshots of the code that would be very helpful!! Write code for the following: Write Python code that uses a loop to prompt the user for five floating point numbers and reports the sum of the floats when the loop ends. Write Python code that defines a void function named divide that takes two numbers as parameters and then prints the quotient accurate to 1 decimal place when the first parameter is divided by the second one. A file named txt is shown on the right. Write Python code that opens this file, reads only the first two lines, and prints “Penny is 19” Penny 19 Kenny 20 Benny 21 Jenny 20