Glossary of Terms -Database concepts

HideShow resource information
  • Created by: kenyone
  • Created on: 14-05-16 09:31
Database
A persistent organised store of data.
1 of 23
Persistent Storage
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

Preview of the back of card 3

Card 4

Front

Where different versions of data become different because duplicate versions have been stored and updated differently.

Back

Preview of the back of card 4

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.

Back

Preview of the back of card 5
View more cards

Comments

No comments have yet been made

Similar Computing resources:

See all Computing resources »See all Databases resources »