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
|
Database |
A structured store of related data, stored in a computer. Data in a database can be accessed and interpreted in many different ways |
|
|
Table |
A structure used to store date in a database. One table usually contains details about one real world thing |
|
|
Record |
One instance within a table, visible across a single row. If a 'car' table contains details about four cars it contains four records |
|
|
Field |
A single piece of data stored for each record, Column. In a database about books, the fields may be 'author', 'title' |
|
|
Relationship |
A link between two tables to model that data within the two of them is related. For example a link between a teacher table and a class table |
|
|
Primary Key |
A field within a table, used to uniquely identify each record |
|
|
Foreign Key |
The primary key taken from one table is used as the foreign key in another table, relationships exist between primary and foreign keys |
|
|
Structured Data (5) |
Predefined format Into a table with rows and columns Easy to analyse Can be processed using standard database tools Ideal for storage |
|
|
Unstructured Data |
No specific format Difficult to analyse Need advanced natural language processing techniques Not typically stored in a database |
|
|
Composite Key |
A combination of fields in a table that is used to uniquely identify a record |
