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.