ICT session 4 - Databases
http://ictsupport.weebly.com/databases.html - information on databases & link to powerpoint - there are lots of resources available
  • There are two main types of databases
  • Teachers need to ensure they have the appropriate software
  • Teachers have to prepare these suitable resources (questionnaire) - need to model these and demonstrate to children

Branching tree databases
  • Binary - trees
  • 'Guess Who' is a good starting point to introduce branching tree databases
  • You categorise until only one item is left
  • It's a yes/no category
  • It's hard for children to think of the questions
  • It supports sorting and classification
  • It supports data-handling activities across a range of subject areas
  • It provides opportunities for developing and refining questioning techniques
Coin_database.pngTizzy's First Tools for KS1
Travelling_to_school_database.pngFlexiTREE2 for KS2
Flatfile of tabular databases
  • Most familiar - one dimensional - can only see one record at a time
  • Card index fine analogy
  • Comprises records arranged in fields and these contain data through tallies or questionnaires
  • Used to retrieve information
Flatfile_database_-_food.pngInformation Workshop 2000 for KS2
Relational databases
  • Used in Year 6
  • This technology has overtaken the National Curriculum
  • It has a complex structure
  • Information is tagged (Key Stage 1 - Databases - Scheme of work) - this tagging interrelates data
  • Much better flexibility in searching