Pages in this set

Page 1

Preview of page 1
IT revision notes chapter 5 database

Database

A database is a collection of related data.
Can store lots of data without taking up much space
Users can search, sort and combine data quickly
Used to produce reports

Database terms

Entity

Name given to anything data is stored about
Data held…

Page 2

Preview of page 2
Have individual data types and their own validation
Each field has its own data type

Keys

Primary key

This is a field in a table that allows each record to be uniquely identified
Each value in the primary key must be unique
ID can be a primary key as it…

Page 3

Preview of page 3

Comments

No comments have yet been made

Similar ICT resources:

See all ICT resources »See all resources »