LCEC Interview Question

How would you design a database schema for production, and how would that differ from archival access?