Creating Data Relationships

In this lesson, you will learn how to create data relationships between two tables by linking them together.

Warning: Your screen size is quite small for viewing this. Rotate your device into landscape mode if you can.

1 Setup
2 Identify the Relationship
3 Create a Link Column
4 Add Data to Link Column
5 Test the Relationship
6 Refine the Relationship
7 Explore the Relationship
8 Reflect on the Process
Quiz

1 - Setup

Go to www.example.com and create a new project called 'Data Relationships'. Make sure you have two tables ready: 'Table 1' and 'Table 2'.

👇 Mark your steps as done as you complete them.

+10 XP

2 - Identify the Relationship

Think about the relationship between the two tables. For example, if 'Table 1' contains information about students and 'Table 2' contains information about classes, the relationship could be that each student is enrolled in one or more classes.

👇 Mark your steps as done as you complete them.

+15 XP

3 - Create a Link Column

In 'Table 1', create a new column called 'Link Column'. This column will store the unique identifier (ID) from 'Table 2' to establish the relationship between the two tables.

+20 XP

4 - Add Data to Link Column

For each row in 'Table 1', add the corresponding unique identifier (ID) from 'Table 2' to the 'Link Column'. This will create a connection between the data in both tables.

+20 XP

123learn · Online learning platform

Unlock the full learning experience

You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.

Hundreds of curriculum-aligned lessons

Interactive activities in every lesson

Printable resources & progress tracking

Get started

Copyright Notice
This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.