VCE Applied Computing U1O1: Relational database structure
Students learn how relational databases use tables, fields, primary and foreign keys and consistent naming conventions, and how to design, create and validate them.
One content description from the full VCE Applied Computing - U1O1 - Data analysis journey. All 12 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (12)
1
What is a relational database?
2
What a single-table database is
3
Database field data types
4
Primary key
5
Foreign key and table relationships
6
Naming a database and its tables
7
Naming columns, primary keys and foreign keys
8
Designing a table structure
9
CREATE TABLE and INSERT INTO
10
Importing a CSV file into a database table
11
Validation rules on database fields
12
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 →