Computers and Technology, 04.04.2021 16:30 kylemartinez13

1) Create a database package named ACADEMY_ADMIN that includes the following procedures and function.

a) The private function FIND_TUTION_FEES that takes number of students and
course fees as the input parameters and returns tution fees for the faculty
using the formula given below.
Faculty_Tution_Fees = (No. Of Students X Course Fees) * 0.40
b) The public procedure UPDATE_TUTION_FEES that finds and updates faculty tution
fees for the each online course. The procedure has to find the number of
students enrolled and course fees for the each online courses and pass as the
parameters for the function FIND_TUTION_FEES to calculate faculty tution fees.

c) The public procedure REPORT_CLASS that displays Class ID, Course ID and
number of students enrolled in each class.
d)The public procedure that accepts student id as an input and displays the list of
courses he/she studied in the online academy. The block has to display course
id and course name. Use an explicit cursor with parameter to fetch the data.

Answers: 3

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 09:00

Which best describes the condition under which the unicode output is the same as plain text?

Answers: 3

Answer

Computers and Technology, 22.06.2019 18:10

Assume that to_the_power_of is a function that expects two int parameters and returns the value of the first parameter raised to the power of the second parameter. write a statement that calls to_the_power_of to compute the value of cube_side raised to the power of 3 and that associates this value with cube_volume.

Answers: 1

Answer

Computers and Technology, 23.06.2019 21:30

To move a file or folder in microsoft windows, you can click and hold down the left mouse button while moving your mouse pointer to the location you want the file or folder to be, which is also known as.

Answers: 3

Answer

Computers and Technology, 24.06.2019 02:30

Which option completes the explanation for conflict of interest in an organization

Answers: 1

Answer

You know the right answer?

1) Create a database package named ACADEMY_ADMIN that includes the following procedures and functio...

Questions