Section 1 Flashcards
(20 cards)
Table
A collection of records organised by rows and columns
Foreign key
A primary key in one table that allows one table to be linked to another
Record
A single row in a table that has a collection of data
Referential Integrity
A way of making sure that redundant data isn’t entered into the database
Normalization
Where data is normalised to minimise redundancy of data and to make databases easier to maintain
1NF
- Atomized data
- No repeated fields
- Dependent on the primary key
Data
Raw facts that have no meaning
Information
Taking the data and processing it by adding
Data+Structure+Context+Meaning
Knowledge
Taking information and manipulating it with a set of rules
Alphanumeric
Consists of letters and numbers
Real
A numerical data type that includes decimals
Integer
A numerical data type that is a whole number
Text/String
An alphanumeric data type that can be characters or symbols
Date/Time
A data type that uses a combination of numbers to represent the date or time
Direct data
Data that is used for a purpose other than the reason it was collected
Indirect data
Data that is used for a purpose other than the reason it was collected
Static information source
An information source which cannot, or is unlikely to, be updated
e.g newspaper
Dynamic information source
An information source that is frequently updated
e.g websites
GIGO
[G]arbage [I]n = [G]arbage [O]ut
Means that if all of the data input is not very good then the information coming out will not be very good
Encoding data
Taking original data and storing it in a different representation by putting the data into code
