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.
- Strategy & analysis phase
- Design phase
- Build & documentation phase
- Transition phase
- 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
ConversionConversion EmoticonEmoticon