A large collection of data item links/
relationships between them structured in
a way that it allows it to be accessed by a
number of different application programs
Flat file database
A database where all data is held in one single table
Data Consistency
Using a central pool of data
Data Redundancy
Refers to the uneccessary duplication of data
Data Integrity
Correctness of the data
Data Independance
The data and applications used to access it
are independent/ seperate
Primary Key
Used to uniquely identify a particular record or line/ row in a table
Foreign Key
A field of one ore more table which is also a primary key of another
Links
When 2 or more tables contain the same field they can be linked
Data Normalisation
The organisation of data into tables which relate to a single entity
Data Warehouse
A large collection of archived data used for decision making
Data Mining
Interrogating the data to find patterns in
the data which is stored in the warehouse
Database Management System
Holds a collection of centralised data for further manipulation in various ways
Query
Request for specific information
SQL
Structured query language
Data Dictionary
A central store of information about data
Distributed Database
Has data stored on a number of
computers at different locations
bu appears as one logical
database