After install DBDesigner( I describe this process in my last post) You may run this application.
You see window as below:
Click the icon
New Table and click on the canvas.
You see table object. Click right on the table object and choose
Edit Object from the menu.
Table Editor wizard displays.
Table Name filed write name of table and fill fileds in
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 .
OK button. in the same way create another table.
OK button to save person table.
The table will be in relation. The people may work in department. So it will be relation
1 to n.
FOREIGN KEY will be autocreating in the table. You must only create
New 1:n button.
And click table with
department table ), then click the table indicated the table with
person table). In the
person table will be creating FOREIGN KEY. Loook at diagram:
You may change name of
FOREIGN KEY column or name of relation. Click right the stroke or name of relation and choose from menu
Relation Editor window.
Relation Editor change data.