Analysis/Design

  • Requirement analysis
  • Entity-Relationship diagram
  • Logical Data Model

Implementation

  • Physical Data Model
  • Table attributes
  • Deployment scripts
  • Seeding scripts
  • Query/view development

Administration

  • User admin
  • Server config
  • Maintenance scripts

Optimisation

  • Performance analysis
  • Query optimization
  • Table/Index/Relation optimization

Evolution

  • Feature updates
  • Migration scripts
  • Migration tests