subject

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.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 09:30
Is a string of code written to hurt others by damaging or destroying
Answers: 1
question
Computers and Technology, 22.06.2019 12:50
You have just been hired as an information security engineer for a large, multi-international corporation. unfortunately, your company has suffered multiple security breaches that have threatened customers' trust in the fact that their confidential data and financial assets are private and secured. credit-card information was compromised by an attack that infiltrated the network through a vulnerable wireless connection within the organization. the other breach was an inside job where personal data was stolen because of weak access-control policies within the organization that allowed an unauthorized individual access to valuable data. your job is to develop a risk-management policy that addresses the two security breaches and how to mitigate these risks.requirementswrite a brief description of the case study. it requires two to three pages, based upon the apa style of writing. use transition words; a thesis statement; an introduction, body, and conclusion; and a reference page with at least two references. use a double-spaced, arial font, size 12.
Answers: 1
question
Computers and Technology, 22.06.2019 17:00
Your computer running windows 10 is doing some very strange things with the operating system. you are fairly certain it is not a hardware issue. you need to try to get further insight into what is going on within the operating system. which tool would be best suited for this?
Answers: 2
question
Computers and Technology, 23.06.2019 02:30
Research data that is presented using descriptive language is said to be
Answers: 2
You know the right answer?
1) Create a database package named ACADEMY_ADMIN that includes the following procedures and functio...
Questions
question
English, 24.02.2021 19:50
Questions on the website: 13722363