1 / 23

Databases – Lesson 1

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

kayo
Download Presentation

Databases – Lesson 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  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.

More Related