Question for Backend Engineer position

Talk about your projects end to end (problem statement, scope, requirements, design, impelementation, testing, production, impact, collaboration)
If you were designing an inventory system for a retail store, what data entities and relationships would you include to support sales transactions, stock replenishment, and customer order tracking?
Write an SQL or DDB expression to consistently update inventory quantity when customers buy an item?