A4 - -1- University of Waterloo School of Computer Science...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
- 1 - University of Waterloo School of Computer Science CS348 Spring 2009 Assignment 4 Due: June 30, 2009 1. Consider the following relational schema which is the same as in Assignment 2. Student (Sno, Sname) Course( Cno, Cname ) Prerequisite (Cno, Prereq ) Professor (Eid, Pname, Office, Dept) Enrollment (Sno, Cno, Term , Section, Mark) Schedule (Cno, Term, Section, Day, Time, Room) Class (Cno, Term, Section , Instructor) A database on the above schema called enrollmentdb has already been created on rees.math.uwaterloo.ca/cs348 which can be accessed from your Java program via the Internet. A handout from the course website provides information of how to access the server database. Write an efficient Java program (with JDBC) that generates the required result for the following application. A course C1 is said to be a pre-prerequisite of another C2 if C1 is a prerequisite of C2 or there is a prerequisite C3 of C2 such that C1 is a pre-prerequisite of C3. Given a student number, your program prints out all the courses taken by the
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 10/23/2009 for the course CS 348 taught by Professor Woody during the Spring '09 term at Waterloo.

Ask a homework question - tutors are online