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