Database Structure

We have explained how to construct data models using a blend of the UML and IE notations. Developers start with a conceptual model of intent and add attributes and detailed classes to obtain a logical model. The physical model then adds database design decisions to the logical model.

For any serious database design, developers should use a tool. It is tedious and error prone to manually write SQL statements to create tables and ancillary data structures.

15.1 Fine Tuning of Physical Tables

IE makes it clear which tables are generated; each entity type box leads to a SQL table. If your application needs fine tuning, you can adjust the IE diagram. (However, such table optimization is seldom necessary; SQL is efficient if ...

Get UML Database Modeling Workbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.