4. Visualise table relationships

The Curiosity Enterprise Test Data Platform also lets you visualise the table relationships within the definition. This includes foreign key relationships and soft keys uncovered as part of the discovery process. 

To visualise table relationships within a definition: 

1. Click on the tree icon in to view diagram and choose the type of diagram you want to create. For this example, please select 'Entity Relationship Diagram':

   
   

2. The diagram will then be generated:

   This will present the existing found relationships that need to be considered and used to maintain referential integrity in your data activities and test data pipelines.Here's a closer look at the diagram: 

   

3. In the top right, additional actions are available:

   

   These include, from left to right: 

   1. Toggle collapse / Expand the image

   2. Settings

   3. Relayout

   4. Download as .png

   5. Search

   6. Zoom in / Zoom out

   7. Fit to screen

4. Configure your settings 

   Some databases & files have large structures and table amounts/column amounts. Settings allow you to customise what is displayed and how much based on various configurations. The number of tables displayed and the columns you wish to see, should be configured here for an easier viewing experience when looking at large databases.
   
   

Exercise 4

1. From the definition you created in Exercise 3, try to create one of each type of the following diagrams:
   1. Entity relationship
   2. Radial Partition
   3. Radial Layer

Need help or want to check your work? Check the solution video here.

Further learning:

For further information on the Data Dictionary and Definition structures, visit our Knowledge Base to see the documentation: https://knowledge.curiositysoftware.ie/docs/data-dictionary-definition-structure

Proceed to Section 5 - Set up the database scan activity >