Database programs let users create and edit single files interactively at the keyboard. However, as soon as they want data in one file to automatically update another, programming has to be done.

A data element is defined by size (in characters) and type (alphanumeric, numeric only, true/false, date, etc.). A specific set of values or range of values may also be part of the definition.