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 ...