Development Life Cycle

 Development Life Cycle

Desirable properties of a database

Completeness: Ensures that the users can access the data they want.

Integrity: Ensures that data is both consistent and correct

Flexibility: Ensures that the database can evolve

Efficiency: Ensures that users do not have unduly long response times when accessing data.

Usability: Ensures that data can be assessed and manipulated in ways which match user requirements.

 

Database development is the process of developing and maintaining software; a core aspect of software engineering that contains steps and the collection of these steps is referred to as a development lifecycle. The software product moves through this lifecycle until it is finally retired from use.

 

Waterfall model: Illustrates the process as a strict sequence of steps where the output or one step, is the input to the next, and all of one step has to be completed before moving on to the next.

Establishing requirements

Analysis: Obtaining a detailed description of the data model. The conceptual Data provides a representation of what is being communicated between client and developer.

Design: The output of this is a detailed relational specification. The logical schema of all the tables and constraints needed to satisfy the description of the data.

Implementation: Involves the construction of a database

Bulk load: A large quantity of data

Testing: Uncovering errors

Validation: Has done right database been developed?

Verification: Has the database design been implemented correctly?

Maintenance: Can take care of three main forms:

1.    Operational maintenance-where the performance of the database is monitored

2.     Porting

3.    Requirements change