Relational Database Modelling
Students design relational databases using entity-relationship diagrams and normalisation techniques. They construct complex SQL queries to manage and extract meaningful data.
About This Topic
Students design relational databases using entity-relationship diagrams and normalisation techniques. They construct complex SQL queries to manage and extract meaningful data.
Key Questions
- How does normalisation improve data integrity?
- What are the key components of an ER diagram?
- How do complex SQL queries join multiple tables?
More in Data-Driven Solutions and Security
Data Exchange and APIs
This topic investigates how digital systems communicate and share data using APIs and standard formats like JSON and XML. Students implement data exchange protocols in their own applications.
2 methodologies
Cybersecurity Principles
Students analyse common cybersecurity threats and the strategies used to protect data integrity and privacy. They explore encryption, authentication, and the legal obligations of data custodians in Australia.
2 methodologies