Design a database schema from scratch based on business requirements, then normalize and denormalize the structure as needed for analytical queries.
