Scenario: Guard Against Negative Inventory

Interviewer prompt: Inventory updates from multiple services caused negative stock values. What schema and query-level protections should be added?

inventory(sku_id, stock_qty)