Sporty Children

We explored the data and you added yourself. Now, what about the sports?

Getting Started

Use the bell or 2Dos | Past to find Sporty Children and open it.

Do you remember how to arrange and group the cards?

Group the children by age and show me!

How many have brown eyes?

Database Design

Right now, we can’t tell which sport each child likes.

We need to change the database design to add a place to store the child’s chosen sport. We use the Design database tool.

1. Add the Sport field to your database.
2. Edit 2 or 3 cards to say which sport those children like.
3. Guess how long you would need to update all the cards.

What takes the most time when you are updating a card?

Choosing the Sport from a List

We improve our updating speed if we can pick the sport from a list. Let’s change the database design again.

First we need to decide all the sports they children might like. Let’s just choose some school sports.

• football
• netball
• tag rugby
• tennis

Now we can type them in just once, and we’ll be able to pick from the list when we update records.