Computing Lesson 3 Using a Database Flatfile Databases

Computing Lesson 3: Using a Database Flat-file Databases Andy Bush 1 Materials from the Teach Computing Curriculum created by the National Centre for Computing Education

Task 1 - Grouping Paper Records Cut off the corners of your record cards that don’t have ticks. Can fly ● How many animals in your database have six legs? Name: ● How many animals in your database can fly? ● How many animals are more than one colour? 2 ✓ Has six legs Antelope Lives in large groups Is more than one colour

Task 2 - Searching for Answers Open oaknat. uk/comp-d 52 -2 Use the search function to answer the questions below: 1. Which countries in the database use the Euro as currency? 2. Which two countries are Chinese-speaking? 3. Which country has a population of 8, 800, 000? 4. Which countries have a population of over 100, 000? 3 Source: J 2 E

Task 3 - Grouping and Sorting Group and sort the data to answer these questions: 1. Which German-speaking country has the largest population? 2. Which Chinese-speaking country has the smallest population? 3. Which country using the Euro currency has the smallest area? 4. Which country using the Euro currency has the smallest population? 5. Out of all the countries with a population of over 100, 000, which has the largest area? 4