Shulou(Shulou.com)06/01 Report--

This article mainly introduces navicat how to generate er map, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to understand it.

Navicat software is really a good thing. Today you need to analyze a database, and then you want to look at the relationships between the tables, so you need to look at the table-to-table diagram, which is technically called an ER diagram.

By default, the interface displayed by Navicat looks like this:

The software treats the table as an object and then displays all the tables. Just through these table names, it is difficult for us to analyze the relationship between tables. So, if we can show the ER diagram, then we can see it at a glance.

Click the View menu and we see that the list is selected by default. So what we see is that the data table is displayed as a list by default. We just click to switch to "ER Chart" to create an ER diagram. It takes some time for the first time. The details can show the relevant description information of the table at the bottom, and it also allows us to see the relevant information of the table better and more directly.

After the switch, the ER diagram is created, and we can see that a relational connection has been established between the different tables. Click on the connection between the two tables and we can see how the tables are associated.

It's that simple, but usually I don't pay attention to it. Share it and let everyone know it first.

Expand knowledge

Emurr diagram, also known as entity-relation diagram (Entity Relationship Diagram), provides a way to represent entity types, attributes and relationships, which is used to describe the conceptual model of the real world.

It is an effective method to describe the conceptual model of real-world relations. Is a way to represent a conceptual relational model. The entity type is represented by "rectangle", and the entity name is written in the rectangle; the attributes of the entity are represented by "ellipse frame" or rounded rectangle, and the "solid line segment" is used to connect it with the "entity" of the corresponding relationship.

The "diamond box" is used to indicate the cause of the relationship between the entity types, and the name of the connection is written in the diamond box, and the "solid line segment" is used to connect with the relevant entity type respectively. At the same time, the type of connection is marked on the side of the "solid line segment".

Composition

There are four components in the ER diagram:

Rectangular box: represents the entity, with the entity name entered in the box.

Diamond box: indicates the contact, enter the contact name in the box.

Oval box: an attribute that represents an entity or connection, and the attribute name is entered in the box. For the primary attribute name, underline its name.

Connection: between entities and attributes; between entities and connections; between connections and attributes are connected by a straight line, and the type of connection is marked on the straight line. (for one-to-one connections, write 1 in each of the two entity connection directions; for one-to-many connections, write 1 on one side and N on the other side; for many-to-many relationships, write NMagm in the connection direction of both entities.)

Thank you for reading this article carefully. I hope the article "how to generate navicat er Diagram" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.