Technology LearningCheat Sheet
DATABASECHEAT SHEETS
SHEET 07
The Design Process, ER and EER
M.R. Sterling
Database Advanced · Sheet 07
The Design Process, ER and EERSQLite
Read an EER diagram, then build one hierarchy three ways in SQLite: one table full of NULLs, a table per subclass, and concrete tables whose ids clash. Plus the four design phases, (min, max) on a recursive link, and weak entities.
$4.50Get this sheet
Or get all 6 in the Database Cheat Sheets: Advanced Pack for $19, or with the whole Health Data Clinic series in the Health Data Clinic - Complete + Cheat Sheets for $109.
Instant PDF downloadsent the moment you pay
Two A4 pagesprint front and back
SQLiteevery query runs as printed
Keep it foreverno expiry, no account
What the sheet looks like
A blurred preview, to show the layout and how much fits on the two pages. The full, print-sharp sheet comes with your download.
What is on this sheet
Reading an EER diagram
Four phases, in order
Recursive link, read with (min, max)
EER words
Map 1: one table
Map 2: a table per subclass
Map 3: concrete classes
Choosing a map
Weak entity
The books this sheet pairs with
The sheet reminds you. These books teach it, one idea at a time, with every example worked.
More Database Advanced sheets
One email when a new book lands
No schedule, no filler. Just the new titles and the odd free chapter.