QCE Digital Solutions Unit 2: Database design, data types, constraints and keys
Students learn how a relational database is designed, with entities, fields, data types, primary and foreign keys, relationships, ERDs, a data dictionary, naming rules and validation constraints.
One content description from the full QCE Digital Solutions Unit 2 — Prototype Data Solutions 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
Proof-of-Concept, Prototype and Product
2
What is a relational database?
3
Entity
4
Attributes become fields
5
Database field data types
6
SQL column data types and sizes
7
Primary key
8
Foreign key and table relationships
9
One-to-many relationships between tables
10
One-to-one and many-to-many relationships
11
Referential integrity
12
Entity relationship diagram: entities and relationship lines
13
Crow's foot notation for one and many
14
Drawing an ERD from a scenario
15
Data dictionary
16
Naming a database and its tables
17
Naming columns, primary keys and foreign keys
18
SQL constraints for validation
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 →