Year 11 QCE Digital Solutions Unit 2: Data types, data models and storage
Students choose data types and field sizes, apply constraints, and design single-table data models and data dictionaries from storage requirements.
One content description from the full QCE Digital Solutions Unit 2 — Data-Driven Problems and Solution Requirements journey. All 18 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (18)
1
Text data: character and string
2
Numeric data: integer
3
Numeric data: floating point
4
Date/time data
5
Boolean data
6
Choosing a data type for a value
7
Field data types in a database table
8
Field sizes
9
SQL constraints for validation
10
Entity
11
Attributes become fields
12
Why use a database instead of a spreadsheet
13
What a single-table database is
14
The repeated-data problem in one big table
15
Designing a table structure
16
Defining a single-table database from storage requirements
17
Data dictionary
18
Writing a data dictionary entry
For Teachers
Add this journey to your class and track every student in real time.
Create a free teacher account →No credit card. No setup fee. Make a class and invite students in under three minutes.
For Students
Start this journey on Cloodit — track progress, earn badges, and play live sprints with your class.
Start Learning Free →