CAS Community   >   Resources   >  

Craft the Curriculum Data Modelling and ER Diagrams Activity

A group activity to introduce data modelling and ER diagrams

Peter Donaldson

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

  • what an entity and an attribute are
  • how these are related to instances and values
  • what a relationship is and the different types of relationships between different entities
  • the purpose of an ER diagram
  • that ER Diagrams are one way of creating an information model

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.

Downloaded 1393 times.


This resource has attached files: to access these files, please tick the box below to assent to the license terms
License: The resources on CAS website are under Creative Commons Attribution-Share Alike 3.0 licence unless otherwise specified by the resource creators.

You must confirm that you have read and agree the licence's ToS before you can download the attachments of this resource.

I have read the licence agreement of this resource and agree to abide by its terms and conditions.

Feedback and Comments

Available when logged in (join via the front page, for free):
  • View 2 comments on this resource.
  • View resource history, links to related resources.
  • Leave feedback for the author(s), or help by editing the resource.