Computer Science - ICT Grade 7 Databases Tables Rows Columns Queries

Grade 7 Computer Science (ICT) Study Guide: Databases – Tables, Rows, Columns, Queries

1. The Driving Question

"If you’ve ever tried to organize a huge list—like all the Pokémon cards your friends own, or every video game character with their stats—how do you find just the ones you want without scrolling forever? And why does a spreadsheet feel clunky when you try to answer questions like ‘Which cards are rare and worth more than $10?’ What’s the smarter way to store and search this kind of info?"

2. The Core Idea – Built, Not Listed

Imagine you’re running a school library with 5,000 books. If you scribbled all the titles, authors, and genres on sticky notes, finding "all fantasy books by female authors published after 2010" would take hours. Instead, you’d organize the books into a database table—like a giant, digital spreadsheet where: - Each row is one book (e.g., Harry Potter and the Sorcerer’s Stone).
- Each column is a category (title, author, genre, year, shelf location).
- A query is like asking the librarian: "Show me only the rows where genre = ‘fantasy’ AND author = ‘J.K. Rowling’."

This structure lets you filter, sort, and search instantly—no sticky notes required.

Key Vocabulary:
1. Table
- Definition: A structured collection of data organized into rows and columns, like a digital filing cabinet.
- Example: A table of soccer players with columns for name, team, position, and goals scored this season.
- Note: In high school, you’ll learn tables can link to other tables (e.g., a "Teams" table and a "Players" table), which is how apps like Instagram store data.

1. Row (Record)
2. Definition: A single entry in a table, representing one "thing" (e.g., one book, one player).

3. Example: In a YouTube channels table, one row might be: "MrBeast, 200M subscribers, 2012, ‘Philanthropy’."

4. Column (Field)

5. Definition: A category of information that every row shares (e.g., "author," "price," "release date").

6. Example: In a pizza orders table, columns could be: customer name, toppings, size, delivery time.

7. Query

8. Definition: A question you ask the database to filter or sort data (e.g., "Show me all orders over $20").
9. Example: A Spotify playlist query: "Songs where artist = ‘Taylor Swift’ AND release year > 2020."
10. Note: In high school, queries get more powerful with SQL (a coding language for databases), where you’ll write commands like SELECT * FROM songs WHERE genre = 'pop';.

3. Assessment Translation

How This Appears on Tests:
- Multiple Choice: "Which of these is a column in a ‘Students’ table?" (Options: A) "Row 5" B) "Birthday" C) "The entire class" D) "A query") - Distractor Pattern: Confusing rows/columns (e.g., "Row 5" vs. "Birthday") or mixing up tables/queries.
- Short Answer: "Explain why a database table is better than a spreadsheet for tracking 1,000 customer orders." - Proficient Response: "A database table lets you run queries to find specific orders (e.g., ‘all orders over $50’) instantly, while a spreadsheet would require manual scrolling or filtering. Databases also prevent duplicate data (like the same customer listed twice)." - Developing Response: "Databases are faster." (Lacks explanation of why or examples.) - Performance Task: "Create a table for a ‘Video Games’ database with 5 columns and 3 rows. Then write a query to find all games rated ‘E for Everyone.’" - What Teachers Look For:
- Columns are categories (not random data).
- Rows are complete (no missing info).
- Query matches the question (e.g., WHERE rating = 'E').

Model Proficient Response (Short Answer):
"A database table is like a super-organized spreadsheet. For example, if you have a table of ‘Movies’ with columns for title, director, and rating, you can run a query to find all PG-13 movies directed by Christopher Nolan. A spreadsheet could do this too, but it’d be slower, and you might accidentally change data. Databases also let you link tables—like connecting a ‘Directors’ table to the ‘Movies’ table—so you don’t repeat info (e.g., listing Nolan’s birthdate for every movie he made)."

4. Mistake Taxonomy

Mistake 1: Confusing Rows and Columns
- Question: "In a ‘Pets’ table, which is a column: ‘Fluffy the cat’ or ‘Breed’?" - Common Wrong Answer: "‘Fluffy the cat’" (choosing a row’s data instead of a category).
- Why It Loses Credit: The question asks for a category (column), not a specific pet (row).
- Correct Approach: - Columns = categories (e.g., "Breed," "Age," "Owner").
- Rows = individual entries (e.g., "Fluffy, Persian, 3, Sarah").

Mistake 2: Writing a Query That Doesn’t Match the Question
- Question: "Write a query to find all books in the ‘Mystery’ genre published after 2015." - Common Wrong Answer: WHERE genre = 'Mystery' OR year > 2015 (uses OR instead of AND).
- Why It Loses Credit: The query returns either mystery books or books after 2015, not both conditions together.
- Correct Approach: - Use AND to combine conditions: WHERE genre = 'Mystery' AND year > 2015.

Mistake 3: Overcomplicating a Simple Query
- Question: "List all students in the ‘7th Grade’." - Common Wrong Answer: SELECT * FROM students WHERE grade = '7th' AND homeroom != 'NULL' AND age > 10 (adds unnecessary conditions).
- Why It Loses Credit: The question only asks for grade, but the student over-filters.
- Correct Approach: - Keep it simple: WHERE grade = '7th'.

5. Connection Layer

1. Within Computer Science: Databases → Algorithms

2. Queries use search algorithms (like binary search) to find data fast—understanding tables helps you see why sorting data (e.g., alphabetizing names) makes queries faster.

3. Across Subjects: Databases → Math (Statistics)

4. A database table is like a data set in math. Running a query (e.g., "average test scores by class") is the same as calculating a mean—but databases do it automatically.

5. Outside School: Databases → Social Media

6. When you search "friends who like basketball" on Instagram, you’re running a query on a massive database. The app’s "Explore" page uses queries to show you posts based on your likes—just like filtering a table!

6. The Stretch Question

"If a database table is like a spreadsheet, why do big companies (like Amazon or Netflix) use databases instead? Couldn’t they just use Excel?"

Pointer Toward the Answer:
Databases handle millions of entries without crashing, while spreadsheets slow down or freeze. They also let multiple people edit data at once (e.g., 100 Amazon employees updating product info simultaneously) without overwriting each other. Plus, databases use specialized languages (like SQL) to run complex queries instantly—like finding "all customers who bought a phone in 2023 and also bought a case within 30 days." Try doing that in Excel!

(But here’s the twist: Some small businesses do use spreadsheets as simple databases—so the real answer depends on scale and needs!)