Level 4 Level 6
Level 5

Databases


19 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
Database
"A persistent, organised store of data in electronic form"
DBMS
Software application that handles the data directly and provides an interface to the database
Flat File
Type of database which contains only one table
Relational
Type of database in which two or more tables are linked to each other
Table
A set of data elements organised in fields and records
Entity
An object or thing of importance about which data is captured
Form
User interface tool which allows a user to enter or change data in a table
Query
Database management tool used to retrieve information based on specified criteria
Report
Database management tool used to present information to the user
Primary Key
A field in a table which uniquely identifies each record in that table
Foreign Key
A field used in one table to represent the value of a primary key in a related table
Redundancy
Name given to the undesirable effect of having duplicate data in a database
Validation
The automatic checking of inputted data by a computer system to ensure it is sensible
Record
All data about one item in a database
Field
A property of something stored in a database
Verification
The process of ensuring that data entered into a database is correct
Serial file
"A database file where Items are stored as a series, one after another"
ACID
Set of rules that guarantee that database transactions are processed reliably
Sequential file
A database file where a series of items is stored in a logical order