Database SDLC Phases

SDLC stands for System Development Life Cycle in oracle.We can develop a DB using SDLC, which contain different phases.We follow Top-down systematic approach to DB development, its help transformation of business information requirement into operational DB.

  1. Strategy & analysis phase
  2. Design phase
  3. Build & documentation phase
  4. Transition phase
  5. Production phase
Strategy & analysis phase:
  • First Study and analysis the business requirement.
  • Interview user and manager to identify information requirement.
  • Incorporate enterprise and application mission statement.
  • Build a model of the DB system
  • Transfer business narrative into graphical representation
  • Confirm the model with the analyst and experts.
Design phase:
  • Design the DB based on model which we developed on first phase.
Build & documentation phase:
  • Build prototype system, write and execute the command to create table and objects of DB.
  • Develop user documentation, manuals to support user and operation of system.
Transition phase:
  • Refine prototype.
  • Application should be sent to user acceptance testing.
  • Conversion of existing data.
  • Make any modification required to DB.
Production phase:
  • Operate the production system.
  • Monitor its performance and enhancement
Previous
Next Post »