Font size
WorksheetsStudy Notes: Database for Primary 5
Total questions: 100
Worksheet time: 2hrs 38mins
A database is:
A collection of data organized in a structured way
A type of software for browsing the internet
A programming language
A hardware device for storing data
Which of the following is an example of a database?
A) A school database
B) A library database
C) Both A and B
D) None of the above
Fill in the blank: A database helps us keep records of important data in a _______ way.
structured
random
chaotic
disorganized
We use databases because:
They store data efficiently and securely.
They are used for cooking.
They are a type of sport.
They are a form of art.
Which type of database is faster and more reliable?
Manual Database
Computerized Database
What is a collection of related data in a database called?
Record
Field
Table
Fill in the blank: Each row in a database table is called a _______.
Record
Column
Field
Cell
What type of data includes words, names, and addresses in a database?
Numbers
Text
Boolean
A teacher might use a database to find students scoring above 90% by:
Sorting the database by scores and selecting students with scores above 90%.
Manually checking each student's score.
Asking students to report their scores.
Using a random selection of students.
Fill in the blank: A column in a database table is called a _______.
Field
Row
Sheet
Record
What is a School Database used for?
Storing patient medical records
Keeping track of books borrowed and returned
Storing students' names, grades, and attendance
Storing customer orders and payments
A Library Database is used to _______.
Keep track of books borrowed and returned
Store digital copies of books
Manage library staff schedules
Organize community events
What type of database stores patient medical records?
School Database
Library Database
Hospital Database
Online Shopping Database
Which database is used for storing customer orders and payments?
School Database
Library Database
Hospital Database
Online Shopping Database
What is Microsoft Access used for?
Creating databases
Storing simple databases in tables
Large databases like websites
Fill in the blank: Google Sheets/Excel is used to store _______.
simple databases in tables
complex algorithms
video files
audio tracks
What is MySQL used for?
Creating databases
Storing simple databases in tables
Large databases like websites
Ways to protect data in a database include:
Encryption and access controls
Regular backups and audits
Data masking and tokenization
All of the above
Fill in the blank: Only allow _______ to access sensitive data.
trusted people
everyone
unauthorized users
hackers
The two types of databases mentioned in the summary are:
Relational and Non-relational
SQL and NoSQL
Hierarchical and Network
Distributed and Centralized
In the School Database Example, what is the average score of Alice Tan?
The question has a diagram associated with it. The diagram has been stored separately.
85
90
95
In the Library Database Example, who borrowed 'The Lion, the Witch and the Wardrobe'?
The Lion, the Witch and the Wardrobe was borrowed by a specific individual in the Library Database Example.
Alice
Bob
Charlie
In the Hospital Database Example, what is the age of the patient with ID 203?
Which database tracks student information, grades, and attendance?
True or False: In the Library Database Example, 'Harry Potter and the Sorcerer's Stone' was borrowed by Alice Tan.
True
False
The purpose of the Hospital Database as mentioned in the example is:
To store patient records
To manage hospital staff
To track hospital inventory
To schedule appointments
What is the blood type of Tom Benson?
Who is the doctor assigned to Emily Tan?
Fill in the blank: Kevin Lim's diagnosis is ________.
What is the next appointment date for Lucy Chan?
What product did John Smith order?
Fill in the blank: The payment status for David Lee's order is ________.
Paid
Pending
Cancelled
Refunded
What is the delivery status of Alice Tan's order?
The online shopping database is used to:
store customer information and purchase history
manage inventory and product listings
process payments and handle transactions
all of the above
What is the main use of a School Database?
Manages students’ grades and attendance.
Tracks books borrowed and returned.
Stores patient medical records and appointments.
Manages customer orders and payments.
Fill in the blank: A Library Database tracks ________.
books borrowed and returned.
library staff schedules.
cafe menu items.
gym equipment usage.
What is the price of the Office Chair in the product inventory table?
$50
$75
$100
$125
How does Microsoft Access help in inventory management?
Helps track inventory levels and avoid stock shortages.
Allows quick search of products by name, category, or supplier.
Generates sales reports for better decision-making.
All of the above.
Fill in the blank: The product ID for the Coffee Machine is ________.
P004.
P001.
P002.
P003.
What is the attendance percentage of John Smith?
How many days was Alice Tan absent?
0
1
2
3
Which grade is David Lee in?
Grade 5
Grade 6
Grade 7
Grade 8
What is the total number of days Sarah Wong was present?
10 days
15 days
20 days
25 days
What is the order ID for the customer who ordered a Smartwatch?
12345
67890
54321
98765
How many Bluetooth Speakers did Sarah Wong order?
0
1
2
3
What is the payment status of David Lee's order?
Paid
Pending
Cancelled
Refunded
MySQL is used in handling customer orders by:
Storing customer data and order details in a structured format
Providing a graphical interface for order processing
Sending automated emails to customers
Managing customer service interactions
Which database software is best for small to medium data management?
Microsoft Access
Google Sheets/Excel
MySQL
Fill in the blank: Google Sheets/Excel is used for ________ and small-scale tracking.
simple
complex
advanced
detailed
What type of data is used for names, addresses, and descriptions?
A) Text (String) Data
B) Number (Numeric) Data
Fill in the blank: MySQL is best for high-speed, large-scale data ________.
processing
storage
analysis
visualization
Which type of data stores whole numbers or decimal numbers?
A) Text (String) Data
B) Number (Numeric) Data
What type of data stores dates and times?
What is an example of Date/Time Data?
2023-10-05
Red
Circle
Banana
What type of data stores True/False or Yes/No values?
What is an example of Boolean (Logical) Data?
An example of Boolean (Logical) Data is a variable that can hold one of two values: true or false.
An example of Boolean (Logical) Data is a variable that can hold any integer value.
An example of Boolean (Logical) Data is a variable that can hold a string of text.
An example of Boolean (Logical) Data is a variable that can hold a floating-point number.
What type of data stores pictures, videos, audio files, and scanned documents?
What is an example of Image/Multimedia Data?
An example of Image/Multimedia Data is a photograph, a video file, or an audio recording.
A text document.
A spreadsheet file.
A database entry.
What is an example of Hyperlink (URL) Data?
A) "https://www.google.com"
B) "John Doe"
C) 10
D) True
What is JSON Data used for?
Storing website links
Storing structured data in JSON format
Storing location-based coordinates
Storing words
Fill in the blank: XML Data is used in ________ between systems.
data exchange
data storage
data analysis
data visualization
What is an example of Geolocation Data?
mailto:info@example.com
Latitude: 40.7128, Longitude: -74.0060
01/01/2024
Hello
What type of data stores words and characters?
Number
Text (String)
Date/Time
Boolean
Fill in the blank: Number (Numeric) data stores whole & ________ numbers.
decimal
integer
fractional
negative
What is an example of Date/Time data?
A) "John Doe"
B) 500
C) "12:30 PM"
D) True
What type of data stores True/False or Yes/No values?
Text (String)
Number
Date/Time
Boolean
What type of data does 'Image/Multimedia' store?
Fill in the blank: Currency stores ______ values.
monetary
integer
string
boolean
Which data type stores unique, auto-generated numbers?
Fill in the blank: Percentage stores ______ values.
fractional
whole
negative
complex
What type of data does 'Hyperlink (URL)' store?
Fill in the blank: JSON stores ______ data.
structured
unstructured
random
encrypted
Which data type is used for storing markup-based data?
Fill in the blank: Geolocation stores ______ values.
latitude and longitude
temperature
altitude
speed
What is an Exact Match Search?
A search technique that matches the exact words or phrases in the query.
A search method that uses synonyms to find results.
A search strategy that ignores common words like 'the' and 'is'.
A search approach that ranks results based on popularity.
A Partial Match (Wildcard) Search is:
a search technique that uses wildcards to replace one or more characters in a search term
a method to find exact matches only
a search that ignores case sensitivity
a technique to search within a specific website
A Range Search is a query that retrieves all records where the values fall within a specified range.
A query that retrieves all records where the values fall within a specified range.
A search for a specific value in a database.
A method to sort data in ascending order.
A technique to compress data.
What is a Boolean Search (AND, OR, NOT)?
A method of searching using logical operators
A type of search engine
A programming language
A database management system
A Fuzzy Search (Approximate Match) is:
a search technique that finds exact matches only
a search technique that finds matches even if they are not exact
a search technique that only works with numbers
a search technique that requires special characters
What type of search finds records based on numerical values?
Give an example of a Date Search query.
Example: 01/01/2020
Example: 2020-01-01
Example: January 1, 2020
All of the above
What is the use case for Pattern Search using regular expressions?
To find specific patterns within text
To perform arithmetic operations
To sort data
To encrypt data
Which search type is used within categories or levels of a database?
What is an example query for an Exact Match search?
"Find the nearest coffee shop"
"What is the capital of France?"
"Exact Match: 'Best pizza in New York'"
"How to bake a cake?"
What is a Partial Match search used for?
Finding records using wildcards
Finding records within a range of values
Combining multiple conditions.
Fill in the blank: A Range Search finds records within a ________ of values.
range
list
set
group
What does a Boolean Search combine?
Wildcards
Multiple conditions (AND, OR, NOT)
Approximate matches.
Fill in the blank: A Fuzzy Search finds ________ matches.
approximate
exact
random
irrelevant
What type of search finds records using numbers?
Numeric Search
Date Search
Pattern Search
Fill in the blank: A Date Search finds records using ________.
dates
names
locations
keywords
What does a Pattern Search find?
Records using numbers
Records matching a text pattern
Records within categories.
Fill in the blank: A Hierarchical Search searches within ________.
categories
levels
layers
sections
What is the purpose of a Hierarchical Search?
Finding records using wildcards
Searching within categories
Finding approximate matches.
What is a Single-Form (Basic Data Entry Form) best used for?
Managing inventory, orders, or attendance records.
Adding new customers, employees, or students.
Viewing and editing large amounts of data at once.
What is the main feature of a Multiple-Items Form (Continuous Form)?
Displays one record at a time.
Displays multiple records in a list format.
Divides the screen into two sections.
The structure of a Split Form is described as:
A single form that displays data in two views simultaneously.
A form that is divided into multiple sections for different data types.
A form that only displays data in a tabular format.
A form that is used exclusively for data entry without viewing.
A Datasheet Form (Table-Like View) is similar to:
a spreadsheet
a text document
a presentation slide
a drawing canvas
A Navigation Form in Access is used for:
Creating tables
Designing queries
Building forms
Navigating between different forms and reports
Which form type in Access is best for creating a user-friendly interface for large databases?
What is a Modal Dialog Form used for in Access?
To display information without user interaction
To allow user input and interaction
To create a new database
To delete records permanently
