Introduction to Structured Query Language - Database Processing: Fundamentals, Design, and Implementation - page 95

WarehouseID SKU SKU_Description QuantityOnHand QuantityOnOrder

100 100100 Std. Scuba Tank, Yellow 250 0

200 100100 Std. Scuba Tank, Yellow 100 50

300 100100 Std. Scuba Tank, Yellow 100 0

400 100100 Std. Scuba Tank, Yellow 200 0

100 100200 Std. Scuba Tank, Magenta 200 30

200 100200 Std. Scuba Tank, Magenta 75 75

300 100200 Std. Scuba Tank, Magenta 100 100

400

100200 Std. Scuba Tank, Magenta 250 0

100 101100 Dive Mask, Small Clear 0 500

200 101100 Dive Mask, Small Clear 0 500

300 101100 Dive Mask, Small Clear 300 200

400 101100 Dive Mask, Small Clear 450 0

100 101200 Dive Mask, Med Clear 100 500

200 101200 Dive Mask, Med Clear 50 500

300 101200 Dive Mask, Med Clear 475 0

400 101200 Dive Mask, Med Clear 250 250

100 201000 Half-Dome Tent 2 100

200 201000 Half-Dome Tent 10 250

300 201000 Half-Dome Tent 250 0

400 201000 Half-Dome Tent 0 250

100 202000 Half-Dome Tent Vestibule 10 250

200 202000 Half-Dome Tent Vestibule 1 250

300 202000 Half-Dome Tent Vestibule 100 0

400 202000 Half-Dome Tent Vestibule 0 200

100 301000 Light Fly Climbing Harness 300 250

301000 250

200 Light Fly Climbing Harness 250

301000 Light Fly Climbing Harness 0 250

300

400 301000 Light Fly Climbing Harness 0 250

100 302000 Locking Carabiner, Oval 1000 0

200 302000 Locking Carabiner, Oval 1250 0

300 302000 Locking Carabiner, Oval 500 500

400 302000 Locking Carabiner, Oval 0 1000

Figure 2-28
Cape Codd Database
INVENTORY Table Data