Canvas ×
Entity descriptions
Underlined = entity identifier · * = foreign key
Model checks
Build from text
One line per entity: Student (_StudentID_, Name, TutorGroupID*). Wrap the identifier in underscores, end a foreign key with *. Relationships: TutorGroup 1-M Student, also 1-1, M-1, M-M.
About this resource · A-Level

A free entity relationship diagram tool for students and teachers

Draw an entity relationship diagram by adding entities and the relationships between them. Relationships use crow's foot notation: a plain line end means one and the forked "foot" means many. Pick the degree of each relationship (one-to-one, one-to-many or many-to-many) in the side panel, and it reads the relationship both ways for you.

Give each entity its attributes, mark the entity identifier (underlined) and any foreign keys (shown with *), and the entity descriptions are written for you in the exam format Entity (Attribute1, Attribute2, …). The model checks spot common mistakes, such as a missing identifier, a foreign key on the wrong side or an unresolved many-to-many relationship, and can fix them in one click.

You can also type entity descriptions and relationships as text and build the diagram from them, then export a PNG for a worksheet, slide or revision note, or copy a share link.

Exam tips

Specification

Conceptual data models and entity relationship modelling, AQA A-Level (7517) 4.10.1. Foreign keys and the relational model, 4.10.2.

Related resources

Want one-to-one help with this topic? I'm Damian Biasone, a qualified Computer Science teacher with 20 years' experience, tutoring GCSE and A-Level students online.

OCR A-Level (H446) tuitionAQA A-Level (7517) tuition