We can use the waterfall cycle as the basis for a model of database development which incorporates three assumptions:
- We can separate the development of a database – that is, specification and creation of a schema to define data in a database – from the user processes that make use of the database.
- We can use the three-schema architecture as a basis for distinguishing the activities associated with a schema.
- We can represent the constraints to enforce the semantics of the data once, within a database, rather than within every user process that uses the data.
Using these assumptions, the diagram above represents a model of the activities and their outputs for database development. It is applicable to any class of DBMS (database management system), not just a relational approach.
Database Application Development is the process of obtaining real-world requirements, analyzing requirements, designing the data and functions of the system and then implementing the operations in the system.