Database Life Cycle

Database Life Cycle

1. Design

   • Requirements Analysis
     • Interview both producers and users
   • Logical Design
     • Conceptual Data Modeling
     • View Integration
     • Transformation
     • Normalization of tables
   • Physical Design
     • Involves the selection of indexes, partitioning, and clustering of data

2. Implementation

   • Database implementation, monitoring, and modification
     • Data Definition Language
     • Data Manipulation Language

3. Maintenance

   • Integrity check
   • Consistency check
   • Backups
   • Compaction of the bases