Database Glossary – E
Useful Terms For Working With Data

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

E

Entity

A real-world object, observation, transaction, or person about which data are to be stored in a database.

Entity Integrity

A property of a table that is entirely consistent with the real world object data that it represents.

See also: Entity.

Entity, Major

Database table(s). Each major entity has a set of associated attributes, which translate into the columns of the table.

Export

An operation that takes data from a database or table and creates an export file, containing only data, in a simply structured and easily read form that can be imported by other applications into their native data file format.

See also: Import.

Expression

An SQL statement that returns a value.

Extraction

The process of selecting data from one environment and transporting it to another environment.

See also: Data Transformation.