Appendix B. DB2MALL Database
To illustrate the examples and samples in this book, we have created a simple database called DB2MALL.
The plot behind the DB2MALL database is the following:
Consider an actual mall with several stores in it. All the stores are defined in the STORE tables. Each store sells products. All the products carried by all stores are defined in the PRODUCT table. This table has a column called STORE_ID, which associates which store carries which product. These products are bought by customers, who are saved in a table called CUSTOMER. Every time a customer places an order, an entry is inserted into the CUSTOMER_ORDER table. This table holds the general information of the order. Also, an entry is inserted into the CUSTOMER_ORDER_ITEM ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition 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.
