
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN: 9780133594140
Author: James Kurose, Keith Ross
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
- Write a script that creates and calls a function named fnTuition that calculates the total tuition for a student. To do that, this function should accept one parameter for the student ID, it should use the fnStudentUnits function that you created in question 1, and it should return the value of the tuition for that student depending on whether the student is fulltime (more than nine units) or parttime (nine or fewer units). (Hint: Use a cross join to work with data in the Students and Tuition tables.)
The SELECT statement that calls the function should return the StudentID from the Students table, the value returned by the fnStudentUnits function for that student, and the value returned by the fnTuition function for that student. Return only rows for students taking one or more units.
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 3 images

Knowledge Booster
Similar questions
- 4. Write a function with no parameters. In that function, add the numbers from the textboxes with the ids: boxA and boxB and write the result to the textbox with the id boxC?arrow_forwardWrite a function called user_input() that takes an integer n as a parameter. Thisfunction should display the integer n to the user and prompt them to enter its equivalentbinary value (the user just has to make a guess here). Your function should return theuser input.arrow_forwardHow do I Write a Python program that can convert a Fahrenheit temperature to Celsius, or vice versa. The program should use two custom functions, f_to_c and c_to_f, to perform the conversions. Both of these functions should be defined in a custom module named temps. Custom function c_to_f should be a void function defined to take a Celsius temperature as a parameter. It should calculate and print the equivalent Fahrenheit temperature accurate to three decimal places. Custom function f_to_c should be a value-returning function defined to take a Fahrenheit temperature as a parameter. This function should calculate the equivalent Celsius temperature and return it.arrow_forward
- In this coding challenge, you will be retrieving email usernames from a string. You will write a function named get_usernames () that takes in a string as it's input parameter, and returns a list of email usernames in the string. The input strings will contain 0 or more emails in the format and the '@' symbol will only appear in the context of an email. The order of usernames should match the order in the input text. username@domainname, For example: EXAMPLE 1 text: "If you need help on an assignment, email help@ucsd.edu or support@gmail.com" return: ['help', 'support'] EXAMPLE 2 text: "Good morning! I hope you're having a great time with CSE 8A!" return: [] EXAMPLE 3 text: "I've been having a lot of trouble reaching you, can you please email me at cse@ucsd.edu? return: ['cse', 'cse'] Here is the problem description: Function Name: get_usernames Parameter: text - A string corresponding to a piece of text containing 0 or more emails. Return: A list of the email usernames in the input…arrow_forwardAdd 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…arrow_forwardWrite a function that takes the current date and corrects the number of days, if it's wrong. The function must return true if the date passed to it is a valid date and false, if not. The main function uses the returned value to either print "Date validated", if a valid date was entered or "Invalid date entered. Changed to ", followed by the modified date.arrow_forward
- 1. Write a function that has 2 parameters. The first parameter represents the id of the 1st textbox, and the second parameter represents the id of the 2nd textbox. In the function, write the text from the 1st textbox to the 2nd textbox concatenated with the text this was in textbox 1?arrow_forwardWrite a function called expand_date() that takes a string parameter that contains the date in the form "mm/dd/yyyy". Your function should return a string formatted like this, for example "March, 12, 2020". IN PYTHONarrow_forwardCreate a new module named beautyid.py. Define a function named beautyidtag that accepts 4 parameters: face, hair, number, vitamins. The function should create a 10-digit identifier composed of the first 2 letters of the user input for the variable face, first 2 letters from the user input for the variable hair, the number from the variable number, the number of vitamins, and a random integer between 11 and 90. Identifiers must all be uppercase. Return the value of the 10-digit identifier back to the calling method when called. I have made another module called beautyinventory.py where the variables are stored. I'm going to import this module back into beautyinventory.pyarrow_forward
- Write 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_forwardWrite an appropriate function call for this value returning getNumber. Also write a valid function call for totalBook.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Computer Networking: A Top-Down Approach (7th Edi...Computer EngineeringISBN:9780133594140Author:James Kurose, Keith RossPublisher:PEARSONComputer Organization and Design MIPS Edition, Fi...Computer EngineeringISBN:9780124077263Author:David A. Patterson, John L. HennessyPublisher:Elsevier ScienceNetwork+ Guide to Networks (MindTap Course List)Computer EngineeringISBN:9781337569330Author:Jill West, Tamara Dean, Jean AndrewsPublisher:Cengage Learning
- Concepts of Database ManagementComputer EngineeringISBN:9781337093422Author:Joy L. Starks, Philip J. Pratt, Mary Z. LastPublisher:Cengage LearningPrelude to ProgrammingComputer EngineeringISBN:9780133750423Author:VENIT, StewartPublisher:Pearson EducationSc Business Data Communications and Networking, T...Computer EngineeringISBN:9781119368830Author:FITZGERALDPublisher:WILEY

Computer Networking: A Top-Down Approach (7th Edi...
Computer Engineering
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:PEARSON

Computer Organization and Design MIPS Edition, Fi...
Computer Engineering
ISBN:9780124077263
Author:David A. Patterson, John L. Hennessy
Publisher:Elsevier Science

Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:9781337569330
Author:Jill West, Tamara Dean, Jean Andrews
Publisher:Cengage Learning

Concepts of Database Management
Computer Engineering
ISBN:9781337093422
Author:Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:Cengage Learning

Prelude to Programming
Computer Engineering
ISBN:9780133750423
Author:VENIT, Stewart
Publisher:Pearson Education

Sc Business Data Communications and Networking, T...
Computer Engineering
ISBN:9781119368830
Author:FITZGERALD
Publisher:WILEY