Question: Create a database package specification and body called students which contains a. getNextStudentId function which return the next available studentID which are maximum StudentID+1 b.

Create a database package specification and body called students which contains

a. getNextStudentId function which return the next available studentID which are maximum StudentID+1

b. validateStudentName function() which receive user input to return exists if the student exists before or not_exists if the student not inserted before (you can use cursor).

c. insrStudent procedure called by user to receive user input which are (name,GPA,phone) the procedure get the next student id using the getNextStudentId function then the procedure will insert new record to the table if the studentname doesnt exists before by using validateStudentName or display a message to enter another name if exists before.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!