Representing Text and Images

Students often struggle to visualize how data connects across tables, so active learning breaks the abstraction into tangible steps. Working through ERD challenges and normalization exercises lets them see why relationships matter, making the shift from flat files to structured databases feel purposeful rather than abstract.

• JC 1
• Computing
• 3 activities
• 20 min–50 min

Learning Objectives

1. Compare the storage efficiency and scalability of bitmap images versus vector graphics.
2. Analyze the trade-offs between file size and visual fidelity for common image formats like JPEG, PNG, and GIF.
3. Explain how different character encoding schemes, such as ASCII and Unicode, facilitate or hinder global digital communication.
4. Design a simple bitmap representation for a given icon using a specified pixel grid and color palette.

Inquiry Circle

⏱ 50 min·Small Groups

Inquiry Circle: ERD Design Challenge

Groups are given a scenario, like a 'Grab-style' ride-hailing app. They must identify the entities (Drivers, Riders, Trips) and their attributes, then use large sheets of paper to draw the relationships and cardinalities between them.

Prepare & details

Explain how different character encoding schemes impact global communication.

Facilitation Tip: During the ERD Design Challenge, circulate and ask groups to explain their entity choices aloud before sketching relationships, reinforcing the habit of verbalizing design decisions.

Setup: Groups at tables with access to source materials

Materials: Source material collection, Inquiry cycle worksheet, Question generation protocol, Findings presentation template

• Analyze
• Evaluate
• Create
• Self-Management
• Self-Awareness

Stations Rotation

⏱ 45 min·Small Groups

Stations Rotation: The Normalization Hospital

Set up stations with 'sick' (un-normalized) tables full of redundant data and update anomalies. Students must 'cure' the tables by breaking them down into 1NF, 2NF, and 3NF, explaining their reasoning at each step.

Prepare & details

Compare vector graphics and bitmap graphics in terms of storage and scalability.

Facilitation Tip: For The Normalization Hospital, assign roles so one student updates the flat table while another updates the normalized one simultaneously, making the contrast visible.

Setup: Tables/desks arranged in 4-6 distinct stations around room

Materials: Station instruction cards, Different materials per station, Rotation timer

• Remember
• Understand
• Apply
• Analyze
• Self-Management
• Relationship Skills

Think-Pair-Share

⏱ 20 min·Pairs

Think-Pair-Share: Real-World Relationships

Students think of a many-to-many relationship in their school life (e.g., Students and Subjects). They pair up to discuss why a 'junction table' is necessary to model this in a relational database and what data that table should hold.

Prepare & details

Analyze the trade-offs between file size and image quality for different image formats.

Facilitation Tip: Use Think-Pair-Share to have students debate real-world relationships first, then refine their ERD drafts with peer feedback before finalizing.

Setup: Standard classroom seating; students turn to a neighbor

Materials: Discussion prompt (projected or printed), Optional: recording sheet for pairs

• Understand
• Apply
• Analyze
• Self-Awareness
• Relationship Skills

Teaching This Topic

Teach ERDs by grounding them in familiar systems students have encountered, like school databases or social media apps. Avoid overwhelming them with jargon, and instead focus on modeling one relationship at a time. Research shows that students grasp normalization better when they experience the pain of redundancy firsthand, so simulations work more effectively than lectures for this topic.

What to Expect

Successful learning looks like students designing accurate ERDs with clear relationships, normalizing tables to eliminate redundancy, and explaining their choices with confidence. They should articulate why primary keys must be unique and how normalization prevents update errors in real systems.

Watch Out for These Misconceptions

Common Misconception

During the ERD Design Challenge, watch for students who try to combine all data into one large table for simplicity.

What to Teach Instead

Guide them to split data into separate entities and define relationships explicitly, using the activity's requirement to model a real-world system like a school or store.

Common Misconception

During the Think-Pair-Share activity, watch for students who select names as primary keys in their ERDs.

What to Teach Instead

Have peers review their drafts and challenge them to explain why names are unreliable keys, then prompt them to substitute a unique ID like a student ID or product code.

Assessment Ideas

Quick Check

After the ERD Design Challenge, collect one ERD from each group and assess whether they have correctly identified entities, relationships, and primary keys with clear labels.

Peer Assessment

During The Normalization Hospital, have students swap normalized and flat tables to check each other’s work for missing updates or redundant entries.

Discussion Prompt

After Think-Pair-Share, facilitate a class discussion where students justify their ERD choices and identify where their initial assumptions about relationships were challenged.

Extensions & Scaffolding

• Challenge advanced groups to design an ERD for a library system with constraints like limited checkouts per patron or genre-based categorization.
• Scaffolding for struggling students: Provide a partially completed ERD template with labeled entities and ask them to fill in relationships and primary keys.
• Deeper exploration: Introduce composite keys and have students research when and why they are used in real-world systems like order tracking in e-commerce.

Key Vocabulary

Bitmap Image	An image file format that stores graphical information as a grid of pixels, where each pixel has a specific color value.
Pixel	The smallest controllable element of a picture represented on the screen, a single point in a graphic image.
ASCII	An early character encoding standard that uses 7 or 8 bits to represent English letters, numbers, and symbols, limiting its character set.
Unicode	A character encoding standard designed to represent text from all writing systems, using variable-length encoding to accommodate a vast range of characters.
Color Depth	The number of bits used to represent the color of a single pixel, determining the total number of colors that can be displayed.