To create a new relationship between two tables, click Relationship on the toolbar and then click parent and child tables in your diagram.
In this example, click table customer and then table order.

The new relationship line appears in the diagram and column customer_id is added to the child table order automatically.… Read the rest