My Profile
Help
Hot Topics
Top Community Contributors
-
EA16 on Tour
Written by Peter Lieber -
Enterprise Architect Version 16 release
Written by sparxsystems -
EA 16 - Resources and Videos for Reference
Written by Nizam-Mohamed -
Monitor Real-time Diagram Updates in Enterprise Architect 16.
Written by Sparx Systems India -
Quick Reports Through Custom Documentation in Enterprise Architect 16
Written by Sparx Systems India -
Enhanced User Security in Enterprise Architect 16
Written by Sparx Systems India -
Integrating Decision Tables and Executable State Machines
Written by Phil Chudley -
GANTT Chart View in Resource Allocation Window
Written by Sparx Systems India
Displaying items by tag: forward engineering,
Monday, 22 August 2011 00:00
Data Modeling - From Conceptual Model to DBMS
Enterprise Architect supports comprehensive functionality for modeling database structures. This paper covers the core features for data modeling over the full lifecycle of an application.
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.
Published in
White Papers