Emerging Technology Fall Semester, 2004 Asssignment 4
	Assignment Index          © 2004, All Rights Reserved, SDSU & Roger Whitney San Diego State University -- This page last updated 06-Dec-04

Assignment 4

Due Dec 16, 7:00 pm

Modifications - Dec 6

Added missing column (term_id) to Sections table description. Added the two following links.

• Example Solutions
• Zip file with database data (tab separated)

For planning purposes departments and students like to see information about the history of course. Departments like to see the enrollment in a course over the last several years to help predict future enrollment in the same course. Students like to know how often a course is offered and who taught the course. If a course is taught every semester, one may safely wait until a semester or two to take the course. If the course is only offered once every two years, then one has to take it when it is offered. Some students have strong opinions (for and against) about individual instructors. So they are interested in seeing what courses an instructor has taught recently.

Assignment 4 is to develop a web site that provides this type of information. When a user goes to the web site they first select either an instructor or a course. That is the page will let the user select a course and the page will let the user select an instructor. How the user selects a course or an instructor is up to you. If a user selects a course and submits the information they will get a page that lists all the times the course has been offered. For example here is the information for CS 683.

CS 683 Emerging Technologies

If a user selects an instructor one gets a page that lists all the courses the instructor has taught. (Actually all the courses listed in the database for that instructor.) For example here is the page for Whitney, RE

Whitney, RE

The data will be provided for you in the following tables. A sample row of data is shown in each table

Instructors

Id in an int, Name is a varchar(50) (String)

Terms

Id & Year are an int, Semester is a varchar(10)

Courses

Id & Units are int, Dept is varchar(10), Number is varchar(5), Title is varchar(30)

Sections

All are ints.

The web site is to be implemented using either Hibernate + Cocoon or Glorp + Seaside. One may be tempted to just provide a page of all courses and a page of all instructors. While this may be a useful thing to do, it is not part of the assignment.

    visitors since 02-Dec-04