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 primary key of a table placed in another table. Its 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 relationship 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 containone 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 muliple 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 identified by a primary key and each record appears ibly once.
|
Primary Table
|
|
A set of rules that ensure data validity between related tables.
|
Referential Integrity
|
|
A collection of data that uses separate tables to store different aspects of information.
|
Relational Database
|
|
The other half of a relationship. It contains the primary key from the primary table and the records from the primary table can appear in it muliple times.
|
Secondary Table
|