ER - crow's foot
Data modelling: ER and crow's foot notation
Entity-relationship modelling in crow's foot notation, and the trip from a conceptual sketch to a schema a database will actually accept.
3 artículos28 min de lectura
Empiece aquí
Entity-relationship diagrams
How to read and draw an entity-relationship diagram: entities, attributes, primary and foreign keys, relationships and cardinality in crow's foot notation, the conceptual-logical-physical progression, and how an ER model differs from a UML class diagram.
9 min de lectura
Leer en orden
Data models and the diagrams that carry them
- 02Crow's foot notationThe crow's foot cardinality symbols in full: one, many, zero, and the pairs they form; which end of the line each symbol constrains; identifying versus non-identifying relationships; resolving many-to-many; and how crow's foot compares with Chen and with UML multiplicity.Notation reference8 min de lectura
- 03Schema designTurning an ER model into a schema a database will accept: choosing keys, normalizing to third normal form with a worked example, when denormalization is justified, implementing inheritance, and generating DDL from the diagram.Modelling practice11 min de lectura
Las demás series