- Created by: Vicky
- Created on: 27-12-12 16:08
A database is the term to describe the storage of data
Flat file database
This is the most basic/ simplistic way of storing data,a flat file database is a single table with data in it.
A relational database is a large collection of data items with links between them. It is structured in a way that allows it to be accessed by a number of different application programs.
A distrubuted database is a singular database that is under the control of a DBMS where the storage devices are not all attached to a common processor. Instead the data is stored in storage devices attached to multiple computers located across a network.
Database management systen (DBMS)
Software that accesses data within a database
A staged (mathimatical) process, which removes repeated groups of data and inconsistencies.
This means that data and programs are stored seperately from each other.
The data that is stored in the database is reasonable as it has not been accidently or maliciously altered. (in other words, the extent to which the data is truthful in representing the original information presented)
This means that the data is duplicated unnecessarily
This is an object, person or thing that is represented in a database, e.g. customer, order, product
This is information that is held about an entity, this is known as an attribute.
Entity relationship diagrams
This type of diagram is used to show how entities are related to each other
When data is held in more than one file, when it should be stored in a consistent way
This is the process in which you interrogate large amounts of data, looking for potential patterns.
Data warehousing refers to large amounts of data that are stored together, usually in a single location for further processing