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 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 Data model with group"
   
   

   Note:

   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.