Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Preview
Start a free Courses trial
to watch this video
In this lesson, we will build on the information we learned about Keys and Constraints to explain the concept of linking, or relating, tables in a database system.
One to Many relationships are by far the most common type of table relationship. There is a wealth of information about One to Many relationships available.
Here are a few of the links we find most helpful:
[MUSIC]
0:00
In the previous stages, we learnt about
the high level concepts such as database
0:04
normalization and set theory.
0:08
We also learned about database keys and
0:11
how they are used to create
database relationships.
0:13
Now, we're going to explore table
relationships more in depth.
0:17
There are three types of
relationships between tables.
0:21
They are called one to one,
one to many, and many to many.
0:24
These types are described by how many
rows can be related to each other
0:29
on either side of the relationship.
0:33
One to many relationships are by far
the most common type of relationship,
0:36
that you'll encounter in database design.
0:40
This type of relationship means that one
row in one table can be related to many
0:43
rows in another table at the other side
of the relationship, but not vice versa.
0:48
The many can only happen in one direction.
0:53
Take this Sales Table for example,
0:57
it has a foreign key to the product
table on the column ProductID.
0:59
When describing this relationship you
could say, a Sale has 1 product but
1:04
a Product can be a many sales.
1:09
If you ever get confused as to
which side is the foreign key,
1:12
an easy trick to remember is that the
foreign key always goes on the many side.
1:17
In this example there are many instances
of the ProductID, 145 on the Sale Table.
1:22
That's the many side,
thus that's the foreign key.
1:29
In our next video, we'll take a look
at the next type of relationship.
1:33
You need to sign up for Treehouse in order to download course files.
Sign up