Year 9 - Database – Part One

Objective

To understand how to add and retrieve information when working with databases.

Starter

Test your knowledge of databases by completing this activity!

uPhone Database

Adam has created a database containing details of 50 mobile phones, download it and save it your uPhone folder.

He didn’t have time to finish it and there are some popular models missing.

He needs you to find the details of the following models and add them to the database:

iPhone 4
HTC Wildfire
Blackberry Curve 8520

Recommendations

Adam would like you to create a list of recommended mobile phones for three different types of user:

Teenagers
Business Users
Senior Citizens

You will use queries to search the databse for suitable mobile phones.

Complete this activity as a class to help you choose the criteria that you will use in your queries.

NB. Teachers will need to print off a set of these cards for this activity.

Query One

Now you need to create a query to find a list of suitable mobile phones for teenagers.

You can use the tutorial to help you.

Game

How well do you know database keywords?

Play this game to find out!