Introducing
Your new presentation assistant.
Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.
Trending searches
Lesson 8 - Databases
Plus....
The more traditional things like booking an appointment with the doctor, school registers, government records, police records......
Lots of things!
✳✱*
Records
Each time we add data to the database we create a record
Databases
A record is all of the information about a person or thing
Made up of several 'fields'
A field is a single piece of information such as a name, a test score, a registration number etc.....
TASK
Shared:\Computing - ICT\KS4 - Computer Science GCSE (9-1)\Paper 2\Lesson 8
On SIMS that would be everything we hold about you, in a car sales database that would be all of the details about one car
Database
Task
Demo
Now create flashcards explaining:
- What SQL stands for
- SELECT, *, FROM, WHERE key words and their uses
- Definition of a field
- Definition of a file
- Definition of a database
A database is a structured set of data held in a way that makes it easy for people to access it.
What are databases mostly used for?
Lesson Objectives
To understand the terms database, field and record
To know what SQL is
To apply knowledge in created SQL queries on a database
Revise, Recap, Review
3 flow chart symbols and their meaning
2 sorting algorithms
1 definition of the programming term 'variable'
Lesson 8 - Databases
Databases
What is a database?
SQL queries
WHERE makes our queries more powerful - only return values based upon certain conditions i.e. only return BMW cars
SQL is a language but it is easy to understand
We don't have to select it all!
SELECT is a key term that asks the database to return something
Instead of SELECT * we can just type the name of the fields want to see i.e.
SELECT Make, Model FROM
cars
WHERE Make = 'BMW'
Queries
* Means all
FROM table_name gives the instruction of where to get the data from
Redundant data is duplicated data.
If we had just one table for a booking system at the doctors imagine how many times we would need to store a patient name, DOB, gender, health?
Although many different database platforms exist, one of the most commonly used databases in industry is SQL - Structured Query Language
Relational databases
SQL is a relational database
This means that data isn't stored in just one table, but split over many tables - each entity will have a table of it's own to remove redundant data
There are currently over 4000 job advertisements on indeed for SQL jobs with 60k+ salaries!
Rather than looking at 450,000 cars, I need to ask the database some questions