Designing the JavaStop Database

The requirements of JavaStop described in Chapter 1 show that we will have in our database the following basic tables to keep track of our information:

  • Products— This table will keep track of all the products sold by JavaStop. Information stored in this table includes

    product_id specifies a unique ID for each product and serves as the primary key for this table.

    Description specifies the details of each product.

  • Price— This table will store the pricing information about each product. We might be giving special discounts for important customers and therefore the pricing information should be both the list price as well as the special price. Information stored in this table includes

    product_id refers to the product_id ...

Get e-Commerce Applications Using Oracle8i and Java from Scratch now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.