Prev Next

Database Modeling

Design, Create and Manage Conceptual, Logical and Physical Data Models

The power of model-based system development is the ability to visualize, analyze and design all aspects of a system. Being able to view and manage information and data alongside other models of a system provides great clarity and reduces the chance of error. Enterprise Architect has extensive support for the data modeling discipline, ranging from the representation of information in a conceptual model right down to the generation of database objects. Whether you are generating database objects from the UML model or reverse engineering legacy DBMS into a model for analysis, the tool features will save time and valuable project resources.

Database engineering in Sparx Systems Enterprise Architect.

Screen shot showing the Database Builder Interface including DDL generation and Foreign Key Dialog.

Enterprise Architect supports the modeling of information at the conceptual, logical and physical layers. Using a number of standard features, these models can be interconnected, providing traceability. The logical and physical models can also be generated automatically using a fully customizable Transformation engine. Legacy systems can be imported, analyzed and compared using the powerful reverse engineering facility.

In this topic you will learn how to use the powerful toolset including the Database Builder to design, create, manage, visualize data including reverse and forward engineering of data models to live database.


Modeling Databases

This collection of images highlights the main methods for modeling databases in Enterprise Architect, Conceptual, Logical and Physical.


The Database Builder tool can be used to create and maintain physical data models and can connect to a running DBMS, so you can therefore import, generate, compare and alter a live database.