Create database model in DBDesigner

After install DBDesigner( I describe this process in my last post) You may run this application.

You see window as below:
dd9Close Tips window.
gg1
Click the icon New Table and click on the canvas.
gg2
You see table object. Click right on the table object and choose Edit Object from the menu.
gg3
The Table Editor wizard displays.
gg4
In Table Name filed write name of table and fill fileds in Column Name, DataType and so on. The NN column signs that value in this column may not be NULL. You may change column as PRIMARY KEY drag and drop column row in Columns section botoom-right of the window. In this palce You may either select and delete column as PRIMARY KEY .
gg5
Click the OK button. in the same way create another table.
gg6
Click OK button to save person table.
gg7
The table will be in relation. The people may work in department. So it will be relation 1 to n.
The FOREIGN KEY will be autocreating in the table. You must only create PRIMARY KEY.
Click the New 1:n button.
gg8
And click table with PRIMARY KEY( department table ), then click the table indicated the table with PRIMARY KEY( person table). In the person table will be creating FOREIGN KEY. Loook at  diagram:
gg9
You may change name of FOREIGN KEY column or name of relation. Click right the stroke or name of relation and choose from menu Edit Object.
gg23
You see Relation Editor window.
gg24
In Relation Editor change data.
gg25
Click the OK button.
gg26

Leave a Reply

Your email address will not be published.

Time limit is exhausted. Please reload CAPTCHA.