DBDesigner+and+MySqlWorkbench+Relations+and+Relationships+implementation+01 - 图文

Database design implementation using Entity Entity (EER) Relation diagrams.

By Per Dahlstr?m

? Per Dahlstr?m 12-07-2013

Index

Introduction .......................................................................................................................................... 3 Data Base Designer 4 - DBD4 ............................................................................................................. 3 Set the Data Base Model options ......................................................................................................... 4 Creating two entities with no relationship ........................................................................................... 5 Generate the SQL statements to create the tables ............................................................................ 7 Making interrelation relationships ....................................................................................................... 8 One to many ..................................................................................................................................... 8 Many to Many .................................................................................................................................. 9 One to One ..................................................................................................................................... 10 Self referencing relationship(s) ...................................................................................................... 11 Hints ................................................................................................................................................... 13 MySQL Workbench ........................................................................................................................... 14 .Net installation .............................................................................................................................. 14 MySql installation .......................................................................................................................... 15 Create a new EER diagram ................................................................................................................ 16 Managing database by MySQL Work bench ..................................................................................... 18 Edit table data................................................................................................................................. 20

? Per Dahlstr?m 12-07-2013

Introduction

Using a Design tool requires a solid knowledge of Database modelling terms and theory.

This guide is on implementation of relations and relationships is a walk through of basic set ups and creation of basic designs. The focus is not so much on using the design tools rather than demonstrating how the programs assists implementing a database design.

Very simple, one letter attribute names are used, like a, b and c. It is strongly recommended NEVER to use this kind of one letter attribute names in a real design! Use carefully selected descriptive names.

Data Base Designer 4 - DBD4

It is strongly recommended to familiarize with the HTML manual which came with the installation.

The manual is reached by selecting the menu item: help>HTML_Documentation.

Start by going through the sections: Modelling, Tables and Relations, Place a new Table, Edit a Table, Create Table Indices and Make a relation.

? Per Dahlstr?m 12-07-2013 Page 3 of 21

Set the Data Base Model options

Set Database engine to InnoDB and deactivate index creation in Model Options.

Close the window by clicking the cross in the lower right corner.

? Per Dahlstr?m 12-07-2013 Page 4 of 21