Active learning ideas
Relational database concepts introduce students to the structured world of data management. They learn how to design systems that store information efficiently, avoiding redundancy through the process of normalisation. Key concepts include defining entities, attributes, and the relationships between them using Entity-Relationship Diagrams (ERDs). Students also master the use of primary and foreign keys to maintain data integrity across multiple tables.
Activity 01
Groups are given a scenario, such as a school library system. They must use a digital whiteboard to identify entities (Books, Students, Loans) and draw the relationships between them, identifying where foreign keys are needed to link the tables.
How do relational databases organise data?
Activity 02
Set up three stations with 'un-normalised' data tables full of redundancy. At each station, groups must apply the rules of 1NF, 2NF, and 3NF to split the tables correctly, checking their work against a 'solution key' before moving on.
What is the purpose of normalisation?
Activity 03
Provide a list of entities (e.g., Australian Citizens, Cars, Hospital Patients). Students individually suggest the best primary key for each (e.g., TFN, VIN, UR Number) and then pair up to discuss why a name or birthdate is a poor choice for a primary key.
How do we ensure data integrity?
A few notes on teaching this unit
Watch Out for These Misconceptions
A database is just a big spreadsheet.
Students often try to put all data into one table. Active 'normalisation' exercises, where they see how one change in a spreadsheet requires hundreds of manual updates, help them understand the power of relational linking.
Primary keys can be any data that is currently unique, like a phone number.
Students don't realise that phone numbers can change or be shared. Peer discussion about 'edge cases' helps them see why stable, system-generated keys (like IDs) are superior to 'natural' keys.
Methods used in this brief
Data and information
Students explore how data is collected, stored, and transmitted in digital systems. They analyse the difference between raw data and meaningful information.
8 methodologies
Data-driven programming
Students write code to interact with databases, performing CRUD operations. They use SQL and programming logic to manipulate data.
8 methodologies
Evaluating digital solutions
Students evaluate their data-driven applications against prescribed criteria and user requirements. They propose refinements based on testing outcomes.
8 methodologies