AdvertisementYour brand could be hereYour brand hereOn every Darslab page · students, parents and teachersinfo@darslab.comAsk for pricesPricesinfo@darslab.com
☰ Year plan · Computing

Keys, types and forms

Week 18 · Unit 7.4: The power of data · 3 lessons
Answers are for parents and teachers.
1
Look at the table. How many fields and how many records does it have? Which field is the best primary key?
TagNoNameSpeciesAge
31Cococat2
32Rexdog3
33Cocodog3
34Piprabbit1
2
Choose a data type for each field of a table about a school trip: Date of trip, Cost per child, Number of children, Permission slip returned (yes or no), Teacher’s name.
3
Why do schools give each pupil a pupil number, even if every pupil already has a name? Answer in two sentences.
4
Rewrite each line to make the form better: ‘Date: ______’, ‘Pet: ______’ (the answers are always dog, cat or other).
5
Make a data dictionary with five fields for a table that stores the books in a class library. Mark the primary key with a star.