A | B |
Table | An arrangement of data in which the data are arranged in columns and rows. |
Perspective | Point of view. |
Primary key | A constraint which ensures that the column contains no null values and uniquely identifies each row of the table. |
Data integrity (entity integrity) | The state or quality of the data in the database as being entire or complete, honest, and correct. |
Generic | Relating to or descriptive of an entire group or class. |
Column | A means of implementing an item of data (attribute) within a table. |
Foreign key | A column or set of columns that defines how tables relate to each other. |
White space | Space on a page or poster not covered by print or graphic matter. |
High-volume entity | An entity that will have a large number of instances. |
Data structure | A physical method of organizing a collection of data in a database to allow it to be manipulated effectively. Examples of data structures are: table, index, view. |
Unique key | An integrity constraint that requires every value in a column or set of columns be unique. |
Row | An entry in a table, consisting of values for each appropriate column. (an instance) |
Property | A characteristic. |