Designed a Cassandra schema for a social media app ie Facebook with suitable partition keys, clustering keys, and secondary indexes to match query patterns. Populated the database with sample data using denormalization, materialized views, and collections to enhance storage and retrieval efficiency. Created and run various queries, optimize them for better performance, and compared the results before and after optimization.