| A | B |
|---|
| Column | A means of implementing an item of data (an attribute) within a table. |
| Data integrity | The state or quality of the data in the database as being entire or complete, honest, and correct. |
| Transform | To change. To change the elements of an ERD (entities, attributes, relationships) into database elements (tables, attributes, foreign keys). |
| Table | An arrangement of data in which the data are arranged in columns and rows. |
| Primary key | A constraint which ensures that the column contains no null values and uniquely identifies each row of the table. |
| Data types | A classification identifying one of various types of data, stating the possible values for that type, the operations that can be done on that type, and the way the values of that type are stored. |
| NUMBER(size) | A data type that is commonly used for numbers. |
| Discriminator column | A column that is created in the single table implementation of the supertype, to hold values that distinguish between the subtypes. |
| Map | To associate the elements of an ERD (entities, attributes, relationships) with database elements (tables, attributes, foreign keys). |
| VARCHAR2(size) | A data type that stores variable-length strings. |
| CHAR(size) | A data type that stores fixed-length character strings. |
| Cascade barred relationship | A series of relationships implying that the unique identifier of each entity in the chain is carried down to the entity on the next level. |
