A group activity to introduce data modelling and ER diagrams
Created by Peter Donaldson
last edited Aug 21 2015 by Peter Donaldson
Pupils will analyse social networking sites they use and identify the kinds of information that can be found on them. They will then group different pieces of information into collections (entities) and then think about how they are related to each other. They will then be able to create an ER diagram showing the relationships between them.
Pupils will be able to understand
Level: Higher Computing Science
Duration: 1 or 2 periods
Teaches: ER design notation, relational database structures and relationships
Acknowledgements and License
Inspiration for this event came from #CASincludes Hack the Curriculum days.
This idea and associated resources were developed by Dr Rachel Menzies- University of Dundee, Professor Quintin Cutts- University of Glasgow and David Bethune – SQA Qualifications Design Team and AOK learning
With final refinements, improvements and formatting by Peter Donaldson- Crieff High School in Perth and Kinross
During a Craft the Curriculum for Higher Computing Science joint event held by PLAN C and Education Scotland
© Crown copyright 2015. You may re-use this information (excluding logos) free of charge in any format or medium, under the terms of the Open Government Licence.
Where we have identified any third party copyright information you will need to obtain permission from the copyright holders concerned.