Advantages and Limitations of Database System Design Cycle

1. ADVANTAGES OF DATABASE SYSTEM DESIGN CYCLE

The main  advantages of  database system  design cycle  are:

1. It is the most  efficient  way of  designing  a database system.
2. Steps are categorized into different phases and work is assigned according to priority to save precious time.
3. It is a systematic approach.
4. Major modifications to database system are identified in earlier stages of the cycle.
5. Easy to take decisions on critical issues.
6. A proper documentation is done throughout the cycle that helps in understanding the flow and  also  helpful  for future enhancements.

2. LIMITATIONS

Any error identified in later stages  leads to start the whole  cycle from the beginning.

Source: Gupta Satinder Bal, Mittal Aditya (2017), Introduction to Basic Database Management System, 2nd Edition-University Science Press (2017)