Menu
I'm starting a new project soon and I'd like to try to use some better tools this time around. The last project, I wrote all my Database creation SQL by hand for MySQL. I'm hoping there are some good tools out there for creating, maintaining and modifying database schema in MySQL. My budget is out-of-my-own-pocket, so free (as in beer) would probably be best. :)
949
A good database design is, therefore, one that: Divides your information into subject-based tables to reduce redundant data. Provides Access with the information it requires to join the information in the tables together as needed. Helps support and ensure the accuracy and integrity of your information.
There are two main kinds of database schema: A logical database schema conveys the logical constraints that apply to the stored data. It may define integrity constraints, views, and tables. A physical database schema lays out how data is stored physically on a storage system in terms of files and indices.
#1) Visual Paradigm ERD Tools This is the top-most Database Design tool that helps in designing of the database by following a powerful approach of Entity Relationship Diagram Tools (ERD). ERD is the baseline of any database.
MySQL Workbench : http://dev.mysql.com/workbench/
It is free and very easy to use. I usually create schema diagrams and export it as a .sql file to use with phpMyAdmin
105
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
