The Northwind Traders sample database that is included with Microsoft SQL Server 2000 contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. Northwind Traders wants to provide better service for its customers and partners by allowing them access to their order information online. Furthermore, Northwind Traders wants its employees who are working in other countries to be able to amend or create new orders online.
To meet part of the requirements of Northwind Traders, you decide to build a simple Web Service to do the following:
Allow customers to manage orders
Allow customers to view their orders and import them in other packages
Employee functionality requirements:
Logon
Search orders (filter by employee and/or customer)
Create an order
Fill in an order
Fill in order details
Modify an order
Change orders
Change/delete order details line entries
Customer functionality requirements:
Logon
Search orders (self only)
Export orders to file