| |
Time: 12 hours
Level: Advanced
| |
| |
 Introduction Resource- Relational database systems underpin the majority of the managed data storage in computer systems. This unit presents an overview of the development life cycle for a database system and highlights how...
| |
| | The database development life cycle
- 1 Introduction Resource
- In this unit we look at an outline of the stages involved in the development of a database. We consider the broader issue of how to decide what should be in a database and how to structure the tables that...
- Desirable properties of a database Resource
- As you will see, there are many possible choices that can be made during the design and many rules to guide this work. When trying to decide if some choices are better than others, you need to consider...
- 2 A development life cycle Resource
- Database development is just one part of the much wider field of software engineering, the process of developing and maintaining software. A core aspect of software engineering is the subdivision...
- 3 Requirements gathering Resource
- Here we are concerned only with the requirements that relate specifically to the data. Establishing requirements involves consultation with, and agreement among, all the users as to what persistent data...
- 4 Analysis Resource
- Data analysis begins with the statement of data requirements and then produces a conceptual data model. The aim of analysis is to obtain a detailed description of the data that will suit user requirements...
- 5 Design Resource
- Database design starts with a conceptual data model and produces a specification of a logical schema; this will usually determine the specific type of database system (network, relational, object-oriented)...
- 6 Implementation Resource
- Implementation involves the construction of a database according to the specification of a logical schema. This will include the specification of an appropriate storage schema, security enforcement, external...
- 7 Testing Resource
- The aim of testing is to uncover errors in the design and implementation of the database, its structure, constraints and associated user and management support. Testing is usually considered to involve...
- 8 Maintenance Resource
- Databases are one of the more enduring software engineering artefacts; it is not uncommon to find database implementations whose use can be traced back for 15 years or more. Consequently, maintenance of...
- 9 Summary Resource
- Relational database systems underpin the majority of the managed data storage in computer systems. In this unit we have considered database development as an instance of the waterfall model of the software...
| |
| | References and Acknowledgements | |
Except for third party materials and otherwise stated, content on this site is made available
OPML Feed
