"Enterprise Architect" and the indissoluble bond of database

Preface

In this era of big data, it is essential to deal with data, and it will be more convenient for us to live without tools to standardize our database. This room, we use EA (Enterprise Architect) to generate SQL statements automatically to achieve a key to build the database.

content

Database is inseparable from our ER diagram, the following introduction to the computer room charge system examples are introduced:

1. Er Generation data Table

• First determine the entities and attributes to draw the ER diagram;
• Open EA New Project

• To set a save path for a new project

• Select model

• New chart

• Select the tool you want to use

• Well-painted ER diagram

• ER Diagram Generation database table

2. Data sheet to SQL statement perfect transformation

Since the database tables generated with the ER entity diagram are only part of what we want, all here we can generate SQL statements and documents by drawing the table ourselves.

• After you create a new project, select the tool that draws the table

• Drag the table control out and then write the data table name and field

• Converting completed tables to SQL statements

• Converting a table to a database description document

The things we need here are all sorted out by EA, and it's not as if the EA is strong.

Summary

1, the work has a time is a giant, learn to stand on the shoulders of giants.

2, the greatest charm of people is the use of tools.

Thank you for your valuable time ~ ~ ~

"Enterprise Architect" and the indissoluble bond of database