Our Featured Articles:
1 2 3 4 5 6 7 8 9 10


How to Create EER Diagram with MySQL WorkBench

December 16, 2011 admin MySQL Resource

Post to Twitter





Enhanced Entity Relationship Diagram (EER)

  • Requirements: MySQL WorkBench 5.2 CE or later
  • Language: SQL/Database Management System
  • Level: Beginner
  • Prerequisite: SQL Knowledge

Definition:

Entity Relationship Diagram or ER diagram is a data modeling method represented by symbols use to produce a relational database. A relational database is a database that conforms to relational model theory managed by so called Relational Database System (RDBMS). There are several software available that you can use to manage a database system. SQL Server Management Studio is a DBMS that manages Microsoft SQL Server, SQLYog is also a DBMS that can manage MySQL Server these are Commercialized DBMS for a cost, The most popular of them is the MySQL WorkBench, it is a visual database design tool similar to what I mentioned earlier but this is an Open Source created by MySQL-ORACLE, this is previously called MySQL GUI Tools Bundle. You can download MySQL WorkBench from MySQL Website or HERE.

Purpose:

The Purpose of MySQL Workbench is a tool for: Database Design, SQL Development and Database Administration. In this Tool you can create database, tables, stored procedures, functions, relationship or Manage indexes and of course Diagram. In this article I will be showing you on how to design an Enhanced Entity Relationship Diagram that you can use to design your project in a system development cycle. You can watched the provided tutorial video below:

Tutorial on how to create EER Diagram With MySQL Workbench:




What is in this Tutorial Video?

I used MySQL Workbench 5.2.23 CE to create an Enhanced Entity Relationship Diagram, you need to have a MySQL Database Engine installed and a Database available populated with tables and data. This tutorial assumed that you already have a database ready. If you haven’t done so you can check the Basic Database Creation 1 article to start designing your database. The Procedure will import tables from testdb schema by means of Reverse Engineering Process. To create a relationship between tables “Cardinality” just drag and drop the “Primary Key” from the parent table to child table to create a “Foreign Key“, this process will generate Indexes to be used in a database relationship. In this tutorial I have used four tables, persons, payroll, dtr and rate respectively.
VN:F [1.9.6_1107]
Rating: 7.6/10 (17 votes cast)
VN:F [1.9.6_1107]
Rating: +4 (from 8 votes)

How to Create EER Diagram with MySQL WorkBench, 7.6 out of 10 based on 17 ratings


Post to Twitter

Keywords: , , , , , , , ,

Other reading this article are also reading these:

cardinality, database, mysql, mysql database, mysql workbench,

3 comments on “How to Create EER Diagram with MySQL WorkBench

  1. Carter Dunley on said:

    Thanks for the video. I liked the step by step walk through. I was still a bit confused about the terms so I looked them up and found that www.lucidchart.com/pages/enhanced-entity-relationship-diagram had a pretty good list at defining them. Could you in corporate something like this into your video or comments?
    Thanks

    VA:F [1.9.6_1107]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.6_1107]
    Rating: 0 (from 0 votes)
  2. Karren Barlow on said:

    Thanks for the info! I have also recently found an Enhanced Entity Relationship Diagram (ERD) through lucidchart that is very easy to use! I would definitely recommend checking it out! www.lucidchart.com/pages/enhanced-entity-relationship-diagram

    VA:F [1.9.6_1107]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.6_1107]
    Rating: 0 (from 0 votes)
  3. macy dalby on said:

    Thanks this info was really helpful! I used a website called Lucidchart to find an erd diagram tutorial and it was super easy to use. If you use diagrams often you should check it out! www.lucidchart.com/pages/er-diagram-tool

    VA:F [1.9.6_1107]
    Rating: 0.0/5 (0 votes cast)
    VA:F [1.9.6_1107]
    Rating: 0 (from 0 votes)

Leave a Reply

Your email address will not be published. Required fields are marked *

*

110,914 Spam Comments Blocked so far by Spam Free Wordpress

HTML tags are not allowed.

Powered by WordPress 3.5.1. Designed by elogi. Allright Reserved SourceHints 2010-2014