CMPT 308 Lab 10: Stored Procedure Solution   Lab 10: Stored Procedure - 20 points

CMPT 308 Lab 10: Stored Procedure Solution Lab 10: Stored Procedure - 20 points

Goals
To write some cool stored procedures in PostgreSQL.
Scenario
Marist asks you to improve class registration.
Deliverables
Create tables for courses and their prerequisites from the script on our web site at
 
http://www.labouseur.com/courses/db/courses-and-prerequisites.txt.
 
Write two functions (stored procedures) that take an integer course number as their only
 
parameter:
 
1. func1on PreReqsFor(courseNum) - Returns the immediate prerequisites for the
 
 
passed-in course number.
 
2. func1on IsPreReqFor(courseNum) - Returns the courses for which the passed-in course
 
 
number is an immediate pre-requisite.
 
Optional Challenge:
 
Demonstrate Jedi-level skills and write a third, recursive, function that takes a passed-in
 
course number and generates all of its prerequisites. Uses the Sirst two functions you
 
wrote and recursion.
Resources

Chapters 9.4 and 10.2 in our text
 

Stack OverSlow - http://stackoverSlow.com/questions/tagged/stored-procedures
 
 
+postgresql
 
Powered by