To write some cool stored procedures in PostgreSQL.
Marist asks you to improve class registration.
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.
•
Chapters 9.4 and 10.2 in our text
•
Stack OverSlow - http://stackoverSlow.com/questions/tagged/stored-procedures
+postgresql
