Databases



A Database is a collection of data with common features. Two main characteristics:
 * fields and
 * records

Electronic databases have distinct advantages over paper based databases.


 * Databases in Primary Schools**

They pose questions where the answer can only be **yes or no** and they distinguish between shapes, trees, minibeasts etc. It uses progressive elimination, until only one item is left
 * Usually **different** from the databases used in other contexts
 * They are designed to **facilitate learning** about the processes and possibilities of data handling as well as the retrieval and manipulation of information.
 * Examples of Databases:**
 * Branching Tree Databases (Binary)

All of the information are in **one place**. However, only one record can be viewed at one time. These databases comprise of records ** arranged in fields ** and holding data. Like a ** spreadsheet **. **Can use Junior Viewpoint in schools - suitable for year 3/4s**.
 * Flat File Databases (Tabular)

They have a complex structure and are information **tagged** (i.e. google/wikis), like hyperlinks. The tagging
 * Relational Databases
 * interrelates data **, and there is greater flexibility in interrogation.


 * Databases and the NC**

ICT Pupils should be taught how to **gather information** from lots of different sources e.g. Databases, Internet, TV etc They should be able to ** enter and store information ** in a lot of different forms, e.g. stroing information in databases and saving data
 * KS1**
 * Good example** : []

Pupils should be able **make their own databases** and be able to ** talk about what they need ** and be able to** interpret ** the information.
 * KS2**


 * Legal and Ethical Issues**


 * Data Protection Act
 * Privacy and sensitivity