Complete database design with EA

Understanding of the EA is also increasing after starting the refactoring, and today we summarize how to use the EA to complete the design of the database. The figure below is cut from the computer room charge system and beef Brisket news development database, because I wrote the first time in the computer room when the cooperation, and then set up the Beef brisket press release system, and then use this method, found the first time to write this blog in the establishment of foreign key when some problems, and then re-corrected a bit, So if you find that it is not a database, do not have doubts, the method is the same, and then specific to generate code section of the explanation. Learning is a continuous trial and error process, it is important to learn new knowledge, look back

1. Select the model

2. Create a table

4. Setting Field Properties

‘

5. Set the foreign key to click on the Association in the tool box, list the associated two tables, right click on the connected line, click Foreign Key, then set the foreign key properties in the popup box.

6. Generate Code Select table, right click, select Generate Code

Then you can generate a SQL file, in SQL Server Open is the statement to create the table, and then we select the corresponding database, we can execute the statement, the established table and we in the database with the SQL statement created by the table is exactly the same

7. Generating Documents

Summarize

Through the cooperation, using in-depth use of EA This software, found a lot of previously unknown features, more and more feel this software is very powerful, there are more features waiting for us to discover to explore

Complete database design with EA