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

Hints

The following is a list of remedies for frequently occurring mistakes when designing a database in DBD4:

MySql requires that VARCHAR MUST be given a size. E.g. VARCHAR(27). Set the number in datatype.

Be careful not to use SQL reserved names for tables and attributes. e.g. InOut is a reserved word. If used, it causes SQL errors which are difficult to interpret.

Using – in tables and attributes causes SQL errors. Only use underscores _ in tables and attributes if necessary. A better naming strategy is to use uppercase letters to distinguish multiword names. e.g. ParkingLot, MailBox and PlantId.

MYISAM database engine does not support foreign keys. In menu Options>Model Options, set the InnoDb database engine to be used.

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

MySQL Workbench

Install and start the workbench. Note that you will be asked to install .Net, which is used by MySql Workbench.

.Net installation

Start installation programme: “dotNetFx40_Client_x86_x64.exe”

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

MySql Workbench installation

Thats it.

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

Start MySql Workbench

Create a new EER diagram

Click:

Double click the Add Diagram icon:

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