Final Project Specs Spring 2001

This is the first draft of the final project specifications. If you have any comments get them to me and in class March 19 we will finalize the specs.

One overall statement, all deletes should be handled by marking the deleted data rather than deleting from the database.

1. Login
   1. Get user name (or equivalent)
   2. Get password
   3. Limit access based on the person logging in.
   4. (extra)After a number of unsuccessful logins deactive
   5. (extra)User change password
2. Customer Information Window
   1. Gather usual information, Name (last, first, middle initial), billing address (street1, street2, city, state and zip), phone, email (optional input). Allow for customer id to be entered when searching for customer data.
   2. Search for customer
      1. By id
      2. By field or fields other than id
      3. (extra) Any other searches for customer information
   3. Search for customer orders to allow
      1. Check order status
      2. Check order content
      3. Alter orders that have not been shipped
   4. (extra)Maintain credit information on customer. This is different from connecting a credit card to an order
3. Order Information
   1. Need the usual information about the item ordered including the id, the current price per unit, number of units ordered
   2. Need shipping status (backorder information)
   3. Credit card information
   4. Get shipping address if different from billing address
   5. (extra)Provide for other forms of payment
   6. Searchs
      1. By id
      2. By one or more other fields
      3. (extra)Other searches
   7. (extra)Any tax handling (sales, liquor, beauty, etc)
   8. (extra)Handle shipping of partial orders in case of backorders
4. Warehouse
   1. Handle shipping from a shipping list.
   2. Retrieve products that have to be reordered, with number to order
5. Super User
   1. Add users
   2. Change user status
      1. Change user's job
      2. Change user's password
      3. (extra)Enable user after failing login
   3. Change prices
      1. Change in one location
      2. Change by adding new price record allowing (extra) keeping a price history
6. (extra) Any Reports (printed or in windows)

Group 1	Group 2
Group 3	Group 4