Year 8 - Term 2A Home Learning

Multiple Choice

Which of the following best describes the main purpose of a database?

• To store and organize data efficiently

• To create graphics and images

• To browse the internet

• To write and edit documents

Multiple Choice

Which of the following is NOT a reason why we organize information, according to the slide?

• To keep record of things

• So we can look through it when needed

• To make information harder to find

• To find something easily

Fill in the Blank

A table in a database consists of records, fields, and a ___.

Open Ended

Explain the difference between a record and a field in the context of a database table.

Fill in the Blank

A ___ key is used to give each record a unique code in a database table.

Multiple Choice

What is the main purpose of a primary key in a database table?

• To store data

• To give each record a unique identifier

• To organize data into columns

• To allow multiple records with the same code

Multiple Choice

Which of the following best describes a computerised database?

• Stores data on physical paper

• Requires manual updates

• Stores data digitally for easy access and searching

• Is more prone to errors

Open Ended

Write one advantage and one disadvantage of a computerised database.

Multiple Select

Which of the following are characteristics of a flat file database?

• Stores all data in a single table

• Organizes data into multiple linked tables

• Is more prone to errors

• Allows complex data management

Open Ended

What is a database?

Multiple Choice

Which of the following best describes a primary key in a database?

• A field that stores text data

• A unique identifier for each record

• A type of data that can be stored

• A field that stores dates

Multiple Choice

What are some examples of data types that can be used in a database?

• Number, Text, Autonumber, Date/time

• Image, Sound, Video, Animation

• Book, Article, Journal, Magazine

• Circle, Square, Triangle, Rectangle

Open Ended

Explain why it is important for each field in a database to have a specific datatype.

Multiple Select

Which of the following are valid data types for storing information in a database?

• Text

• Number

• Date/Time

• Autonumber

Fill in the Blank

A phone number should be stored as ___ in a database to allow for country codes and symbols. (Hint: Your answer must be an example of a data type)

Fill in the Blank

A primary key should never be a ___ that could be shared by many people.

Multiple Select

Which of the following are characteristics of a primary key?

• Usually consists of numbers

• Can be repeated across records

• Used to access specific records in a database

• Includes the word 'ID' after the name

Multiple Choice

What is a primary key in a database, and why is it important for identifying records?

• A primary key is a unique identifier for each record, ensuring each record can be recognized and referenced.

• A primary key is a type of data that stores names and addresses.

• A primary key is a password used to access the database.

• A primary key is a shared value among multiple records.

Open Ended

Explain how primary keys help prevent confusion and enable faster searches in a database.

Open Ended

Describe the steps you would take to create a primary key for a table containing product information.

Open Ended

Summarize the main differences between a flat file and a relational database, and explain why understanding these differences is important.

Open Ended

What is a Database?

Open Ended

You have a list of students in your class. Each student has a unique ID number. What would the name of the primary key field be to identify each student?