RelationalDBDesignRelationalDBDesign


Database Analysis   «Prev  Next»

Create an equi-join - Exercise

Types of Joins, part 2


Create an equi-join


Objective: Create an equi-join based on records from two tables.

This is a Javascript Matching Exercise


This exercise uses a Javascript to allow you to match items in the left column with the items in the right column.
In the left column below are six records from the Customer table and their corresponding records from the Order table in the right column. Click a record in the left column, then click the corresponding record in the right column to create an equi-join between the two tables.
When you have matched all of the Customer and Order records, click the Done button to see if you have matched the terms correctly. Green lines mean the match is correct, red lines mean the match is incorrect. If you did not get the matches right the first time, click Clear to erase your matches and try again.
When you have completed the exercise, click the Done button to see the correct answers.

Exercise Scoring

You will receive two points for this exercise. The exercise is auto-scored. When you have completed the exercise, click the Done button to receive full credit.