Discuss Star and Snowflake schemas, normalization versus denormalization, and slowly changing dimensions (SCDs) for Barclays data warehouses.