VCE Data Analytics U3O1: Data types and relational databases
Students learn the characteristics of text, numeric and Boolean data and how data types, field sizes, tables and primary and foreign keys structure a relational database.
One content description from the full VCE Data Analytics - U3O1 - Data Analytics journey. All 15 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (15)
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
What is a relational database?
8
What a single-table database is
9
Database field data types
10
Field sizes
11
SQL column data types and sizes
12
Primary key
13
Foreign key and table relationships
14
One-to-many relationships between tables
15
CREATE TABLE and INSERT INTO
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 →