Integrity ensures that the data in a database is both accurate and complete, in other words, that the data makes sense. There are at least five different types of integrity that needs to be considered:
- Domain constraints
- Entity integrity
- Column constraints
- User-defined integrity constraints
- Referential integrity
The data analysis stage will identify the requirements of these.
Next: Domain Constraints