AppendixThe UML Data Modeling Notation
This appendix overviews the physical data modeling notation used throughout the book. We have used a subset of the notation described in the Unified Modeling Language (UML) profile originally presented in Agile Database Techniques (Ambler 2003) and now maintained online at www.agiledata.org/essays/umlDataModelingProfile.html.
Figure A.1 describes the basic notation for tables within a database schema. Tables are represented as boxes with one, two, or three sections. The first section, the one containing the table name, is mandatory. The other two are optional, the second one listing the columns of the table, and the third one listing the triggers associated with the table (if any). In the column list, ...
Get Refactoring Databases: Evolutionary Database Design now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
