Your question is Relational Data Model for E-Commerce. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Design a relational data model for an e-commerce domain and discuss how the data would be used and the tradeoffs between modeling approaches.
Asked in the data modeling stage. Senior DE onsite, conversation-driven. Focus on entities, relationships, and how the schema supports analytics, ML features, and operational queries.