Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
12 Cards in this Set
- Front
- Back
|
Information imported from another source.
|
External Data
|
|
|
The primarry key of a table placed in another table. It is used to create relationships.
|
Foreign Key
|
|
|
The line representing the relationship between two tables.
|
Join Line
|
|
|
A junction table is present in a many-to-many realationship and can contain one or more records from the other two tables in this type of relationship.
|
Junction Table
|
|
|
A join-line between two tables.
|
Link
|
|
|
In Access, when relationships are created between three tables. The junction table can contain one or more records from the other two tables in this type of relationship.
|
Many-to-Many Relationship
|
|
|
In Access, where records are listed only once in a Primary table and appear multiple times in a related table.
|
One-to-Many Relationship
|
|
|
A field that uniquely identifies each record in a table.
|
Primary Key
|
|
|
A primary table is one half of a relationship. It is like a master list of records. Each record is uniquely identifed by a primary key and each record appears only once.
|
Primary Table
|
|
|
A set of rules that ensure data validity between related tables.
|
Referential Integrity
|
|
|
A collection of data that uses seperate tables to store different aspects of information.
|
Relational Database
|
|
|
The other half of a relationship. It contains the primaryu key from a Primary table and the records from the primary table can appear in it multiple times.
|
Secondary Table
|
