CSc 8711. Databases and the Web
Spring 2005, Programming Project 5 (Web Services - Data Transfer)
Due: Friday, April 15, 2005

Apache Axis Setup and Sample Server and Client Code

This is a group project. Please form groups of 2 members. Each member of the group should develop at least one Web service server component and at least one client component.

In this project, you will develop web services that will enable data transfer between several independently controlled relational databases. These databases are:

  1. CollegeNet Database of graduate applicants. This database consists of applicant information including the programs to which they have applied.
  2. GoLunar Database at GSU. This database consists of current student information, courses and sections being offered, and who is enrolled in which course.
  3. Computer Science Department Database. This database is maintained by the CS department and contains information about graduate students, assistantship information, and courses taken by graduate students.
These three databases are independently operated, however there is an agreement for data sharing. We would like to provide a Web services implementation of the data transfer requirements. The following sequence of events illustrates the data transfer requirements as well as some of the user interfaces you will develop in this project.
  1. A new applicant goes to the College Net website and applies for admission to a graduate program at GSU. You need to write a servlet to enable this online application. This is a local College Net database activity.
  2. A GSU official goes to the College Net Website and enters an admission decision. This again is a local College Net database activity. You need to build a servlet for this as well.
  3. Periodically, College Net sends data about ACCEPTED applicants to the GSU GoLunar database. This should be programmed as a web service client at the College Net web site (a simple servlet). A corresponding Web service server component should be programmed at the GSU GoLunar site that receives the data and updates the GoLunar database.
  4. Admitted students start taking classes by going to GoLunar website. This is a local GoLunar database activity. You need to program this as a servlet at the GoLunar Web Site.
  5. At the CSc department web site, the Director of Graduate Studies downloads information about students admitted to the CSc department from GoLunar and courses they are taking. This should be programmed as a Web service client at the CSc dept. web site and a corresponding server at the GoLunar site.
  6. Also at the CSc web site, the Director of Graduate Studies enters information about students getting assistantships. This information is stored in the local database as well as sent to GoLunar via a web service call.
  7. At the GoLunar site, a student may print their tuition and fee report (should reflect tuition waivers, if any as a result of an assistantship).
  8. At the CSc dept. web site, the Director of Graduate Studies will be able to query the CollegeNet database via a Web service implemented at College Net for the following three queries: (a) Given department, term, and time window, return list of applicants, (b) Given department, term, and degree, return list of applicants, and (c) Given lname, return list of applicants.