6.2 The Warehouse Example

You have a warehouse system that stores the current quantity on hand of each product in stock. Those values change in real time throughout the day as products are shipped in or out of the shop.

Your stock record, which has been simplified for this example, looks like this:

CREATE TABLE Stock(
   ProductId CHAR(40),
   Qty INTEGER
   PRIMARY KEY(ProductId)
)

Recipes in this chapter are based on this example.