Tiktok System Design Phone Screen August 2024

Round 1

Questions:

• Talk about your projects end to end (problem statement, scope, requirements, design, implementation, 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.