The initial development of a system typically involves numerous levels of abstraction. Database modeling traditionally includes a well established three tiered approach:
- Conceptual Model
- Logical Model
- Physical Model
This paper covers creating these models, interconnecting models on these levels, using MDA transforms for generating the Physical model from the Logical model, along with generating schema scripts for loading to your DBMS. It also covers the features for remodeling legacy systems including Reverse Engineering an existing DBMS structure.