CAN you help explain key concepts and differences as stated in these problems? Thx$!$

Critical Thinking Questions

$26.$ Explain how the concept of data sharding in NoSQL databases balances scalability and consistency and describe a situation where sharding may introduce challenges.

$27.$ What is the difference between a primary key and a composite key? Provide an example of when a composite key might be necessary in a database design.

$28.$ Describe a scenario where using a denormalized database schema would be more beneficial than a fully normalized schema. What trade$-$offs might you encounter?

$29.$ Propose a relational schema for a ride$-$sharing app that tracks drivers, riders, rides, and payments. Discuss how integrity constraints would ensure reliable data.

$30.$ Compare data lakes and data warehouses. What are the strengths and weaknesses of each, and how would you choose between them for a big data analytics project?