- Databases
Databases are used to store data.
Relational databases are databases which contain more than 1 linked table and reduce the chances of data being entered more than once) To create a relational database different tables are created and then primary and foreign key fields are identified which are used to link the tables together
Keywords
Record: A set of related data items about 1 person or thing
Field: one item of data about 1 person or thing
Key field: a field that contains unique data for each record
File: A collection of related data
Assigning datatypes to fields -
Text: Used to enter letters or numbers or both together - Integer (Number): Used to enter numbers only and numbers that are likely to be used in some sort of calculation
- Boolean (Yes/No): Used when a field can only contain two possibilities e.g. Y or N, True or False
- Currency: Used for amounts of money