DB Lesson 1 - Tea Drinker :: Novice Blogger

Download Report

Transcript DB Lesson 1 - Tea Drinker :: Novice Blogger

DATABASES – LESSON 1

Key Stage 3 ICT
STARTER
Open the ICT levels spread sheet and find the
Database tab
 Read each orange box and answer in the white box.

OBJECTIVES

Be able to define what makes a database and basic
keywords

Know where databases can be used

Know how to apply search techniques to a database
OUTCOMES



All: Will be able to name and define a database, and its key terms
Most: Will have searched on-line databases using AND / OR
Some: Will be able to discuss why databases are used
COPY THE MODULE RESOURCES

Go to
Common K  ICT  Year 7

Copy the folder Unit 4 Databases to
My Documents  ICT  Year 7

This folder contain all the resources you need
for the database module.
TARGETS.


Open the database workbook and fill in the boxes in
purple ellipse (squashed circle)
This workbook will be used throughout the databases
unit – DO NOT LOSE IT. It will be used at the end by
the teacher to assess your ICT Level.
A DEFINITION


A database is a collection of information which
is stored in a logical and structured way.
In other words, it is some information which is
saved and organised sensibly.
COMPUTERISED DATABASES
There are millions of these!
 You use quite a few…



Facebook, Google, PicSearch, EBAY, Gmail
Microsoft Access

In your Database folder, open the Database
Workbook

In your booklets – Task 1A - Page 1
Write your definition of a database
Write some advantages?
Write some disadvantages?

Let’s look at one Database
HOW BIG ARE YOUR POCKETS?
Stores the same as
21
E-BAY – SEARCH RESULTS
BREAKING IT DOWN…

What information is this result made up of?

Each piece of information is a FIELD.

All information relating to one thing is called a
RECORD.
BREAKING IT DOWN…
ITEMS OF THE SAME TYPE ARE CALLED FIELDS.
Field
Field
BREAKING IT DOWN…
ALL THE INFORMATION (FIELDS) BELONGING
TO ONE ITEM IS A RECORD
Record
BREAKING IT DOWN…
ALL THE SAME TYPE OF RECORDS IN A
DATABASE ARE STORED IN A TABLE.
Table
DEFINE THE CONTENT OF A DATABASE
Using the Video Club Fields document
 There are fields which are needed to join a film club

- They are the orange boxes.

Put the fields into a logical order.
How many would be needed to make a record?
 Why is membership number needed?
 Match the data item to the fields – the purple ones.


Extension:
Write your own data items onto the green ovals.
TASK 1B

In your workbook complete the Database search task
– on Page 2.
Go through results with students
 Searching is called querying in databases
 When you selected additional features – this is an
AND query – the PC has to have all the features.
 Insight could operate without an electronic – but it
would be very slow and rely on paper and humans.

PLENARY QUIZ – TASK 1C

Question Time.

Answers the questions in your booklet.

Ready…….

Here come the answers – mark your own – I
know you will be honest.
1. DATABASE IS
A
database is a collection of
information which is stored in a
logical and structured way.
Answer
a)
2. RECORD
All information relating to one
thing in a database is called a
RECORD.
Answer c)
3. FIELD
Each piece of information
is a FIELD
Answer a)
4. TABLE
All the same type of
records in a database are
stored in a TABLE.
Answer b)
5. ONE ADVANTAGE FOR A DATABASE IS…
You
can search massive
amounts of data very quickly
compared to a paper
database.
Answer
b)
6. ONE DISADVANTAGE FOR A DATABASE
IS…
You
need technology for it to
work. Electricity, computers,
software engineers, data
entry clerks.
Answer
a)
ADD UP YOUR ANSWERS

1 – mark per correct answer –

Put your total at the bottom.