Design E-Commerce Tables and Indexes for Recent-Spend Queries
Company: Visa
Role: Software Engineer I
Category: System Design
Difficulty: medium
Interview Round: Online Assessment
Overview: Design normalized users, products, orders, and order-line tables for an e-commerce system, preserving historical charged prices and enforcing useful integrity constraints. Propose workload-driven indexes for recent completed-order spend and explain how execution plans would validate them.
Read the full Visa Software Engineer I interview experience this question came from