You are here

Database Life Cycle

19 January, 2016 - 14:28

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.

http://www.oercommons.org/courses/the-database-development-life-cycle/view

media/image2.png
Figure 13.2 Source: http://www.oercommons.org/courses/the-database-development-life-cycle/view
 

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.

http://cnx.org/content/m28139/latest/

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.

http://www.oercommons.org/courses/the-database-development-life-cycle/view