Section 1 Flashcards
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
