Transcript Databases – Lesson 1

DATABASES – LESSON 5
Key Stage 3 ICT
STARTER – TASK 5A


Make as many words as possible from the
following 2 words – write them in your work
book.
All information relating to one thing is a
R _E C
_ O
_ _R _D
To reorder items into alphabetical order is
SO
_ R
_ T
_
OBJECTIVES

Practice your database skills by solving crimes
OUTCOMES



All: Will have added data records & created queries
Most: Will have customised queries
Some: Will have created and customised forms
THE TASK
 Find
the missing information for the police
database
 Create a form
 Add the missing data into the database
 Write queries to identify possible suspects
COPY OF THE NATIONAL
POLICE DATABASE
- CRIMES


Open the database: Crimes Database
FROM
My Documents  ICT  Year 7  Databases 
Lesson 5
CREATE A FORM


Create a better
customised form
than this one.
Ebi:
More suitable
image
 Clearer field
names
 Each section was a
Different colour


Remember – use your booklet to help you.
MISSING RECORDS – TASK 5B



It has just been announced that there are 4 missing
records that need adding into the database.
Unfortunately some of the fields have been
scrambled….use your skills to unscramble them
Add them into the your database using your form
MISSING RECORDS - ANSWERS
Smith
Barry
Surname
Herbert
Tweed
Mavis
Barry
FirstName
James
Shantel
the original Stig
Chocolate Kid
Alias
Teflon
silver bullet
19-Jul-85
12-Feb-1967
DateOfBirth
3-Sep-1952
7-Dec-1992
F
F
Gender
M
F
USA
New York
BirthPlace
Leeds
York
O
O
BloodGroup
A
O
Brown
Brown
HairColour
Black
Black
Black
Blue
EyeColour
Blue
Blue
S
M
Build
M
S
11
8
ShoeSize
13
8
White
White
SkinColour
Black
White
None
Stones
In jail until 31st
July 2015
Tattoo of Dragon Distinguishin
on right arm
gMarks
Theft of
PastOffences
Chocolate
Died June 3rd
Comments
1986
Eye Brow
Piercing
Violent
Behaviour
Very Loud
None
Shop lifting
Always wears
silver trackies.
YOU ARE THE DATABASE

All criminals that have
shoe size < size 7
stand up
This selects you if your shoe size is 6 or less

The < is called a comparison operator – crocodiles

All criminals that have shoe size <> size 5 stand up

Shoe size > 23
<= 4
 Shoe size => 6

Shoe size
is the same as
is the same as
<5
shoe size > 7
shoe size
LETS USE OUR CRIMES DATABASE

All criminals that have blonde hair AND wear
shoes less size < 7
All criminals that have brown hair OR wear shoes
less size < 7
CSI TIME @ SELBY
Break in at the Selby Museum.
PC White arrived at the Museum
where he met the Security
guard. Here is what he said.
“It was about 10.30pm and I was just about to do a
sweep of the museum when I heard light footsteps, I
quickly turned around to see a dark figure emerging
from the basement doorway. The figure seemed small
and thin and started to move quickly. The figure was
heading for the back exit; I started to chase after them
but couldn’t keep up. They ran through the back exit
setting the main alarm off. By the time I had reached
the door they were gone. This was when PC Doyle
arrived.”
The Crime Scene Investigators(CSI) did
a sweep of the building, dusted for
finger prints, shoe prints and looked for
any other evidence that been left by the
suspect.
As they were passing PC White asked what evidence
had been found, the head CSI investigator said
some
Foot prints, skin cells
and some hair fibres were found.
CREATE QUERY - WALKTHROUGH
Gender is F
 Hair Colour is Brown
 Shoe Size is 3 or 5
 Skin colour is white

WHO DONE IT? - TASK 5C

Write the name of the suspect in your workbooks.

April Clarrington


Make sure you save your queries when you have
completed them.
There are some more puzzles in your workbooks
for your to complete.
YOUR TURN – CRIME 2 – TASK 5D
Hair colour is brown
Eye colour is blue
Build is M
Skin colour is white
EXTENSION – CRIME 3 – TASK 5E
Looking for 3 Youths
 Under the age of 30
 Same Hair colour
 Shoesize greater (>) than size 7
 Bloodtype A or O

PLENARY – TASK 5F
ASSESSMENT OF LEARNING

3 things you have learnt about queries?

2 things you found difficult

1 thing you would like to know more about.

Answer the above questions with the person next
to you now into your booklets. We will review in a
minute.