Year 8 Databases

Introduction to Databases

Year 8: Computer Science

With Mr Z Khan

​What is the difference between the two images?

​What is the difference between the two images?

​Data: Raw facts without context.

​Information: Data with context to provide meaning.

Objectives

• Understand what databases are and how they are used.

• Identify the advantages and disadvantages of using computers to store information.

• Apply knowledge to real-life scenarios.

What is a database?

•A database contains one or more tables

•A table has rows, each row containing one record

•Columns in the table each contain one field belonging to the records

Word Cloud

Word Cloud:
Can you think of one place where a database can be used to store a large amount of data? Discuss with the person next to you. Your answer can be two words maximum.

Multiple Choice

Which of the following is an advantage of using computers to store information?

• High cost of setup

• Quickly retrieve and sort large amounts of data

• Vulnerability to hacking

Multiple Choice

How does storing information on computers improve accuracy?

• By increasing the setup cost

• By making data more complex to manage

• By lowering the risk of human error compared to manual data entry

• By reducing the need for software updates

Multiple Choice

Which of the following is a disadvantage of using computers to store information?

• Accessibility from multiple locations

• Enhanced efficiency in data retrieval

• Vulnerability to hacking and data breaches

• Improved accuracy in data entry

Computerised databases

• Initial cost of hardware can be expensive and running costs

• Cyberattacks

• Technical failure

• Require backups incase of data loss.

Disadvantages

• Doesn't take real world space.

• Much quicker to search/query.

• Easy to add/amend data.

• Can have added security.

Advantages

Task 1 and 2 (5-6 minutes)

Open Google Classroom and find the task for this lesson called Y8 Databases Lesson 1.


Your task is to open the database in the link and answer the questions on the document.

Plenary - 5 Questions

We will have 5 quickfire questions, all worth 1 point each.

Multiple Choice

• What is a database?

• • A type of software used to browse the internet.

• A device used to store backup copies of documents.

• A collection of data organised in a way that allows for easy access, management, and updating.

• A program that performs calculations and displays graphs.

Multiple Choice

As a manager at a retail company, how would you use a database to improve inventory management?

• By using it to track and update stock levels in real-time.

• By using it to create advertisements for new products.

• By using it to design the layout of the store.

• By using it to train new employees on customer service skills.

Multiple Choice

Which of the following is a potential disadvantage of storing information on computers?

• It is always slower than paper-based methods.

• Computers can sometimes lose data due to technical failures.

• Information on computers is less organised.

• Computers are more expensive to maintain than filing cabinets.

Multiple Choice

What is one major advantage of using computers to store information?

• Information stored on computers can never be lost.

• Computers never need maintenance or updates.

• Computers can store large amounts of information in a small space.

• Information on computers is always 100% secure.

Multiple Choice

Which of the following is NOT a common use of databases?

• Managing customer information in a business.

• Tracking inventory in a store.

• Recording students' grades in a school.

• Editing photos for a magazine

Poll

I confidently know what a database is, where databases are used and know the advantages and disadvantages of computer based databases. (No points for this question!)

• Strongly Agree

• Agree

• Disagree

• Strongly Disagree