1. Write a PL/SQL procedure getGpaProc which accepts a Student\'s ID and returns

Question

1. Write a PL/SQL procedure getGpaProc which accepts a Student's ID and returns the Student's name and Gpa.

2. Create a stored function called getGpaFun. This function takes input as Student ID and returns student's GPA. Call the fucntion from within an SQL statement to select the student's name and gpa for all students majored in 'Comp Sci'.

3. Suppose that a University has a rule that a student cannot enroll in more than 18 credit hours in any semester. Create a trigger 'creditHourMonitoring' to enforce this constraint. The trigger fires whenever there is an input to the takes table and outputs a suitable error message when the rule is violated.

4. Write an appropriate PL/SQL statement to create trigger to enforce no two sections meet at the same room at the same time. The trigger fires wheneevr there is an insert/update to the section table and outputs a suitable error message when the rule is violated.

Explanation / Answer

Can you send me ur db schema?

I can help you in your assignment. You can contact me on mukeshprasad4u@in.com or +91-7798290238 for your assignment help. This will be paid service.

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.