Data Modeling Toolbox

The Data Modeling Toolbox provides a basic set of elements for database modeling and database design, in conjunction with the UML Data Modeling Profile.

Data Modeling Toolbox page



See also


In the data model, a:

·Table defines a table
·View represents a database view
·Procedure represents stored procedures
·Sequence represents a database Sequence
·Function represents a database Function
·Database Connection helps you to configure a connection to the database you are modeling, for testing, import and export of schema, and comparison of differences between database and model using the Database Builder
When you drop this icon onto the diagram the system prompts you to indicate whether to create the connection for an Access database, a Firebird database or an ODBC database
For the first two options, when you click on the OK button the system prompts you to select the file to create the connection to
If you select the ODBC database option, the Select Data Source dialog displays; click on the Machine Data Source tab and select the data source (project on a database)
After you have defined the data source, when you double-click on the element the Database Builder view opens for the current database model





Stored Procedures


Database Functions


The Database Builder


·To add an element to the currently-open diagram, click on the appropriate icon and drag it into position on the diagram; set an element name and other properties as prompted
·To add a relationship, click on the appropriate icon, then click on the start element in the diagram and drag to the end element


Learn more