Year 11 Computer Science ATAR: Relational database design
Students learn to design relational databases using entities, attributes, keys, relationships, entity relationship diagrams and data dictionaries.
One content description from the full WA Computer Science ATAR Year 11 — Data Management journey. All 22 modules below are in that journey too, with the same content — add just these to a class, or the whole strand.
Modules (22)
1
What is a relational database?
2
Database objects: table, query, form and report
3
Entity
4
Attributes become fields
5
Database field data types
6
Field sizes
7
Primary key
8
Choosing a suitable primary key from a table
9
Composite primary keys
10
Foreign key and table relationships
11
One-to-many relationships between tables
12
One-to-one and many-to-many relationships
13
Referential integrity
14
Entity relationship diagram: entities and relationship lines
15
Crow's foot notation for one and many
16
Drawing an ERD from a scenario
17
Designing a table structure
18
Naming a database and its tables
19
Naming columns, primary keys and foreign keys
20
Data dictionary
21
Writing a data dictionary entry
22
Defining a single-table database from storage requirements
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 →