DATAUML Design Tutorial 7-Database generation model

The DATAUML design supports database generation models and supports foreign key relationships, enabling automatic generation of relationships between classes and classes based on foreign keys. Currently DATAUML design supports Ms Server, MY SQL, Oracle and Access databases, and other databases are being continued.

DATAUML design supports database tables to generate class diagrams that support browsing database object functionality.

First, browse the database object

1. Select the database object you want to view, right mouse button, click "Connect" menu. such as 7-1

Figure 7-1

After the connection succeeds, load all tables in the database, such as 7-2

Figure 7-2

2, then select the Database node object, the right mouse button, the following menu appears. Figure 7-3

Figure 7-3

3, click on the "Browse database" menu, a new window appears, displaying all the data table information. 7-4

Figure 7-4

Currently only the data table information is displayed, and the view information will be implemented in a later release.

4. Select each table node, and the right window displays all information about the table structure, including the primary foreign key and index. such as 7-5

Figure 7-6

5. Select the Data table node, right mouse button, pop-up menu, click "Load Column", the table's field and key information will be displayed under the table node. such as 7-7

Figure 7-7

Second , database generation data Model　

1, the addition of the database has been introduced before, here is no longer introduced, select the database to generate the data model, such as 7-8, select the "ORCL" database.

Figure 7-8

2, select the database that needs to generate the model, right mouse button, first click "Connect", after connecting the database, generate Data Model function is available, the following menu appears. Figure 7-9

Figure 7-9

Only models that generate the C # and Java languages are currently supported, and other languages will be supported in future releases. Generate a model process such as 7-10

Figure 7-10

3. Build complete

The interface after the database generation model is completed. Figure 7-11

Figure 7-11