Explain how you would structure database tables, relations, and indexes to support fast, read-heavy customer dashboards.
