| You now have a complete application. Feel free to browse through, adding items to your cart, registering, removing items, and eventually purchasing a BananaMobile. You'll be amazed at how well the site works after assembling it in only one lesson. However, there is also a lot of room for improvement. For example, the news user control should pull its headlines from a data store or other news feed. This can easily be accomplished in the user control itself, but requires appropriate data resources. You might eventually want to allow users to build more than one BananaMobile at a time, or allow them to purchase individual parts for their existing BananaMobiles. These two features would require changes in all three tiers of the application, such as modifying the shopping cart table and its stored procedures, and redesigning the UI to display the data in new ways. If you are familiar with database design, you know that the system used here is very simple and not in an optimized form. Changes could be made, for example, to move the Category field of the tblParts table into another table. tblParts would then refer to a foreign key in the new category table. This is a more normalized approach to the data, and would make maintenance easier in the long run. Also, further changes could be made to streamline the tblOrders and tblShoppingCart tables. Rather than maintaining six different fields (one for each customizable part), you could create one ProductID field, which would link to the tblOrders table. Additional security measures would have to be implemented to ensure that data is entered properly. The shopping interface could use a few new features as well. For instance, users should be able to view and modify their personal information, as well as their order histories. Site personalization might be another desired feature. This includes using customized welcome messages, allowing users to rearrange the layout of the page or to decide what parts they want to see, and even allowing them to view their BananaMobile as it is assembled! (This last part requires some very clever use of images and data.) There is a lot of additional functionality that can be placed in the Web Service. Users, through the BananaConnect system, should also be allowed to download all their statistical information at once. You could even set up a system to compare different users' statistics to enable a competitive online environment! Your work is never done, and there will always be new features and technologies to add to the site. | 
