Your question is Schema for Real-Time Reporting. 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).
Create a database and explain the schema, and how would you modify it for real time reporting?
Treat this as a hands-on design exercise. Define the core entities, keys, relationships, indexes, and representative DDL, then explain how you would adapt the design and pipeline for real-time ingestion, transformations, freshness, consistency, replay, and monitoring.