Skip to main content

Column Constraints

During the data analysis phase, business rules will identify any column constraints. For example, a salary cannot be negative; an employee number must be in the range 1000 - 2000, etc.

Oracle, and some other RDBMSs, will allow storage of these rules within the database itself. That is, in a central data dictionary (see later).

Next: User-Defined Integrity Constraints