Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 33 Next »

ERD Fundamentals

 Overview

PhixFlow  Entity-Relationship Diagrams (ERDs) define the logical structure of the data in your application. "Entities" represent the things in the world that you want to represent as data. Defining the data for your application is considered the first step in your design.

The following example shows an ERD for a school. The school has entities: departments, teachers, students, classrooms and so on. All these entities are represented as tables and the lines connecting them show their relationships to one another. We can see from this a School Department has many Class Rooms and Teachers. This is covered in more detail in Understanding ERDs and Views. 


ERD Page Layout

Here is a simplified view of the ERD editor.

  1. The Toolbar provides ERD specific options, such as displaying the available table that can be added to your ERD and options for creating new table.
  2. The Repository browser, can list all of the available tables in your application and any associated packages. Select Tables from the toolbar to display this area. 
  3. The Canvas area where the ERD will be configured. Tables can be added by:
    1. Dragging Table from the create menu of the toolbar onto the canvas.
    2. Clicking Tables from the list menu of the toolbar and dragging a table from the repository onto the canvas.
    3. Excel documents can be dragged directly onto the canvas and will be imported automatically.
  4. The Tables and Relationships, are displayed on the canvas. A Table Shows all of the attributes it contains within it and the data type. A relationship between two tables is displayed as a line connecting the primary key of one table to a foreign key of a second table. This is discussed in more detail in Relationships.



Already Have Data?

If you already have data that you wish to import into PhixFlow, such as a database of customers, you will need to use an Analysis model.

Analysis Models will allow you to configure connectors to access your existing data sources and store the data as tables in PhixFlow's own database. You can also set up more bulk processes to manipulate large volumes of data before it is presented to your users; see Analysis Model.

What Next?

Understanding ERDs and Views covers ERDs in more depth to help you design your own ERDs and views to display your data.



  • No labels