CSE Roadmap

Core tier · about 3 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Name an entity, a relationship and an attribute in a real scenario.
  • Draw a simple entity-relationship diagram with correct cardinality notation.
  • Explain the difference between one-to-one, one-to-many and many-to-many cardinality.
  • Use an ER diagram to plan a schema before writing any CREATE TABLE statement.

Level 0 introduced a schema diagram, drawn after tables already exist. This page covers the earlier planning step: deciding what the tables should even be, before any SQL is written at all.