Learning Objectives Define different types of database Describe
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 1 Thursday, March 4, 2021 Introduction To Databases GCSE Computer Science Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 2 Thursday, March 4, 2021 Starter Create Your Superhero! Use the DC Kids Superhero generator to create your own superhero. Make sure that there is at least one difference to the person next to you! Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 3 Thursday, March 4, 2021 Our Key Terms e l i F t Fla Field d r o c e R Prim ary Key Query Atom ic Da ta y e K n g i e r Fo Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 4 Thursday, March 4, 2021 What is a Database? Add to your Glossary “A persistent, organised store of data” Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 5 Thursday, March 4, 2021 Make a list of all the databases you can think of… Time: 5 minutes total! (timer starts on click) MS Access Class register Calendar Email address book Paper diary Wall Calendar Anything else? 2013 mins 4 5 Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 6 Thursday, March 4, 2021 How is A Database Organised? s n m u l lds e i =F Co Rows = Rec ords Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 7 Thursday, March 4, 2021 Gather the following information in a table format from 5 other students… Time: 5 minutes total! (timer starts on click) First. Name (Text) Last. Name (Text) Has. Mask (Yes/No) Main. Top. Colour (Text) Main. Trouser. Colour (Text) Age (Integer) 2013 mins 4 5 Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 8 Thursday, March 4, 2021 How would you describe your database? All the data is in a single table in records, therefore it’s called a Flat File The alternative is a relational database with records in different tables Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 9 Thursday, March 4, 2021 Super Heros: The SQL Add to your Glossary SQL - “The language used to create and manipulate databases” CRUD - “An acronym used to describe what SQL can do: Create Read Update Delete” Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 10 Thursday, March 4, 2021 Selecting Data Stand up if you think the query applies to your superhero: SELECT * FROM Super. Heros WHERE Hair LIKE ‘Red’ Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 11 Thursday, March 4, 2021 Selecting Data Stand up if you think the query applies to your superhero: SELECT * FROM Super. Heros WHERE Gender = ‘Female’ Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 12 Thursday, March 4, 2021 Selecting Data Stand up if you think the query applies to your superhero: SELECT * FROM Super. Heros WHERE Name LIKE ‘B%’ Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 13 Thursday, March 4, 2021 Selecting Data Stand up if you think the query applies to your superhero: SELECT * FROM Super. Heros WHERE Name LIKE ‘%e%’ Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 14 Thursday, March 4, 2021 Selecting Data Stand up if you think the query applies to your superhero: a e am ! c e b uery t s ju ex q s i Th mpl co SELECT * FROM Super. Heros WHERE Top LIKE ‘green’ AND Trousers LIKE ‘purple’ Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 15 Thursday, March 4, 2021 Selecting Data Stand up if you think the query applies to your superhero: SELECT * FROM Super. Heros WHERE Top LIKE ‘green’ OR Trousers LIKE ‘purple’ Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 16 Thursday, March 4, 2021 Database Creation eate r c o t uery q s i e! h l t b a t Use o erher p u s r you Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 17 Thursday, March 4, 2021 Data Creation rhero e p u s the T ase b R a E t S a d IN your o t n i data Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 18 Thursday, March 4, 2021 Data Creation rhero e p u s se the a R b C a t E L a SE ur d o y m o data fr How c this ould you mor e co make mple x? Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
Learning Objectives • • • Define different types of database Describe the organisation and structure of a database Use queries to select, create, update, and delete data in a table Slide 19 Thursday, March 4, 2021 Homework Download and complete the Databases revision placemat. Remember your notes should use: Well presented full sentences with Point, Explain, Example Key Vocabulary Variables, Repeat Statements, While Loop, Success Criteria © Teach. All. About. IT 2018
- Slides: 19