Step 2. Relate the Order and Ordered Product Entities

In this step, you will create a relationship between the Order and Ordered Product entities and see the impact it has on the Ordered Product entity's elements. Remember, the model is based on a classical order processing system, where customers place orders for products. The relationship you are going to create states that an Order is the parent of Ordered Product, i.e. an Ordered Product cannot exist without its parent entity, Order.

1.  Drag the Relate connector from the Document Stencil onto a blank portion of the model diagram.

2.  Connect the relate shape source to the Order entity and connect the target to the Ordered Product entity.

3.  In the Create Relationship dialog, select 'is a parent of' from the Relationship Type drop-down box.

     Leave Descriptive Prefix blank.

     Note that Logical View Name is disabled.  The impact of this will be shown later.

     Click the OK button.

4.  The model diagram will be updated and the Order and Ordered Product entities will appear something like this:

     Note the following about the updated diagram:

• The Ordered Product entity has inherited the identifying element of Order Number, which is now an identifier of Ordered Product.

• The Ordered Product's Order Number is denoted as being an inherited identifier by an asterisk in brackets to its right.

• The full impact of the relationship on the two entities will be shown and discussed further in a later tutorial, where these entities will be built.