SHSubjectHub

Conceptual Data Models & Entity-Relationship Modelling

AQA 75174.10.1A-levelLesson packSubscription
Also online

This worksheet marks itself

Set it as homework or classwork and every answer is marked as pupils go, with feedback on what they got wrong. The scores go straight into your mark book, so you can see who needs help before the next lesson.

  • 9 questions
  • 38 marks
  • about 55 minutes
  • marked instantly

Question types: multi-part, multiple choice, fill the gap, matching, true or false.

Try it with a class, freeHow it works

About this resource

AQA A-level Computer Science (7517) Paper 2, 4.10.1 — producing a data model from given data requirements for a scenario involving multiple entities; producing entity-relationship diagrams (ERDs); producing entity descriptions in Entity(Attribute, Attribute, ...) notation with the entity identifi…

22 slides.

Lesson outline

  1. Do Now — Retrieval from 4.9f
  2. Quick Check — Bringing Back the Everyday Meaning
  3. Entities and Attributes
  4. The Entity Identifier (Primary Key) & Notation
  5. Hinge Check — Entity or Attribute?
  6. Notation Practice — Instructor
  7. Relationships and Cardinality
  8. Worked ERD — Reading Cardinality
  9. Hinge Check — Which Way Round?
  10. Match the Cardinality
  11. Foreign Keys — Linking Entities Together
  12. Hinge Check — Primary Key or Foreign Key?
Unit bundlePaper 2
Part of: Paper 2: the whole unitEvery resource in the unit in one zip.

More from 4.10 Fundamentals of databases