Non-volatile storage on a secondary storage medium such as a hard disk.
2 of 23
Data Duplication / Data Redundancy
Where the same data is stored more than once, unnecessarily.
3 of 23
Data Inconsistency
Where different versions of data become different because duplicate versions have been stored and updated differently.
4 of 23
Program-Data Independence
Where the applications that use a shared database are separated from the actual data by a database management system. Changes can be made to one application without it affecting another.
5 of 23
DBMS
Stands for Database Management System, the system that separates the applications from the data and provides features that allow database systems to be created, interrogated and maintained.
6 of 23
Views
A feature of a DBMS that provides each application or user with specific access rights and views of the database.
7 of 23
Flat File Database
A persistent organised store of data where data is stored in a single file organised into fields and records.
8 of 23
Relational Database
A persistent organised store of data where data is stored as a collection of related tables to minimise data redundancy.
9 of 23
Entity
A real world object, about which data is stored in a database, corresponds to a table in the relational database.
10 of 23
Table
A collection of data organised into records and fields within a relational database. A table represents a real-world entity.
11 of 23
Record
Data stored about one instance of an entity ie: one particular person or object.
12 of 23
Field
One specific data item being stored such as surname or shoe size.
13 of 23
Primary Key
A field in a table that uniquely identifies a record.
14 of 23
Foreign Key
A field in one table that is the primary key in another table and is used to create a relationship between those two tables.
15 of 23
Relationship
The logical connection created between two tables using a primary and foreign key pair.
16 of 23
Form
An interactive window used for data entry. Usually includes validation routines.
17 of 23
Validation
When the computer software checks that data entered is sensible.
18 of 23
Verification
Where data is entered twice and checked that each version is the same, to avoid data being entered with typing mistakes.
19 of 23
Queries
A feature of a DBMS that allows the database to be interrogated. It selects records from the database based on specified criteria.
20 of 23
Logic Operator
NOT, AND, OR. Used in complex criteria in queries.
21 of 23
Reports
Data from a database that has been processed and presented on a page in a way that makes it information. Designed for hardcopy.
22 of 23
Modules
Sections of code within a DBMS that allow the user interface to be tailored.
23 of 23
Other cards in this set
Card 2
Front
Non-volatile storage on a secondary storage medium such as a hard disk.
Back
Persistent Storage
Card 3
Front
Where the same data is stored more than once, unnecessarily.
Back
Card 4
Front
Where different versions of data become different because duplicate versions have been stored and updated differently.
Back
Card 5
Front
Where the applications that use a shared database are separated from the actual data by a database management system. Changes can be made to one application without it affecting another.
Comments
Report
Report