Composite primary key
| Consists of the primary key fields from the two intersecting relations.
|
 |
|
|
Data dictionary
| Contains the logical structure for the information in a database.
|
|
|
|
Foreign key
| A primary key of one file (relation) that appears in another file (relation)
|
|
|
|
Integrity constraint
| Rule that helps ensure the quality of the information.
|
|
|
|
Intersection (composite) relation
| A relation you create to eliminate a many-to-many relationship.
|
|
|
|
Primary key
| A field (or group of fields in some cases) that uniquely describes each record.
|
|
|
|
| Query-by-example (QBE) tool | Helps you graphically design the answer to a question.
|