Benefits of storing data in a database for organisations and governments
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. A council moves its paper rates records into a database. Which benefit is this MOST likely to give?
2. Which statement best describes how a database reduces errors?
3. A state government wants to decide where to build new schools. How does a database help?
4. Which is a cost-saving benefit of moving from paper forms to a database?
5. A hospital database is shared by the emergency ward and the pharmacy. What is the benefit?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 1SELECT * FROM students WHERE house = 'Red'; | ASELECT yearLevel, COUNT(*) FROM students GROUP BY yearLevel; | |
| 2UPDATE students SET points = 130 WHERE studentId = 1; | BSearches a database and returns only the matching records in seconds, giving faster service than flicking through paper files | |
| 3A government agency can inform policy by quickly summarising large amounts of stored data, such as counting students in each year level | CSeparate copies often become out of date and inconsistent. A shared database stores the data once, which reduces errors. | |
| 4An organisation saves costs and staff time by linking tables so data is stored once and joined when needed, instead of being retyped | DChanges a record once in one place so everyone sees the same correct data, reducing errors and duplicate paperwork | |
| 5A school keeps every student record in paper folders and says this is faster than a database search | ESELECT s.firstName, r.mark FROM students s JOIN results r ON s.studentId = r.studentId; | |
| 6Each department keeps its own copy of a citizen's address, so the data is more accurate | FPaper records must be searched by hand, which is slow, takes up space and is easy to misfile. A database can find a record in seconds. |
C
Definitions
database
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
SELECT * FROM students
_____ house = 'Red';
2.
SELECT _____(*) FROM orders;
3.
______ students SET points = 130
WHERE studentId = 1;
4.
SELECT ___(mark) FROM results;
5.
CREATE TABLE students (
studentId INTEGER ___________,
lastName TEXT NOT NULL);
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
SELECT firstName, house,
B
FROM students
C
WHERE studentId = 3;
Question 2
A
SELECT house,
B
COUNT(*) AS total
C
FROM students
D
GROUP house;
Question 3
A
SELECT name, stock
B
FROM products
C
WHERE stock == 0;
Question 4
A
SELECT AVG(mark)
B
FORM results
C
WHERE subjectId = 1;
Question 5
A
MAKE TABLE pupil (
B
id INTEGER PRIMARY KEY,
C
name TEXT NOT NULL
D
);
Answer Key
Benefits of storing data in a database for organisations and governments
Section A: Quick Questions
Q1
A — Staff can search for a property's record in seconds, so residents get faster service
Q2
A — Data is entered once and validated, so the same detail is not retyped or copied wrongly
Q3
B — It lets analysts quickly pull accurate enrolment data by suburb to inform policy
Q4
B — Less spending on printing, storage space and staff time spent re-entering data
Q5
A — Both teams see the same up-to-date patient record at the same time
Section B: Match the Pairs
Q1
SELECT * FROM students WHERE house = 'Red'; → Searches a database and returns only the matching records in seconds, giving faster service than flicking through paper files
Q2
UPDATE students SET points = 130 WHERE studentId = 1; → Changes a record once in one place so everyone sees the same correct data, reducing errors and duplicate paperwork
Q3
A government agency can inform policy by quickly summarising large amounts of stored data, such as counting students in each year level → SELECT yearLevel, COUNT(*) FROM students GROUP BY yearLevel;
Q4
An organisation saves costs and staff time by linking tables so data is stored once and joined when needed, instead of being retyped → SELECT s.firstName, r.mark FROM students s JOIN results r ON s.studentId = r.studentId;
Q5
A school keeps every student record in paper folders and says this is faster than a database search → Paper records must be searched by hand, which is slow, takes up space and is easy to misfile. A database can find a record in seconds.
Q6
Each department keeps its own copy of a citizen's address, so the data is more accurate → Separate copies often become out of date and inconsistent. A shared database stores the data once, which reduces errors.
Section C: Definitions
Q1
database — An organised store of data that organisations and governments can quickly search, share and update to give faster services, cut paper and errors, and inform decisions.Section D: Fill in the Blanks
Q1
SELECT * FROM students
WHERE house = 'Red';Q2
SELECT COUNT(*) FROM orders;Q3
UPDATE students SET points = 130
WHERE studentId = 1;Q4
SELECT AVG(mark) FROM results;Q5
CREATE TABLE students (
studentId INTEGER PRIMARY KEY,
lastName TEXT NOT NULL);Section E: Spot the Error
Q1
A — A database finds one student's record in a single query, which gives faster service than searching paper files. The extra comma after house is wrong because no column follows it. It should be SELECT firstName, house.
Q2
D — Counting students per house gives a school the evidence to inform decisions. The grouping clause must be written GROUP BY house, and the BY keyword is missing.
Q3
C — A database can list out-of-stock items instantly, so an organisation can reorder and save money. SQL compares values with a single equals sign, so it should be WHERE stock = 0;.
Q4
B — Calculating an average mark from stored data quickly helps a school or government inform policy. The keyword is misspelt. It should be FROM results.
Q5
A — A table with a primary key and NOT NULL rules reduces duplicate and missing data, so there are fewer errors than on paper forms. The SQL command to build a table is CREATE TABLE, not MAKE TABLE.