Example - Tables
•
System for managing inventory
•
InStore(prodID, storeID, qty)
•
Product(prodID, desc, mnfr, …,
WarehouseQty)
•
Order(orderNo, prodID, qty, rcvd, ….)
–
Rows never deleted!
–
Until goods received, rcvd is null
•
Also Store, Staff, etc etc