purchase. In also enables customers to filing new sweets that are not yet walable in which they are interested. Unless deleted by a customer, sweets remain on a shopping list for 80 days before being automatically de lebed. A customer's shopping list is sinned so that a customer can return to their list at any time. A shopping basket contains items that a customer has decided to purchase. Imams can be moved from the shopping list to the basket or soded directly to the basket by selecting the ADD TO SHOPPING BASKET =Esinst the sweet. When an item is added to a shopping basket, the customer is asked to specify the amount required either as individual sweets or in picks. An example of : shopping basket can be seen in Figure S. Only sweets that are available can be added to the Shopping Basket, new sweets that will be arriving shortly cannot be added. A chopping basket item can only be individual sweets or packs, the two cannotbe mixed in the same item. Within an order s customer can purchas: individual sweets and packs but as separate items. The first time in a session that a customer decides to add an item to their shopping basket or list, or wants to view either of these for the first time in the session, they need to enter their usamame and password before they can proceed. When a customer is happy with the items in the shopping basket, they click on the 'Proceed to Checkout button where they are asked to enter their payment and delivery details. The customer's address is held and is assumed to be the delivery address unless the customer specifies otherwise for that particular order. It is at this point that the database needs to check if the item requested is in stock at the customer's nearest distribution centre and calculate an appropriate delivery date. If the item is not in stock and it is not known when new stock will arrive, then the item needs to be flapped 25 'swaiting new stock! Items in an order may be delivered separately depending on the availability of stock. As a matter of policy, 085 prefers to deliver ordered items that are in stock as soon :: possible rather than waiting for the whole order to be ready. Figure d shows an example of : customer order. A delivery charge of :5.00 is applied to any orders under 8:0. A charge of 810 is made for orders between 830 and 8100. Delmary on orders over 2100 is free. Customers can keep track of their orders via the "View Orders option once they have logged Items are delivered at a time agreed by the customer as part of the entry of payment and delivery