Inventory tracker
Your task
Design a simple inventory tracker for a small online store. Each product has a quantity in stock. When an order is placed you must decrement stock, and you must not let two simultaneous orders both buy the last unit (oversell). Order volume is modest but occasional bursts happen during sales. Describe the data model and how you keep stock counts correct under concurrent orders.
It covers
- Stock tracking
- Concurrency
- Consistency