How Are Missing Values Generally Handled in Database Management Systems

Question

Examlex · Accepted Answer

The Answer is When dealing with missing data, there are many options. Two integrity controls (default value and null control) will handle this problem. One also could substitute an estimate for the missing value which would then be stored in place of the missing value (and marked as an estimate). Another possible method is to use triggers to track missing values and create a log which can be viewed later. One other method is to perform sensitivity testing, which will tell us whether having missing data greatly impacts results. If results are not impacted, then the missing values are ignored.

How Are Missing Values Generally Handled in Database Management Systems

Definitions: