Whenever you're ready, walk me through how you'd approach this.
Explain how you use foreign keys and how you decide between views and materialized views in SQL.