Database Skill

Database Design & Management

Instructions

1. Schema design

   • Identify entities and relationships
   • Normalize data where needed
   • Define primary and foreign keys

2. Tables creation

   • Use clear and meaningful table names
   • Define proper data types
   • Add constraints (NOT NULL, UNIQUE)

3. Migrations

   • Create versioned migrations
   • Support rollback and re-run
   • Keep migrations small and focused

4. Indexes & performance

   • Add indexes on frequently queried columns
   • Avoid over-indexing
   • Optimize for read/write balance

Best Practices

• Follow consistent naming conventions