Suggest at least three data validation rules that might help reduce input errors for the video rental system.
What will be an ideal response?
Students might suggest several of the data validation checks starting on page 250. For example, an existence check would prevent empty data fields; a data type check would prevent inappropriate data entry (such as alphabetic data in the Member Number field); and a reasonableness check would set suitable limits in the Fee field.
Computer Science & Information Technology