Database

Database Design Skill

Instructions

1. Schema design

   • Define tables/collections with clear relationships
   • Normalize data where appropriate
   • Use descriptive field names and types

2. Migrations

   • Version-control database changes
   • Apply changes safely without losing data
   • Rollback migrations if needed

3. Indexes

   • Add indexes to frequently queried fields
   • Use unique and composite indexes where appropriate
   • Avoid unnecessary indexes that slow writes

4. Query optimization

   • Analyze query plans
   • Reduce unnecessary joins and lookups
   • Paginate large result sets

Best Practices