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.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.
Conceptual data models and entity relationship modelling, AQA A-Level (7517) 4.10.1. Foreign keys and the relational model, 4.10.2.
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