Detailed method of creating database model diagram in Visio2010

Visio2010, as a powerful drawing tool, plays an important role in creating database model diagrams. In order to help everyone master the method of creating database model diagrams in Visio2010, PHP editor Xigua will introduce the steps in detail. This article will lead you to understand the creation process of database model diagrams in Visio2010, including adding entities and relationships to defining properties and constraints, and guide you step by step to complete the drawing of database model diagrams. Through this article, you can easily master the skills of creating database model diagrams in Visio2010, laying a solid foundation for database design and development.

1. Create a new database model diagram in Visio

Open Visio 2010, File -> New -> Database -> Database Model Diagram. After creating the database model diagram, there is an additional menu item [Database] in the menu bar.

Look at the picture below. There is an extra database item in the menu bar

2. Draw each table, view, etc. created by the database in sequence

Enter the drawing state, see the left side of the interface, select the [Entity] drawing model, hold down the left mouse button, and drag it directly to the drawing area with the ruler in the middle. Then the main work is done Set the properties of the table. See the property settings at the bottom of the main interface window of the program. Now select [Definition] in the category on the left. Enter the physical name and conceptual name of the data table in turn. Note that if the physical name and conceptual name are inconsistent, you must uncheck the synchronize name when typing. Just fine.

3. Next set the column properties

Category select [Column] and fill in the physical name and data type of the column in the actual database according to the actual situation. Columns that are primary keys and columns that cannot be empty must check [PK] or [Required]. If you need to add comments to the column fields, select the corresponding column, click [Edit] next to it, and the column attribute editing will appear. window, first uncheck [Synchronize names while typing], and then fill in the column field descriptions you need in the concept name. After filling in, click [OK] to use this as an example to complete the attribute editing of each column.

4. View the database model diagram

After editing all columns, you can see the database model diagram in the drawing area. The entire database model diagram can be resized by dragging.

5. Save the database model diagram

The last thing to do is to save the database model diagram for use, click [File] on the menu bar, and then select [Save as], select the save location, the save type can be selected as [jpg], and finally click [Save] to save the drawn data model diagram in the form of jpg.

Note: It is recommended to keep drawing type files (*vsd) for future editing.

The above is the detailed content of Detailed method of creating database model diagram in Visio2010. For more information, please follow other related articles on the PHP Chinese website!