Write a script that creates and calls a function namedfnTuition that calculates the total tuition for a student. To do that, this function should accept one parameter for the student ID, it should use thefnStudentUnitsfunction 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.

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...

Write a script that creates and calls a function namedfnTuition that calculates the total tuition for a student. To do that, this function should accept one parameter for the student ID, it should use thefnStudentUnitsfunction 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.

Jun 08, 2022

SOLUTION.PDF

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...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment