Quality Of Data
Several techniques can be used to avoid letting “bad” data into a database
- Automatically generate the data, e.g. sequence numbers, dates, inherited data from other tables, etc.
- Masking the input to force a specific form of data, e.g. phone numbers, SS numbers, etc.
- Validation rules, constraints that are tested against the entered data … users are required to enter data that meets the constraint
These techniques are illustrated in the on-line demonstration