Enterprise Architect (EA) and Rose are common tools for UML modeling during software development. EA use is also more extensive, here I will use some of the process to share some of the usage, as a note, but also hope to bring convenience to the people in need.
EA can draw use case diagram, Class diagram, Database model, time series diagram, collaboration diagram, State diagram and more, these categories are more commonly used. This article first introduces the use of EA to create a database model.
1. Create a new project, create a new data model, select database
2. Build a table
Take a user table for example, the following boxes out of a few items, is very necessary to perfect. After setting up alias (alias), we see Chinese. The choice of database involves the type of data behind the new field and the interaction with the database. After you fill out notes, comments appear in the database as well. Author identifies the design object.
For author, you can set the default author in Tools--options. You can also set more configuration information here.
The aliases and comments for each field are as above.
3. Design layout Color
Click on the right of the format brush, will appear similar to Word font, style, background and other settings information. After setting the background, you can set the other table to the same style by using the Format Painter.
Select the table with the style, select the Eyedropper, and then click on the Format Painter on the No-style table to complete.
4. Designing FOREIGN Key associations
Select the associate line in the toolbar, set up the connection line, right-click the correlation line, select the foreign key, select the source table and the target table of the associated fields, save. The difference between the EA and the PowerDesigner Design database table is that when PD establishes a foreign key association, the foreign key is automatically added to the source table, and the EA needs to create a new foreign key field in the source table and set the association relationship of the two tables.