41.4 Refine the Data Model

In this section, you will rename some of the objects in the data model so that they have more meaningful names. You will also create a break group.

To refine the data model:

  1. In the Data Model view, drag the title bar of the group G_EMPLOYEE_ID down about 4 inches (10 centimeters) to move the entire group.

  2. Click and drag the column named JOB_ID out of and above G_EMPLOYEE_ID to create a new break group, as shown in the following figure:

    Figure 41-4 Query with group

    Description of Figure 41-4 follows
    Description of "Figure 41-4 Query with group"

  3. Double-click the title bar of the new group that contains JOB_ID to display the Property Inspector, and set the following properties:

    • Under the General Information node, set the Name property to G_conlabel.

  4. In the Data Model view, your data model should look similar to the following:

    Figure 41-5 Data model with group

    Description of Figure 41-5 follows
    Description of "Figure 41-5 Data model with group"


    You can open the provided file ref_emp63.rdf and display the Data Model to compare your results.
  5. Save the report as ref_63_yourinitials.rdf.