Oracle XSQL- Welcome to the exciting world of eXtended Structured Query Language (XSQL) development! What’s so exciting? Efficiency and ease of use. XSQL isn’t some razzle-dazzle technology to wow your users. It also isn’t the latest X standard du jour that no one can stop talking about until you ask, “But what does it do for me today?” The problem with all of the great stuff out there is that no one technology does it all. | 380 Chapter 14 A Sample Application Our sample application is an online catalog for the Mom N Pup retailer. In the course of developing this application we ll run into some issues that are best resolved with action handlers and a programmatic approach. For now we ll follow roughly the design process that we laid out in the previous section. Much of the remainder of our discussion in this chapter will revolve around our development. In this section we ll develop the site map for the application and implement the database schema. The Requirements The first step in our process is to state the requirements for the application. The customer wants an online catalog that will be available over the Web. They currently don t have a database so they ll need to have one built to contain the data. They want the users to either browse based on product category or perform searches based on the descriptions. In addition they want to be able to edit the prices of products through a Web interface. At a high level the requirements are as follows Web-based online catalog browsable by product category and searchable by keywords Database to store data Edit function for prices In addition to these requirements they are also throwing a couple of curve balls. First they want some products to belong to more than one product category. For instance hand soap could be used in the kitchen or in the bathroom. They want hand soap products to appear under both kitchen supplies and bathroom supplies though for internal purposes it should be stored under only under one product category. They ve browsed some other product sites and don t like it when too many product titles are loaded at the same time. Instead they want the results of a query to be separated across several pages. Mom N Pup also runs specials from time to time. They want the home page to have a list of specials on the right-hand side of the home page. Clicking on the ad will take the shopper directly to the product page for the .
