Skip to content
PlayOwl

Computers & Digital Literacy · Grade 10

Databases and Information Organization

Learners follow primary and foreign keys across related tables, model many-to-many relationships with junction tables, and see how storing the same fact in many places causes update, insertion and deletion anomalies that normalization prevents. They read SQL-like queries with SELECT, WHERE and ORDER BY and predict their results, then compare metadata, folders and tags as ways to organize and find information.

  • 4 lessons
  • About 110 minutes
  • Databases and organization check: 10 questions
  • Ways to answer: fill in the blanks, choose an answer, put code in order, trace code, match pairs and type a number
Try it now (no account) One of the five free starter courses Open in PlayOwl

What learners will discover

  • Use primary and foreign keys to follow one-to-many relationships between tables, and model many-to-many relationships with a junction table.
  • Explain how redundancy causes update, insertion and deletion anomalies, and normalize a table in plain terms by splitting it so each fact is stored once.
  • Predict the rows and order returned by SQL-like queries that use SELECT, FROM, WHERE and ORDER BY.
  • Use metadata to describe and find information, and choose between folders and tags for organizing a collection.

Lessons

  1. Keys and relationships 9 steps5 practiceabout 28 min
  2. Redundancy, anomalies and normalization 7 steps5 practiceabout 27 min
  3. Reading queries 7 steps5 practiceabout 28 min
  4. Metadata, folders and tags 8 steps5 practiceabout 27 min
  5. Databases and organization check 10 questions at the end

Keep exploring

More 10th grade computer skills

Guide for grown-ups