The database system provides you with the following tools to ensure data integrity.
· Integrity rules: integrity rules that refer to a table can also be specified (see CONSTRAINT definition).
· Key: a key comprising one or more columns can be defined for each table. The database system ensures that each key is unique. A key can also consist of columns of different data types (see key definition).
· UNIQUE definition: the uniqueness of the values in other columns and column combinations can also be ensured by using other mechanisms (see UNIQUE definition for "alternate keys").
· NOT NULL: by specifying NOT NULL, you can ensure that the NULL value is not accepted in individual columns (see column definition).
· DEFAULT definition: you can define default values for each column (see DEFAULT specification).
· Referential integrity conditions: by specifying referential integrity conditions, you can declare deletion and existence dependencies between the rows in two tables (see referential CONSTRAINT definition).