2
Open the ICT levels spread sheet and find the Database tab Read each orange box and answer in the white box. S TARTER

3
O BJECTIVES 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 O UTCOMES 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

4
C OPY 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.

5
T ARGETS. 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.

6
A D EFINITION 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.

10
B REAKING 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.

11
B REAKING IT DOWN … I TEMS OF THE SAME TYPE ARE CALLED FIELDS.

12
B REAKING IT DOWN … A LL THE INFORMATION (F IELDS ) BELONGING TO ONE ITEM IS A RECORD

13
B REAKING IT DOWN … A LL THE SAME TYPE OF RECORDS IN A DATABASE ARE STORED IN A TABLE.

14
D EFINE 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.

15
T ASK 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.