Databases – Lesson 1

1. Databases– Lesson 1 Key Stage 3 ICT

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

3. 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

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

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

6. 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.

7. 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

8. How big are your pockets? Stores the same as 21

9. E-Bay – Search Results

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

11. Breaking it down…Items of the same type are called FIELDS. Field Field

12. Breaking it down…All the information (Fields) belonging to one item is a RECORD Record

13. Breaking it down…All the same type of records in a database are stored in a TABLE. Table

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

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

16. 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.

17. 1. Database is • A database is a collection of information which is stored in a logical and structured way. • Answer a)

18. 2. Record All information relating to one thing in a database is called a RECORD. Answer c)

19. 3. Field Each piece of information is a FIELD Answer a)

20. 4. Table All the same type of records in a database are stored in a TABLE. Answer b)

21. 5. One advantage for a database is… • You can search massive amounts of data very quickly compared to a paper database. • Answer b)

22. 6. One disadvantage for a database is… • You need technology for it to work. Electricity, computers, software engineers, data entry clerks. • Answer a)

23. Add up your answers • 1 – mark per correct answer – • Put your total at the bottom.