Introduction

Welcome to ERD Fundamentals. In this chapter we will learn about all the key techniques and principles to create our first ERD in PhixFlow, that models the data in our application.

Concepts

To find out more about the key concepts for Entity Relationship Diagrams before you take the course below, or simply to refresh your memory, see Entity Relationship Diagrams.

Video

Demonstration 

Watch the video demonstration, then complete the Fundamentals Tasks below.

Fundamentals Tasks

Complete the tasks below, before moving to the next chapter. 

Task 1: Download Learning Centre Files

1. Access the Learning Centre using the Help link in the top right corner of PhixFlow or via Learning Centre  
   1. Image RemovedImage Added
2. Scroll to the bottom of the webpage and in the Sample Datasets section, download the files:
   • Companies
   • Employees
   • ISO Country Codes

Task 2: Create the ERD

1. Select 

   Insert excerpt
   _erd _erd nopanel true

    from the PhixFlow home page
2. Click 

   Insert excerpt
   _add _add nopanel true

    
3. On the Create ERD window that appears, enter the name, Data, and select Create

Task 3: Add Data to the ERD

1. Add a new blank table from the toolbar by clicking and dragging the 

   Insert excerpt
   _tables _tables nopanel true

    icon onto the canvas
   1. On the Create Table window that appears, enter the name, Status, and select Confirm
2. Add a new table tables from an excel file by opening the file location on your PC or laptop, and files by dragging the files you downloaded from the Learning Centre in Task 1 from your PC or laptop onto the canvas
3. On the Companies table:
   1. Set the

      Insert excerpt
      _key_primary _key_primary nopanel true

       by right-clicking on the CompanyID attribute and selecting

      Insert excerpt
      _key_primary_set _key_primary_set nopanel true

   2. Set the 

      Insert excerpt
      _display_name _display_name nopanel true

       by right-clicking on the CompanyName attribute and selecting 

      Insert excerpt
      _display_name_make _display_name_make nopanel true

4. Repeat these steps on the Employees table:
   1. Set the EmployeeID attribute as the

      Insert excerpt
      _key_primary _key_primary nopanel true

       
   2. Set the first_name attribute as the 

      Insert excerpt
      _display_name _display_name nopanel true

       
5. On the ISOCountryCodes table:
   
   1. Set the CountryCode attribute as the 

      Insert excerpt
      _key_primary _key_primary nopanel true

   2. Set the CountryName attribute as the 

      Insert excerpt
      _display_name _display_name nopanel true

Task 4: Create Relationships Between the Tables

1. Click on the CompanyID attribute on the Companies table, and while holding down your mouse, a red relationship line will appear
   1. Release your mouse-click when it is hovering over the CompanyID attribute on the Employees table
   2. A line will appear to represent the relationship created
2. Repeat these steps to create a relationship line from the CountryCode attribute on the ISOCountryCodes table to the CountryCode attribute on the Companies table

Image Added

Further Reading (Optional)

For more information on the topics covered in this chapter, see the below links.

• Entity Relationship Diagrams
• Adding Data and Tables to an ERD