IT462: Web Services Lab

Due date: Friday, April 24, 2009, before class

Preliminaries

This lab will ask you to get some data from the "Assessment" database and put it into the "SOF" database. You will use web services for that. Download AssessmentDB.sql and SofDB.sql from Blackboard, read the files, and execute them to create the tables in your database.

Lab Description and Requirements

For this lab, you will implement a web service, and a client that connects to the web service. You should use PHP, MySQL, SOAP, and WSDL for this lab. Check the online resources for developing web services using PHP.

Your web service should provide two methods to extract data from the Assessment database:

getLearningObjectives: Given a semester and year, it returns the course number and the learning objectives for each course taught that semester. The information needed should be in the "offering" and "objective" tables in the Assessment database
getCoursesInstructors: Given a semester and a year, it returns the course number, section number, and instructor name for the courses offered that semester. The information needed should be in the "offering", "section", and "user" tables in the Assessment database

Your client should invoke the different methods provided by the web service and insert the retrieved data into the SOF database for the current semester (Spring 2009)

Insert the courses and learning objectives in the "outcomestbl2" table in the Sof database. Note that if the course does not exist in the "coursestbl" table, it should be inserted there first.
Insert the courses and their instructors in the "instr_course_tbl" table in the Sof database. Note that if the instructor does not exist in the "instructortbl", it should be inserted in that table first.

Turn In (Due date: Friday, April 24, 2009, before class)

Electronic

Upload to Lab 6 assignment on Blackboard your code.

Hard-copy

Completed assignment coversheet. Your comments will help us improve this course.
A hard-copy of the same files you uploaded: your code