Use a Primary Key to Identify a Row
Check uniqueness of the declared key rather than every field in a row.
About 22 minutes, plus any extended practice
Open lesson 1Design Consistent Relational Records
Design parentsA,B and children with required parent IDs. Evaluate a child pointing to C, an incomplete 3-token transfer and a query with a user-supplied value.
Before you begin
- Distinguish IDs from display names and read a schema.
Choose by skill rather than age alone. Read with an adult when useful, revisit a lesson, or explore another grade.
Follow the lesson sequence
Maintain an Enforced Parent Reference
Verify the referenced parent exists under the stated enforced rule.
About 22 minutes, plus any extended practice
Open lesson 2Treat an All-or-Nothing Change as a Transaction
Commit the complete valid change or roll back the incomplete change.
About 22 minutes, plus any extended practice
Open lesson 3Keep Query Values Separate from Query Structure
Bind the supplied input as a data parameter and keep allowed query structure fixed.
About 22 minutes, plus any extended practice
Open lesson 4Review and transfer
After the lessons, try 4 new review cases and a practical task. Each answer has an explanation and a link back to the related lesson.
Open the unit reviewGuest answers are temporary. Keep your own paper or document; this unit does not certify completion or record a school grade.
Topic references
- 2026 CSTA PK–12 Computer Science Standards: topic reference — Data & Analysis; Systems & Security
These references informed the topic selection. They do not certify complete standards alignment.