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;
10 Cards in this Set
- Front
- Back
|
Flat file |
A set of single tables with no links between them |
|
|
Relational database |
A set of related tables with links between them |
|
|
Foreign Key |
A field that appears in a table that is a primary key of another table and is used to form a link between two tables. It enables data from different tables to be linked. |
|
|
Primary Key |
A field or combination of fields that uniquely identify a record in a table |
|
|
Indexes |
indexes are separate data structures that are set up to improve access time to records |
|
|
First normal form |
This is a database where tables contain no repeating attributes or repeating groups of attributes |
|
|
Second normal form |
This is a database where tables contain no repeating attributes or no repeating groups of attributes and no partial dependencies |
|
|
Third normal form |
This is a database where tables contain no repeating attributes or repeating groups of attributes, no partial dependencies and no transitive dependencies |
|
|
Redundant Data |
Data that is stored repeatedly |
|
|
Inconsistent data |
multiple copies of Data that is supposed to be the same but is in fact different |
