Is kept on secondary storage and saved for the future.
2 of 20
Organised
Has a structure so they can be easily processed.
3 of 20
Validation
Checking data while it is input to ensure it follows expected rules.
4 of 20
CRUD
Create, Read, Update, Delete. These are the standard database operations.
5 of 20
Data Model
A structure for data within a database.
6 of 20
Flat File
All the data is stored in one file; for example a CSV (comma separated value) file.
7 of 20
Hierarchical
All the data is stored in one file; for example a CSV (comma separated value) file.
8 of 20
Relational
Data is stored in tables which have information about individual things called ‘entities’. Data can be linked by referencing other tables.
9 of 20
DBMS
Database Management System - software which looks after a database at a fundamental level.
10 of 20
Tables
Structures where data is stored.
11 of 20
Key
A unique identifier for a record in a database.
12 of 20
Primary Key
The unique identifier for each record in a given table.
13 of 20
Foreign Key
Any key used to reference data from a different table in the database.
14 of 20
Form
An interface to a database allowing users to update/edit information using a user friendly GUI.
15 of 20
Report
A document which is automatically generated using content from a database.
16 of 20
Query
A way to search for data in a database. These can combine information from more than one table.
17 of 20
Query Language
A way to create queries using a code-based interface. A popular example is SQL.
18 of 20
SELECT, FROM, WHERE
Boolean operators which can be used in SQL queries - for example: SELECT “name” FROM “teachers” WHERE “subject” The three main parts of an SQL query - for example: SELECT “name” FROM “students” WHERE “cs_pass” = TRUE= “CS” AND “fashionSense” = TRUE
19 of 20
AND, OR, NOT
Boolean operators which can be used in SQL queries - for example: SELECT “name” FROM “teachers” WHERE “subject” = “CS” AND “fashionSense” = TRUE
20 of 20
Other cards in this set
Card 2
Front
Persistent
Back
Is kept on secondary storage and saved for the future.
Comments
No comments have yet been made