Whenever you're ready, walk me through how you'd approach this.
Explain the pros and cons of sharding versus partitioning in database design and when you would choose each approach.