What an entity-relationship diagram is

Sign in to read this lesson

Lessons are for learners and teachers with an account. Browsing the curriculum — subjects, strands and what each sub-strand covers — stays open to everyone.

• 8 sections of explanation, worked examples and diagrams
• 1 practice task with hints and worked answers
• A quiz that marks itself as you go
• Your progress kept across every subject you take

Other lessons in this sub-strand

1. Data, databases and DBMS
2. Why DBMS is better for managing data
3. DBMS tools
4. Choosing the right DBMS tool
5. Where DBMS is used in real life
6. How data is organised
7. Tables and records
8. Fields, data types and keys
9. What an entity-relationship diagram is
10. Drawing an ERD
11. Designing a database
12. Creating a database file
13. Entering and editing data with forms
14. Queries and extracting data
15. Sorting and filtering
16. Validation and data integrity
17. Relationships between tables
18. Reports and presenting data
19. Introduction to SQL
20. Security, backup and sharing
21. Gathering and managing real-life data
22. Appreciating database tools