Unit 4: Data management

2 dot points across 2 inquiry questions, in syllabus order. Each dot point has a focused answer, with exam-style questions and worked answers where available.

How are relational databases designed so data stays accurate and consistent?

Explain relational database concepts (entities, attributes, primary, foreign and composite keys, relationships and anomalies), model data with ER diagrams, relational notation and data dictionaries, and apply data integrity, data quality and normalisation to third normal form

Relational database concepts, primary, foreign and composite keys, insert, update and delete anomalies, ER diagrams with cardinality, relational notation, data dictionaries, entity and referential integrity, data quality, and step-by-step normalisation to first, second and third normal form.

9 min read →

How are databases queried, connected to applications and managed responsibly?

Write SQL to create, query and modify relational data (including joins, aggregate functions and grouping), import data, explain database connectivity (such as ODBC) and ACID transactions, and discuss the ethical, security and legal issues of managing data

Writing SQL for WACE Computer Science: CREATE TABLE with constraints, SELECT with WHERE, ORDER BY, JOIN, GROUP BY and aggregates, INSERT, UPDATE and DELETE; importing data; how applications connect through ODBC; ACID transactions; and ethical, security and legal issues in data management.

9 min read →