WorksheetsY8 Database Homework1 Quiz
Total questions: 20
Worksheet time: 33mins
What is a Database?
What is the purpose of a database?
What is the difference between a flat file and a relational database?
Why do humans collect and organize information?
What are some reasons mentioned for keeping a record of things?
How does YouTube use databases to help users find videos?
Which of the following is a characteristic of a database?
Stores information
Random papers in a drawer
A book
Scattered photos
Which of the following is NOT an example of a database?
Netflix movie library
Spotify music collection
School records
Random papers in a drawer
What kind of information do organizations like Instagram, Spotify, and Wickford Library need to store?
Fill in the blank: A (a) is one complete set of information in a table (like one student’s details).
Fill in the blank: A (a) is the single piece of information in a record (categories like a student’s name or age).
Fill in the blank: A (a) is a unique identifier for each record (like a student’s ID number) it needs to be unique to recognise that record.
What is the purpose of a primary key in a database table?
Fill in the blank: A primary key is used to give each record a (a) code. It's unique and can never be repeated.
Match the key term to the letters in the diagram.
Table
A
Fields
B
Record
C
What is a computerized database?
A database that stores data on physical paper.
A database that stores data digitally on a computer.
A database that requires manual updates.
A database that is harder to search or manage.
A paper-based database stores data on (a) .
What is a flat file database?
A) A database that stores data in multiple tables
B) A database that stores all data in a single table with rows and columns
C) A database that is complex and handles large amounts of data efficiently
D) A database that is not prone to errors
Fill in the blank: A relational database organizes data into multiple linked tables, allowing complex data management and efficient relationships between different types of information. This makes it easier to search for information, and it ensures only the relevant information is in each (a) .
Why might a flat file become difficult to manage as it grows?
