Active learning ideas
Relational Database Modelling is a cornerstone of data-driven solutions. Students learn to organise complex information into logical structures using Entity-Relationship Diagrams (ERDs) and normalisation techniques (1NF, 2NF, 3NF). This topic is essential for managing data integrity and ensuring that digital solutions are scalable and efficient, reflecting the ACARA focus on managing and manipulating data.
Activity 01
Provide groups with a large, messy spreadsheet of 'un-normalised' data (e.g., a school sports day record). Students must work together to break the data into separate tables and define the primary and foreign keys to reach 3NF.
What are the core tenets of Engineers Australia's Code of Ethics?
Activity 02
Present a complex data request (e.g., 'Find all students who take IT and have an overdue library book'). Students draft the SQL query individually, then pair up to debug and refine their logic before sharing with the class.
How do engineers balance cost, efficiency, and public safety?
Activity 03
Students act as 'Entities' (e.g., Student, Course, Teacher) and use lengths of string to represent 'Relationships'. They must physically demonstrate one-to-many and many-to-many connections to understand how linking tables are formed.
Why is whistleblowing a complex ethical issue in engineering?
A few notes on teaching this unit
Watch Out for These Misconceptions
A many-to-many relationship can be directly implemented in a database.
Many-to-many relationships require a junction (linking) table. Physical modelling with strings and cards helps students see why a direct link fails to store unique data for the relationship itself.
Normalisation just makes the database more complicated.
Normalisation reduces data redundancy and prevents update anomalies. Using a 'broken' database simulation helps students experience the frustration of inconsistent data, making the value of 3NF clear.
Methods used in this brief
Case Studies in Engineering Failures
Investigate historical engineering disasters to understand the social and regulatory fallout. Analyse how failures have historically driven improvements in safety standards and legislation.
8 methodologies
Intellectual Property and Innovation
Explore the history and social implications of patent law and intellectual property in engineering. Discuss how protecting innovations balances individual reward with public benefit.
8 methodologies
Social Responsibility and Community Impact
Evaluate the role of engineers in addressing social inequities and community needs. Students will examine how engineering projects can both marginalise and empower local populations.
8 methodologies