SDSU 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.


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

Instructor

Year

Term

Enrollment

Whitney, RE

2004

Fall

70

Whitney, RE

2003

Spring

44

Whitney, RE

2001

Spring

23

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

Course

Year

Term

Enrollment

CS 683

2004

Fall

70

CS 580

2004

Spring

40

CS 635

2004

Spring

43

CS 535

2003

Fall

51

CS 535

2003

Spring

41

CS 683

2003

Spring

23

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

Instructors

Id

Name

1

Whitney, RE

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

Terms

Id

Year

Semester

1

2004

Fall

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

Courses

Id

Dept

Number

Title

Units

1

CS

683

Emerging Technologies

3

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

Sections

Id

Sect_Number

Enrollment

Instructor_id

Course_id

Term_id

1

1

70

1

1

1

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