1. ADVANTAGES OF DATABASE SYSTEM DESIGN CYCLE
The main advantages of database system design cycle are:
- It is the most efficient way of designing a database system.
- Steps are categorized into different phases and work is assigned according to priority to save precious time.
- It is a systematic approach.
- Major modifications to database system are identified in earlier stages of the cycle.
- Easy to take decisions on critical issues.
- 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)