3950186
A2 Database Systems
- Relational Database
- 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
- 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
- A database where all data is held in one single table
- Data Consistency
- Using a central pool of data
- Using a central pool of data
- Data Redundancy
- Refers to the uneccessary duplication of data
- Refers to the uneccessary duplication of data
- Data Integrity
- Correctness of the data
- Correctness of the data
- Data Independance
- The data and applications used to access it
are independent/ seperate
- 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
- 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
- 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
- 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
- The organisation of data into tables which relate to a single entity
- Data Warehouse
- A large collection of archived data used for decision making
- 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
- 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
- Holds a collection of centralised data for further manipulation in various ways
- Query
- Request for specific information
- SQL
- Structured query language
- Structured query language
- Request for specific information
- Data Dictionary
- A central store of information about data
- 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
- Has data stored on a number of
computers at different locations
bu appears as one logical
database
Want to create your own Mind Maps for free with GoConqr? Learn more.