Database management systems notes

ER Modelling

Turning a vague requirement into entities, attributes and relationships you can defend. Every section is a drawn page beside a clear written explanation, about 22 minutes in all.

  • Chapter 4 of 34
  • About 22 minutes
  • 9 sections

Sign in with Google or GitHub and you land straight on this page. DSA comes with the all labs plan and every ChaiCode batch.

The first drawn page of ER Modelling: Why model before you build
The chapter's first page: Why model before you build

In this chapter

  • Why model before you build
  • Entities and entity sets
  • The five kinds of attribute
  • Relationships and degree
  • Cardinality: one-to-one, one-to-many, many-to-many
  • Participation: must it, or may it?
  • Weak entities
  • Extended ER: specialization, generalization, aggregation
  • A complete worked diagram

Next chapters

Read the whole chapter

Sign in and the chapter opens with every drawn page, and all 35 database management systems chapters beside it.

DSA comes with the all labs plan and every ChaiCode batch.