1. Create a simple database with stored procedure(s). The DDL should be able to be executed in Oracle.

2. Create a simple IIS-based Web Services provider that can execute Oracle stored procedures.

3. Create a simple application with following features:

a. It can act as consumer to interact with your Web Services provider.

b. It has screen(s) with some controls to allow user input, with some validations based on information from Web Services.

c. The user action will invoke stored procedure(s) in the Oracle database and display the returning information on the screen.

4. The project should be submitted as solution package that can be run in Visual Studio if you use it as your development environment.

5. Database DDL should be sent together with the sample project so we can test your code.

Hints:

1. Oracle Express Edition is a free download if you do not already have your own Oracle installation.

2. Visual Studio, whose community edition is a free download, can help you quickly establishing working projects in Web services provider and Web application.