Walk through a real-time scenario where you had to design a database schema. How did you handle database design, indexing, and primary key selection?
