Menu
I have mysql database and I want a software which can draw the database design for me?
is there any way to do this?
Thanks
892
How to Design a Database? The first step to designing a database is identifying the purpose of the design. The next step is to gather all of the types of information you might want to record in the database. Now divide your information into major entities or subjects. Each subject becomes its own table.
You can choose to use the Block Diagram and the Basic Drawing Shapes to draw your database model diagrams, but since there is a special template for Database Model diagram, we will look at that first. Open the Entity Relationship template and object relationship template from the ERD & Database category.
You can make corrections before design execution and implementation. Moreover, such diagrams create a graphical representation to understand various entities' attributes and relationships better. This further helps clearly understand the data structure and how you can minimize redundancy and other problems. How to Create a Database Diagram?
The first step to designing a database is identifying the purpose of the design. The next step is to gather all of the types of information you might want to record in the database. Now divide your information into major entities or subjects. Each subject becomes its own table. Now decide what information you want to store in the table.
I think you can use MySQL Workbench, it's supposed to have reverse engineering (from database to model).
http://dev.mysql.com/workbench/
86
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
