WEBVTT
Kind: captions
Language: en

00:00:06.770 --> 00:00:09.500 align:start position:0%
 
this<00:00:07.770><c> lesson</c><00:00:08.250><c> is</c><00:00:08.370><c> all</c><00:00:08.490><c> about</c><00:00:08.550><c> relationships</c>

00:00:09.500 --> 00:00:09.510 align:start position:0%
this lesson is all about relationships
 

00:00:09.510 --> 00:00:12.110 align:start position:0%
this lesson is all about relationships
the<00:00:10.080><c> tables</c><00:00:10.559><c> that</c><00:00:10.650><c> we</c><00:00:10.800><c> created</c><00:00:11.309><c> are</c><00:00:11.429><c> only</c><00:00:11.790><c> good</c>

00:00:12.110 --> 00:00:12.120 align:start position:0%
the tables that we created are only good
 

00:00:12.120 --> 00:00:14.209 align:start position:0%
the tables that we created are only good
if<00:00:12.389><c> they</c><00:00:12.540><c> are</c><00:00:12.570><c> linked</c><00:00:13.139><c> we</c><00:00:13.710><c> said</c><00:00:14.009><c> that</c><00:00:14.190><c> a</c>

00:00:14.209 --> 00:00:14.219 align:start position:0%
if they are linked we said that a
 

00:00:14.219 --> 00:00:17.060 align:start position:0%
if they are linked we said that a
customer<00:00:14.759><c> comes</c><00:00:15.000><c> to</c><00:00:15.089><c> our</c><00:00:15.299><c> store</c><00:00:15.780><c> and</c><00:00:16.049><c> finds</c><00:00:17.010><c> a</c>

00:00:17.060 --> 00:00:17.070 align:start position:0%
customer comes to our store and finds a
 

00:00:17.070 --> 00:00:20.529 align:start position:0%
customer comes to our store and finds a
book<00:00:17.279><c> and</c><00:00:17.760><c> then</c><00:00:17.910><c> makes</c><00:00:18.090><c> a</c><00:00:18.210><c> purchase</c>

00:00:20.529 --> 00:00:20.539 align:start position:0%
book and then makes a purchase
 

00:00:20.539 --> 00:00:23.329 align:start position:0%
book and then makes a purchase
we<00:00:21.539><c> have</c><00:00:21.720><c> our</c><00:00:21.869><c> tables</c><00:00:22.470><c> that</c><00:00:22.560><c> show</c><00:00:22.619><c> us</c><00:00:23.009><c> what</c>

00:00:23.329 --> 00:00:23.339 align:start position:0%
we have our tables that show us what
 

00:00:23.339 --> 00:00:25.640 align:start position:0%
we have our tables that show us what
information<00:00:23.970><c> we</c><00:00:24.060><c> plan</c><00:00:24.329><c> to</c><00:00:24.539><c> gather</c><00:00:24.750><c> and</c><00:00:25.109><c> store</c>

00:00:25.640 --> 00:00:25.650 align:start position:0%
information we plan to gather and store
 

00:00:25.650 --> 00:00:28.670 align:start position:0%
information we plan to gather and store
in<00:00:25.980><c> each</c><00:00:26.160><c> table</c><00:00:26.810><c> now</c><00:00:27.810><c> we</c><00:00:27.839><c> just</c><00:00:28.169><c> need</c><00:00:28.230><c> a</c><00:00:28.380><c> way</c><00:00:28.649><c> to</c>

00:00:28.670 --> 00:00:28.680 align:start position:0%
in each table now we just need a way to
 

00:00:28.680 --> 00:00:30.229 align:start position:0%
in each table now we just need a way to
create<00:00:29.009><c> a</c><00:00:29.130><c> relationship</c><00:00:29.669><c> between</c><00:00:29.820><c> these</c>

00:00:30.229 --> 00:00:30.239 align:start position:0%
create a relationship between these
 

00:00:30.239 --> 00:00:32.749 align:start position:0%
create a relationship between these
tables<00:00:30.949><c> here's</c><00:00:31.949><c> the</c><00:00:32.099><c> database</c><00:00:32.489><c> we're</c>

00:00:32.749 --> 00:00:32.759 align:start position:0%
tables here's the database we're
 

00:00:32.759 --> 00:00:34.670 align:start position:0%
tables here's the database we're
currently<00:00:32.969><c> working</c><00:00:33.149><c> on</c><00:00:33.600><c> now</c><00:00:34.230><c> I</c><00:00:34.260><c> want</c><00:00:34.500><c> you</c><00:00:34.590><c> to</c>

00:00:34.670 --> 00:00:34.680 align:start position:0%
currently working on now I want you to
 

00:00:34.680 --> 00:00:36.530 align:start position:0%
currently working on now I want you to
notice<00:00:34.890><c> that</c><00:00:35.100><c> none</c><00:00:35.399><c> of</c><00:00:35.430><c> our</c><00:00:35.610><c> tables</c><00:00:36.000><c> are</c><00:00:36.090><c> open</c>

00:00:36.530 --> 00:00:36.540 align:start position:0%
notice that none of our tables are open
 

00:00:36.540 --> 00:00:39.619 align:start position:0%
notice that none of our tables are open
that's<00:00:37.470><c> because</c><00:00:37.980><c> all</c><00:00:38.339><c> of</c><00:00:38.400><c> the</c><00:00:38.699><c> tables</c><00:00:39.120><c> must</c><00:00:39.390><c> be</c>

00:00:39.619 --> 00:00:39.629 align:start position:0%
that's because all of the tables must be
 

00:00:39.629 --> 00:00:41.930 align:start position:0%
that's because all of the tables must be
closed<00:00:40.019><c> in</c><00:00:40.379><c> order</c><00:00:40.620><c> to</c><00:00:40.890><c> create</c><00:00:41.100><c> relationships</c>

00:00:41.930 --> 00:00:41.940 align:start position:0%
closed in order to create relationships
 

00:00:41.940 --> 00:00:44.329 align:start position:0%
closed in order to create relationships
let's<00:00:42.899><c> start</c><00:00:43.110><c> creating</c><00:00:43.260><c> relationships</c><00:00:43.620><c> by</c>

00:00:44.329 --> 00:00:44.339 align:start position:0%
let's start creating relationships by
 

00:00:44.339 --> 00:00:47.350 align:start position:0%
let's start creating relationships by
clicking<00:00:44.760><c> on</c><00:00:44.879><c> the</c><00:00:44.970><c> database</c><00:00:45.390><c> tools</c><00:00:45.690><c> tab</c><00:00:45.870><c> and</c>

00:00:47.350 --> 00:00:47.360 align:start position:0%
clicking on the database tools tab and
 

00:00:47.360 --> 00:00:51.979 align:start position:0%
clicking on the database tools tab and
relationships<00:00:48.360><c> in</c><00:00:48.629><c> the</c><00:00:49.260><c> show/hide</c><00:00:49.829><c> group</c><00:00:50.989><c> the</c>

00:00:51.979 --> 00:00:51.989 align:start position:0%
relationships in the show/hide group the
 

00:00:51.989 --> 00:00:54.290 align:start position:0%
relationships in the show/hide group the
show<00:00:52.290><c> table</c><00:00:52.769><c> dialog</c><00:00:53.190><c> box</c><00:00:53.550><c> will</c><00:00:53.760><c> appear</c><00:00:53.789><c> and</c>

00:00:54.290 --> 00:00:54.300 align:start position:0%
show table dialog box will appear and
 

00:00:54.300 --> 00:00:57.110 align:start position:0%
show table dialog box will appear and
from<00:00:55.050><c> here</c><00:00:55.559><c> you</c><00:00:55.920><c> can</c><00:00:56.070><c> choose</c><00:00:56.309><c> which</c><00:00:56.579><c> tables</c>

00:00:57.110 --> 00:00:57.120 align:start position:0%
from here you can choose which tables
 

00:00:57.120 --> 00:00:59.900 align:start position:0%
from here you can choose which tables
you<00:00:57.210><c> want</c><00:00:57.359><c> to</c><00:00:57.480><c> relate</c><00:00:58.280><c> let's</c><00:00:59.280><c> go</c><00:00:59.429><c> ahead</c><00:00:59.579><c> and</c>

00:00:59.900 --> 00:00:59.910 align:start position:0%
you want to relate let's go ahead and
 

00:00:59.910 --> 00:01:01.639 align:start position:0%
you want to relate let's go ahead and
add<00:01:00.030><c> our</c><00:01:00.059><c> tables</c><00:01:00.660><c> by</c><00:01:00.780><c> clicking</c><00:01:01.199><c> on</c><00:01:01.320><c> each</c><00:01:01.620><c> one</c>

00:01:01.639 --> 00:01:01.649 align:start position:0%
add our tables by clicking on each one
 

00:01:01.649 --> 00:01:09.289 align:start position:0%
add our tables by clicking on each one
and<00:01:02.309><c> then</c><00:01:02.910><c> the</c><00:01:03.120><c> Add</c><00:01:03.269><c> button</c>

00:01:09.289 --> 00:01:09.299 align:start position:0%
 
 

00:01:09.299 --> 00:01:13.289 align:start position:0%
 
now<00:01:10.299><c> click</c><00:01:10.690><c> close</c><00:01:11.549><c> this</c><00:01:12.549><c> table</c><00:01:12.850><c> should</c><00:01:13.180><c> be</c><00:01:13.210><c> a</c>

00:01:13.289 --> 00:01:13.299 align:start position:0%
now click close this table should be a
 

00:01:13.299 --> 00:01:15.060 align:start position:0%
now click close this table should be a
flashback<00:01:14.020><c> to</c><00:01:14.170><c> our</c><00:01:14.290><c> tables</c><00:01:14.770><c> and</c><00:01:14.950><c> fields</c>

00:01:15.060 --> 00:01:15.070 align:start position:0%
flashback to our tables and fields
 

00:01:15.070 --> 00:01:19.350 align:start position:0%
flashback to our tables and fields
diagram<00:01:16.530><c> I'm</c><00:01:17.610><c> going</c><00:01:18.610><c> to</c><00:01:18.729><c> move</c><00:01:18.850><c> the</c><00:01:19.000><c> tables</c>

00:01:19.350 --> 00:01:19.360 align:start position:0%
diagram I'm going to move the tables
 

00:01:19.360 --> 00:01:20.880 align:start position:0%
diagram I'm going to move the tables
around<00:01:19.600><c> a</c><00:01:19.780><c> bit</c><00:01:19.930><c> to</c><00:01:20.080><c> put</c><00:01:20.259><c> them</c><00:01:20.409><c> in</c><00:01:20.530><c> the</c><00:01:20.619><c> same</c>

00:01:20.880 --> 00:01:20.890 align:start position:0%
around a bit to put them in the same
 

00:01:20.890 --> 00:01:23.609 align:start position:0%
around a bit to put them in the same
order<00:01:21.130><c> as</c><00:01:21.580><c> the</c><00:01:21.729><c> ones</c><00:01:22.000><c> in</c><00:01:22.119><c> our</c><00:01:22.270><c> diagram</c><00:01:22.590><c> you</c><00:01:23.590><c> can</c>

00:01:23.609 --> 00:01:23.619 align:start position:0%
order as the ones in our diagram you can
 

00:01:23.619 --> 00:01:25.859 align:start position:0%
order as the ones in our diagram you can
do<00:01:23.950><c> this</c><00:01:24.130><c> by</c><00:01:24.280><c> simply</c><00:01:24.610><c> left</c><00:01:25.149><c> clicking</c><00:01:25.600><c> on</c><00:01:25.810><c> a</c>

00:01:25.859 --> 00:01:25.869 align:start position:0%
do this by simply left clicking on a
 

00:01:25.869 --> 00:01:33.289 align:start position:0%
do this by simply left clicking on a
table<00:01:26.380><c> and</c><00:01:26.790><c> dragging</c><00:01:27.790><c> it</c><00:01:27.909><c> to</c><00:01:27.940><c> a</c><00:01:28.210><c> new</c><00:01:28.390><c> location</c>

00:01:33.289 --> 00:01:33.299 align:start position:0%
 
 

00:01:33.299 --> 00:01:36.030 align:start position:0%
 
you'll<00:01:34.299><c> notice</c><00:01:34.720><c> that</c><00:01:34.810><c> the</c><00:01:34.960><c> first</c><00:01:35.259><c> field</c><00:01:35.680><c> under</c>

00:01:36.030 --> 00:01:36.040 align:start position:0%
you'll notice that the first field under
 

00:01:36.040 --> 00:01:38.010 align:start position:0%
you'll notice that the first field under
each<00:01:36.280><c> one</c><00:01:36.640><c> of</c><00:01:36.790><c> these</c><00:01:36.880><c> tables</c><00:01:37.210><c> has</c><00:01:37.659><c> a</c><00:01:37.690><c> little</c>

00:01:38.010 --> 00:01:38.020 align:start position:0%
each one of these tables has a little
 

00:01:38.020 --> 00:01:40.800 align:start position:0%
each one of these tables has a little
key<00:01:38.259><c> icon</c><00:01:38.740><c> that</c><00:01:39.430><c> this</c><00:01:39.640><c> is</c><00:01:39.850><c> the</c><00:01:39.940><c> primary</c><00:01:40.299><c> key</c>

00:01:40.800 --> 00:01:40.810 align:start position:0%
key icon that this is the primary key
 

00:01:40.810 --> 00:01:43.770 align:start position:0%
key icon that this is the primary key
field<00:01:41.140><c> the</c><00:01:41.860><c> primary</c><00:01:42.490><c> key</c><00:01:42.759><c> field</c><00:01:43.060><c> is</c><00:01:43.330><c> the</c><00:01:43.450><c> first</c>

00:01:43.770 --> 00:01:43.780 align:start position:0%
field the primary key field is the first
 

00:01:43.780 --> 00:01:47.249 align:start position:0%
field the primary key field is the first
field<00:01:44.380><c> in</c><00:01:44.770><c> each</c><00:01:45.610><c> table</c><00:01:46.420><c> of</c><00:01:46.570><c> our</c><00:01:46.690><c> database</c>

00:01:47.249 --> 00:01:47.259 align:start position:0%
field in each table of our database
 

00:01:47.259 --> 00:01:50.399 align:start position:0%
field in each table of our database
which<00:01:48.159><c> we</c><00:01:48.340><c> previously</c><00:01:48.640><c> said</c><00:01:49.300><c> was</c><00:01:49.810><c> a</c><00:01:49.840><c> unique</c>

00:01:50.399 --> 00:01:50.409 align:start position:0%
which we previously said was a unique
 

00:01:50.409 --> 00:01:52.980 align:start position:0%
which we previously said was a unique
identifier<00:01:51.310><c> of</c><00:01:51.610><c> Records</c><00:01:52.090><c> in</c><00:01:52.300><c> that</c><00:01:52.570><c> particular</c>

00:01:52.980 --> 00:01:52.990 align:start position:0%
identifier of Records in that particular
 

00:01:52.990 --> 00:01:57.270 align:start position:0%
identifier of Records in that particular
table<00:01:54.690><c> for</c><00:01:55.690><c> example</c><00:01:56.229><c> we</c><00:01:56.619><c> could</c><00:01:56.890><c> have</c><00:01:57.069><c> two</c>

00:01:57.270 --> 00:01:57.280 align:start position:0%
table for example we could have two
 

00:01:57.280 --> 00:01:59.580 align:start position:0%
table for example we could have two
customers<00:01:57.550><c> with</c><00:01:58.210><c> the</c><00:01:58.330><c> same</c><00:01:58.630><c> name</c><00:01:58.990><c> let's</c><00:01:59.470><c> say</c>

00:01:59.580 --> 00:01:59.590 align:start position:0%
customers with the same name let's say
 

00:01:59.590 --> 00:02:02.040 align:start position:0%
customers with the same name let's say
Mary<00:02:00.039><c> Jones</c><00:02:00.399><c> but</c><00:02:01.119><c> because</c><00:02:01.569><c> they</c><00:02:01.750><c> are</c><00:02:01.869><c> being</c>

00:02:02.040 --> 00:02:02.050 align:start position:0%
Mary Jones but because they are being
 

00:02:02.050 --> 00:02:04.620 align:start position:0%
Mary Jones but because they are being
identified<00:02:02.229><c> with</c><00:02:03.069><c> their</c><00:02:03.220><c> customer</c><00:02:03.729><c> ID</c><00:02:03.940><c> number</c>

00:02:04.620 --> 00:02:04.630 align:start position:0%
identified with their customer ID number
 

00:02:04.630 --> 00:02:07.469 align:start position:0%
identified with their customer ID number
the<00:02:05.170><c> database</c><00:02:05.679><c> always</c><00:02:06.220><c> knows</c><00:02:06.490><c> which</c><00:02:06.880><c> customer</c>

00:02:07.469 --> 00:02:07.479 align:start position:0%
the database always knows which customer
 

00:02:07.479 --> 00:02:10.529 align:start position:0%
the database always knows which customer
is<00:02:07.600><c> which</c><00:02:07.840><c> that</c><00:02:08.679><c> is</c><00:02:08.860><c> why</c><00:02:09.009><c> customer</c><00:02:09.340><c> ID</c><00:02:09.819><c> is</c><00:02:10.390><c> the</c>

00:02:10.529 --> 00:02:10.539 align:start position:0%
is which that is why customer ID is the
 

00:02:10.539 --> 00:02:13.740 align:start position:0%
is which that is why customer ID is the
primary<00:02:10.569><c> key</c><00:02:11.230><c> it</c><00:02:11.739><c> ensures</c><00:02:12.610><c> us</c><00:02:12.730><c> that</c><00:02:13.060><c> each</c><00:02:13.269><c> Mary</c>

00:02:13.740 --> 00:02:13.750 align:start position:0%
primary key it ensures us that each Mary
 

00:02:13.750 --> 00:02:19.410 align:start position:0%
primary key it ensures us that each Mary
Jones<00:02:14.200><c> is</c><00:02:14.590><c> tracked</c><00:02:14.950><c> separately</c><00:02:18.209><c> so</c><00:02:19.209><c> in</c><00:02:19.329><c> the</c>

00:02:19.410 --> 00:02:19.420 align:start position:0%
Jones is tracked separately so in the
 

00:02:19.420 --> 00:02:21.539 align:start position:0%
Jones is tracked separately so in the
customers<00:02:19.959><c> table</c><00:02:20.230><c> the</c><00:02:20.650><c> primary</c><00:02:21.130><c> key</c><00:02:21.400><c> is</c>

00:02:21.539 --> 00:02:21.549 align:start position:0%
customers table the primary key is
 

00:02:21.549 --> 00:02:24.330 align:start position:0%
customers table the primary key is
customer<00:02:22.060><c> ID</c><00:02:22.269><c> in</c><00:02:22.720><c> the</c><00:02:23.260><c> orders</c><00:02:23.680><c> table</c><00:02:23.980><c> the</c>

00:02:24.330 --> 00:02:24.340 align:start position:0%
customer ID in the orders table the
 

00:02:24.340 --> 00:02:27.090 align:start position:0%
customer ID in the orders table the
primary<00:02:24.790><c> key</c><00:02:25.000><c> is</c><00:02:25.150><c> order</c><00:02:25.510><c> ID</c><00:02:25.720><c> and</c><00:02:26.170><c> in</c><00:02:26.769><c> the</c><00:02:26.860><c> books</c>

00:02:27.090 --> 00:02:27.100 align:start position:0%
primary key is order ID and in the books
 

00:02:27.100 --> 00:02:31.259 align:start position:0%
primary key is order ID and in the books
table<00:02:27.310><c> its</c><00:02:27.730><c> book</c><00:02:28.120><c> ID</c><00:02:28.360><c> if</c><00:02:29.459><c> you</c><00:02:30.459><c> look</c><00:02:30.670><c> closely</c><00:02:31.030><c> at</c>

00:02:31.259 --> 00:02:31.269 align:start position:0%
table its book ID if you look closely at
 

00:02:31.269 --> 00:02:33.180 align:start position:0%
table its book ID if you look closely at
the<00:02:31.570><c> orders</c><00:02:31.930><c> table</c><00:02:32.170><c> you'll</c><00:02:32.650><c> notice</c><00:02:33.070><c> that</c>

00:02:33.180 --> 00:02:33.190 align:start position:0%
the orders table you'll notice that
 

00:02:33.190 --> 00:02:36.960 align:start position:0%
the orders table you'll notice that
customer<00:02:33.730><c> ID</c><00:02:33.940><c> and</c><00:02:34.420><c> book</c><00:02:35.049><c> ID</c><00:02:35.350><c> are</c><00:02:35.799><c> listed</c><00:02:36.700><c> but</c>

00:02:36.960 --> 00:02:36.970 align:start position:0%
customer ID and book ID are listed but
 

00:02:36.970 --> 00:02:39.030 align:start position:0%
customer ID and book ID are listed but
you<00:02:37.150><c> don't</c><00:02:37.359><c> see</c><00:02:37.600><c> a</c><00:02:37.630><c> key</c><00:02:37.900><c> beside</c><00:02:38.260><c> them</c><00:02:38.530><c> now</c>

00:02:39.030 --> 00:02:39.040 align:start position:0%
you don't see a key beside them now
 

00:02:39.040 --> 00:02:40.440 align:start position:0%
you don't see a key beside them now
that's<00:02:39.250><c> because</c><00:02:39.670><c> they</c><00:02:39.850><c> are</c><00:02:40.000><c> considered</c>

00:02:40.440 --> 00:02:40.450 align:start position:0%
that's because they are considered
 

00:02:40.450 --> 00:02:42.990 align:start position:0%
that's because they are considered
foreign<00:02:40.840><c> keys</c><00:02:41.320><c> which</c><00:02:41.950><c> just</c><00:02:42.310><c> means</c><00:02:42.640><c> that</c><00:02:42.850><c> these</c>

00:02:42.990 --> 00:02:43.000 align:start position:0%
foreign keys which just means that these
 

00:02:43.000 --> 00:02:45.420 align:start position:0%
foreign keys which just means that these
fields<00:02:43.540><c> are</c><00:02:43.660><c> the</c><00:02:43.750><c> primary</c><00:02:44.320><c> keys</c><00:02:44.650><c> in</c><00:02:45.070><c> other</c>

00:02:45.420 --> 00:02:45.430 align:start position:0%
fields are the primary keys in other
 

00:02:45.430 --> 00:02:48.690 align:start position:0%
fields are the primary keys in other
tables<00:02:46.859><c> now</c><00:02:47.859><c> that's</c><00:02:48.040><c> enough</c><00:02:48.370><c> to</c><00:02:48.459><c> make</c><00:02:48.489><c> your</c>

00:02:48.690 --> 00:02:48.700 align:start position:0%
tables now that's enough to make your
 

00:02:48.700 --> 00:02:53.400 align:start position:0%
tables now that's enough to make your
head<00:02:48.910><c> spin</c><00:02:49.120><c> so</c><00:02:49.630><c> stay</c><00:02:49.900><c> with</c><00:02:50.109><c> me</c><00:02:52.049><c> so</c><00:02:53.049><c> we've</c><00:02:53.230><c> got</c>

00:02:53.400 --> 00:02:53.410 align:start position:0%
head spin so stay with me so we've got
 

00:02:53.410 --> 00:02:55.440 align:start position:0%
head spin so stay with me so we've got
our<00:02:53.590><c> tables</c><00:02:54.040><c> in</c><00:02:54.190><c> the</c><00:02:54.280><c> order</c><00:02:54.579><c> we</c><00:02:54.730><c> want</c><00:02:54.910><c> them</c><00:02:55.180><c> in</c>

00:02:55.440 --> 00:02:55.450 align:start position:0%
our tables in the order we want them in
 

00:02:55.450 --> 00:02:56.970 align:start position:0%
our tables in the order we want them in
and<00:02:55.690><c> now</c><00:02:55.930><c> it's</c><00:02:56.170><c> time</c><00:02:56.350><c> to</c><00:02:56.380><c> create</c><00:02:56.709><c> the</c>

00:02:56.970 --> 00:02:56.980 align:start position:0%
and now it's time to create the
 

00:02:56.980 --> 00:02:58.490 align:start position:0%
and now it's time to create the
relationships<00:02:57.640><c> we've</c><00:02:57.850><c> been</c><00:02:58.000><c> talking</c><00:02:58.359><c> about</c>

00:02:58.490 --> 00:02:58.500 align:start position:0%
relationships we've been talking about
 

00:02:58.500 --> 00:03:01.590 align:start position:0%
relationships we've been talking about
we<00:02:59.500><c> could</c><00:02:59.859><c> use</c><00:03:00.190><c> edit</c><00:03:00.609><c> relationships</c><00:03:01.329><c> from</c><00:03:01.540><c> the</c>

00:03:01.590 --> 00:03:01.600 align:start position:0%
we could use edit relationships from the
 

00:03:01.600 --> 00:03:04.140 align:start position:0%
we could use edit relationships from the
ribbon<00:03:02.049><c> but</c><00:03:02.440><c> it's</c><00:03:02.620><c> much</c><00:03:02.920><c> much</c><00:03:03.250><c> easier</c><00:03:03.820><c> to</c><00:03:03.970><c> just</c>

00:03:04.140 --> 00:03:04.150 align:start position:0%
ribbon but it's much much easier to just
 

00:03:04.150 --> 00:03:06.360 align:start position:0%
ribbon but it's much much easier to just
drag<00:03:04.540><c> and</c><00:03:04.840><c> drop</c><00:03:04.900><c> from</c><00:03:05.440><c> one</c><00:03:05.709><c> table</c><00:03:05.980><c> to</c><00:03:06.160><c> the</c>

00:03:06.360 --> 00:03:06.370 align:start position:0%
drag and drop from one table to the
 

00:03:06.370 --> 00:03:08.789 align:start position:0%
drag and drop from one table to the
other<00:03:06.549><c> it's</c><00:03:07.450><c> a</c><00:03:07.660><c> good</c><00:03:07.900><c> thing</c><00:03:08.170><c> we</c><00:03:08.320><c> called</c><00:03:08.590><c> our</c>

00:03:08.789 --> 00:03:08.799 align:start position:0%
other it's a good thing we called our
 

00:03:08.799 --> 00:03:11.580 align:start position:0%
other it's a good thing we called our
IDs<00:03:09.280><c> customer</c><00:03:10.000><c> ID</c><00:03:10.150><c> book</c><00:03:10.660><c> ID</c><00:03:10.870><c> and</c><00:03:11.140><c> order</c><00:03:11.410><c> ID</c>

00:03:11.580 --> 00:03:11.590 align:start position:0%
IDs customer ID book ID and order ID
 

00:03:11.590 --> 00:03:14.009 align:start position:0%
IDs customer ID book ID and order ID
earlier<00:03:11.739><c> this</c><00:03:12.670><c> just</c><00:03:12.940><c> makes</c><00:03:13.180><c> it</c><00:03:13.299><c> easier</c><00:03:13.720><c> to</c><00:03:13.780><c> see</c>

00:03:14.009 --> 00:03:14.019 align:start position:0%
earlier this just makes it easier to see
 

00:03:14.019 --> 00:03:16.770 align:start position:0%
earlier this just makes it easier to see
the<00:03:14.140><c> fields</c><00:03:14.560><c> we</c><00:03:14.680><c> want</c><00:03:14.859><c> to</c><00:03:15.040><c> join</c><00:03:15.250><c> if</c><00:03:15.609><c> we</c><00:03:16.269><c> didn't</c>

00:03:16.770 --> 00:03:16.780 align:start position:0%
the fields we want to join if we didn't
 

00:03:16.780 --> 00:03:18.540 align:start position:0%
the fields we want to join if we didn't
name<00:03:16.930><c> them</c><00:03:17.170><c> this</c><00:03:17.319><c> way</c><00:03:17.560><c> we</c><00:03:18.040><c> would</c><00:03:18.220><c> just</c><00:03:18.400><c> have</c>

00:03:18.540 --> 00:03:18.550 align:start position:0%
name them this way we would just have
 

00:03:18.550 --> 00:03:22.300 align:start position:0%
name them this way we would just have
several<00:03:18.970><c> fields</c><00:03:19.360><c> named</c><00:03:19.599><c> ID</c>

00:03:22.300 --> 00:03:22.310 align:start position:0%
 
 

00:03:22.310 --> 00:03:24.280 align:start position:0%
 
now<00:03:22.580><c> I'll</c><00:03:22.730><c> start</c><00:03:22.910><c> by</c><00:03:23.180><c> joining</c><00:03:23.569><c> my</c><00:03:23.780><c> customer</c>

00:03:24.280 --> 00:03:24.290 align:start position:0%
now I'll start by joining my customer
 

00:03:24.290 --> 00:03:27.070 align:start position:0%
now I'll start by joining my customer
IDs<00:03:24.680><c> so</c><00:03:25.550><c> I'll</c><00:03:25.730><c> drag</c><00:03:26.060><c> the</c><00:03:26.300><c> primary</c><00:03:26.810><c> key</c>

00:03:27.070 --> 00:03:27.080 align:start position:0%
IDs so I'll drag the primary key
 

00:03:27.080 --> 00:03:30.520 align:start position:0%
IDs so I'll drag the primary key
customer<00:03:27.650><c> ID</c><00:03:27.830><c> from</c><00:03:28.370><c> the</c><00:03:28.430><c> customers</c><00:03:29.120><c> table</c><00:03:29.530><c> to</c>

00:03:30.520 --> 00:03:30.530 align:start position:0%
customer ID from the customers table to
 

00:03:30.530 --> 00:03:32.920 align:start position:0%
customer ID from the customers table to
the<00:03:30.650><c> foreign</c><00:03:31.160><c> key</c><00:03:31.459><c> customer</c><00:03:32.090><c> ID</c><00:03:32.300><c> in</c><00:03:32.810><c> the</c>

00:03:32.920 --> 00:03:32.930 align:start position:0%
the foreign key customer ID in the
 

00:03:32.930 --> 00:03:38.170 align:start position:0%
the foreign key customer ID in the
orders<00:03:33.290><c> table</c><00:03:36.130><c> the</c><00:03:37.130><c> Edit</c><00:03:37.550><c> relationships</c>

00:03:38.170 --> 00:03:38.180 align:start position:0%
orders table the Edit relationships
 

00:03:38.180 --> 00:03:39.729 align:start position:0%
orders table the Edit relationships
dialog<00:03:38.780><c> box</c><00:03:39.080><c> will</c><00:03:39.319><c> appear</c>

00:03:39.729 --> 00:03:39.739 align:start position:0%
dialog box will appear
 

00:03:39.739 --> 00:03:42.250 align:start position:0%
dialog box will appear
on<00:03:39.860><c> the</c><00:03:40.610><c> left</c><00:03:40.940><c> you</c><00:03:41.270><c> see</c><00:03:41.300><c> a</c><00:03:41.569><c> header</c><00:03:41.989><c> that</c><00:03:42.200><c> says</c>

00:03:42.250 --> 00:03:42.260 align:start position:0%
on the left you see a header that says
 

00:03:42.260 --> 00:03:45.010 align:start position:0%
on the left you see a header that says
table<00:03:43.220><c> and</c><00:03:43.430><c> on</c><00:03:43.910><c> the</c><00:03:43.940><c> right</c><00:03:44.300><c> a</c><00:03:44.569><c> header</c><00:03:44.810><c> that</c>

00:03:45.010 --> 00:03:45.020 align:start position:0%
table and on the right a header that
 

00:03:45.020 --> 00:03:47.979 align:start position:0%
table and on the right a header that
says<00:03:45.080><c> related</c><00:03:45.830><c> table</c><00:03:46.220><c> in</c><00:03:46.400><c> this</c><00:03:47.180><c> case</c><00:03:47.239><c> the</c>

00:03:47.979 --> 00:03:47.989 align:start position:0%
says related table in this case the
 

00:03:47.989 --> 00:03:50.260 align:start position:0%
says related table in this case the
table<00:03:48.410><c> is</c><00:03:48.530><c> customers</c><00:03:49.100><c> and</c><00:03:49.340><c> the</c><00:03:49.489><c> related</c><00:03:49.940><c> table</c>

00:03:50.260 --> 00:03:50.270 align:start position:0%
table is customers and the related table
 

00:03:50.270 --> 00:03:55.540 align:start position:0%
table is customers and the related table
is<00:03:50.390><c> orders</c><00:03:52.569><c> now</c><00:03:53.569><c> this</c><00:03:53.900><c> area</c><00:03:54.290><c> here</c><00:03:54.890><c> is</c><00:03:55.070><c> where</c><00:03:55.100><c> we</c>

00:03:55.540 --> 00:03:55.550 align:start position:0%
is orders now this area here is where we
 

00:03:55.550 --> 00:03:58.290 align:start position:0%
is orders now this area here is where we
can<00:03:55.730><c> edit</c><00:03:55.970><c> our</c><00:03:56.300><c> relationships</c><00:03:57.019><c> if</c><00:03:57.230><c> needed</c>

00:03:58.290 --> 00:03:58.300 align:start position:0%
can edit our relationships if needed
 

00:03:58.300 --> 00:04:01.690 align:start position:0%
can edit our relationships if needed
below<00:03:59.300><c> we</c><00:03:59.480><c> have</c><00:03:59.660><c> other</c><00:03:59.959><c> options</c><00:04:00.590><c> the</c><00:04:01.070><c> only</c><00:04:01.430><c> one</c>

00:04:01.690 --> 00:04:01.700 align:start position:0%
below we have other options the only one
 

00:04:01.700 --> 00:04:03.430 align:start position:0%
below we have other options the only one
that<00:04:01.820><c> is</c><00:04:01.910><c> really</c><00:04:02.090><c> important</c><00:04:02.780><c> is</c><00:04:02.930><c> enforce</c>

00:04:03.430 --> 00:04:03.440 align:start position:0%
that is really important is enforce
 

00:04:03.440 --> 00:04:06.400 align:start position:0%
that is really important is enforce
referential<00:04:03.680><c> integrity</c><00:04:04.690><c> by</c><00:04:05.690><c> checking</c><00:04:06.080><c> off</c>

00:04:06.400 --> 00:04:06.410 align:start position:0%
referential integrity by checking off
 

00:04:06.410 --> 00:04:08.680 align:start position:0%
referential integrity by checking off
referential<00:04:07.160><c> integrity</c><00:04:07.220><c> we</c><00:04:08.209><c> assure</c><00:04:08.660><c> that</c>

00:04:08.680 --> 00:04:08.690 align:start position:0%
referential integrity we assure that
 

00:04:08.690 --> 00:04:11.199 align:start position:0%
referential integrity we assure that
there<00:04:09.230><c> is</c><00:04:09.380><c> never</c><00:04:09.769><c> in</c><00:04:10.069><c> order</c><00:04:10.489><c> in</c><00:04:10.640><c> our</c><00:04:10.730><c> orders</c>

00:04:11.199 --> 00:04:11.209 align:start position:0%
there is never in order in our orders
 

00:04:11.209 --> 00:04:14.140 align:start position:0%
there is never in order in our orders
table<00:04:11.480><c> for</c><00:04:12.019><c> a</c><00:04:12.050><c> customer</c><00:04:12.739><c> that</c><00:04:13.190><c> doesn't</c><00:04:13.550><c> exist</c>

00:04:14.140 --> 00:04:14.150 align:start position:0%
table for a customer that doesn't exist
 

00:04:14.150 --> 00:04:16.960 align:start position:0%
table for a customer that doesn't exist
in<00:04:14.269><c> our</c><00:04:14.360><c> customers</c><00:04:15.019><c> table</c><00:04:15.440><c> and</c><00:04:15.650><c> likewise</c><00:04:16.549><c> we</c>

00:04:16.960 --> 00:04:16.970 align:start position:0%
in our customers table and likewise we
 

00:04:16.970 --> 00:04:18.940 align:start position:0%
in our customers table and likewise we
would<00:04:17.120><c> never</c><00:04:17.390><c> want</c><00:04:17.510><c> to</c><00:04:17.810><c> have</c><00:04:18.079><c> an</c><00:04:18.229><c> order</c><00:04:18.620><c> for</c><00:04:18.890><c> a</c>

00:04:18.940 --> 00:04:18.950 align:start position:0%
would never want to have an order for a
 

00:04:18.950 --> 00:04:21.340 align:start position:0%
would never want to have an order for a
book<00:04:19.370><c> that</c><00:04:19.669><c> doesn't</c><00:04:20.389><c> appear</c><00:04:20.780><c> in</c><00:04:20.810><c> our</c><00:04:20.989><c> books</c>

00:04:21.340 --> 00:04:21.350 align:start position:0%
book that doesn't appear in our books
 

00:04:21.350 --> 00:04:23.620 align:start position:0%
book that doesn't appear in our books
table<00:04:21.799><c> so</c><00:04:22.490><c> clicking</c><00:04:22.850><c> enforce</c><00:04:23.419><c> referential</c>

00:04:23.620 --> 00:04:23.630 align:start position:0%
table so clicking enforce referential
 

00:04:23.630 --> 00:04:26.350 align:start position:0%
table so clicking enforce referential
integrity<00:04:24.100><c> forces</c><00:04:25.100><c> access</c><00:04:25.669><c> to</c><00:04:25.820><c> check</c><00:04:26.180><c> for</c>

00:04:26.350 --> 00:04:26.360 align:start position:0%
integrity forces access to check for
 

00:04:26.360 --> 00:04:29.860 align:start position:0%
integrity forces access to check for
these<00:04:26.510><c> types</c><00:04:26.780><c> of</c><00:04:26.930><c> things</c><00:04:27.700><c> click</c><00:04:28.700><c> create</c><00:04:29.479><c> to</c>

00:04:29.860 --> 00:04:29.870 align:start position:0%
these types of things click create to
 

00:04:29.870 --> 00:04:34.810 align:start position:0%
these types of things click create to
establish<00:04:30.560><c> the</c><00:04:30.740><c> relationship</c><00:04:33.190><c> by</c><00:04:34.190><c> enforcing</c>

00:04:34.810 --> 00:04:34.820 align:start position:0%
establish the relationship by enforcing
 

00:04:34.820 --> 00:04:36.850 align:start position:0%
establish the relationship by enforcing
referential<00:04:35.000><c> integrity</c><00:04:35.450><c> you</c><00:04:36.169><c> establish</c><00:04:36.740><c> a</c>

00:04:36.850 --> 00:04:36.860 align:start position:0%
referential integrity you establish a
 

00:04:36.860 --> 00:04:38.920 align:start position:0%
referential integrity you establish a
one<00:04:37.220><c> to</c><00:04:37.550><c> many</c><00:04:37.580><c> relationship</c><00:04:37.880><c> between</c><00:04:38.479><c> the</c>

00:04:38.920 --> 00:04:38.930 align:start position:0%
one to many relationship between the
 

00:04:38.930 --> 00:04:41.770 align:start position:0%
one to many relationship between the
tables<00:04:39.550><c> now</c><00:04:40.550><c> this</c><00:04:40.760><c> just</c><00:04:41.000><c> means</c><00:04:41.330><c> that</c><00:04:41.570><c> one</c>

00:04:41.770 --> 00:04:41.780 align:start position:0%
tables now this just means that one
 

00:04:41.780 --> 00:04:45.190 align:start position:0%
tables now this just means that one
customer<00:04:42.110><c> may</c><00:04:42.590><c> place</c><00:04:42.919><c> many</c><00:04:43.310><c> orders</c><00:04:43.900><c> so</c><00:04:44.900><c> in</c><00:04:45.080><c> the</c>

00:04:45.190 --> 00:04:45.200 align:start position:0%
customer may place many orders so in the
 

00:04:45.200 --> 00:04:49.140 align:start position:0%
customer may place many orders so in the
customer<00:04:45.770><c> table</c><00:04:46.160><c> the</c><00:04:46.760><c> ID</c><00:04:46.940><c> shows</c><00:04:47.690><c> up</c><00:04:47.960><c> one</c><00:04:48.440><c> time</c>

00:04:49.140 --> 00:04:49.150 align:start position:0%
customer table the ID shows up one time
 

00:04:49.150 --> 00:04:52.210 align:start position:0%
customer table the ID shows up one time
but<00:04:50.150><c> in</c><00:04:50.300><c> the</c><00:04:50.419><c> orders</c><00:04:50.810><c> table</c><00:04:51.050><c> we</c><00:04:51.590><c> can</c><00:04:51.740><c> expect</c>

00:04:52.210 --> 00:04:52.220 align:start position:0%
but in the orders table we can expect
 

00:04:52.220 --> 00:04:54.090 align:start position:0%
but in the orders table we can expect
that<00:04:52.280><c> the</c><00:04:52.430><c> customer</c><00:04:52.910><c> may</c><00:04:52.940><c> show</c><00:04:53.270><c> up</c><00:04:53.450><c> many</c><00:04:53.750><c> times</c>

00:04:54.090 --> 00:04:54.100 align:start position:0%
that the customer may show up many times
 

00:04:54.100 --> 00:04:56.770 align:start position:0%
that the customer may show up many times
because<00:04:55.100><c> they</c><00:04:55.250><c> may</c><00:04:55.490><c> order</c><00:04:55.880><c> from</c><00:04:56.000><c> us</c><00:04:56.180><c> again</c><00:04:56.330><c> and</c>

00:04:56.770 --> 00:04:56.780 align:start position:0%
because they may order from us again and
 

00:04:56.780 --> 00:05:01.000 align:start position:0%
because they may order from us again and
again<00:04:57.050><c> and</c><00:04:57.169><c> again</c><00:04:59.080><c> I'm</c><00:05:00.080><c> going</c><00:05:00.470><c> to</c><00:05:00.560><c> set</c><00:05:00.770><c> up</c><00:05:00.890><c> my</c>

00:05:01.000 --> 00:05:01.010 align:start position:0%
again and again I'm going to set up my
 

00:05:01.010 --> 00:05:04.570 align:start position:0%
again and again I'm going to set up my
other<00:05:01.190><c> relationship</c><00:05:02.680><c> this</c><00:05:03.680><c> one</c><00:05:03.950><c> is</c><00:05:04.130><c> from</c><00:05:04.370><c> book</c>

00:05:04.570 --> 00:05:04.580 align:start position:0%
other relationship this one is from book
 

00:05:04.580 --> 00:05:09.159 align:start position:0%
other relationship this one is from book
ID<00:05:04.850><c> to</c><00:05:05.360><c> book</c><00:05:05.600><c> ID</c><00:05:06.160><c> again</c><00:05:07.160><c> I'll</c><00:05:07.760><c> check</c><00:05:08.479><c> and</c><00:05:08.720><c> force</c>

00:05:09.159 --> 00:05:09.169 align:start position:0%
ID to book ID again I'll check and force
 

00:05:09.169 --> 00:05:12.040 align:start position:0%
ID to book ID again I'll check and force
referential<00:05:09.770><c> integrity</c><00:05:10.270><c> so</c><00:05:11.270><c> I</c><00:05:11.300><c> can</c><00:05:11.600><c> establish</c>

00:05:12.040 --> 00:05:12.050 align:start position:0%
referential integrity so I can establish
 

00:05:12.050 --> 00:05:15.250 align:start position:0%
referential integrity so I can establish
the<00:05:12.200><c> one-to-many</c><00:05:12.740><c> relationship</c><00:05:13.900><c> so</c><00:05:14.900><c> now</c><00:05:15.200><c> we</c>

00:05:15.250 --> 00:05:15.260 align:start position:0%
the one-to-many relationship so now we
 

00:05:15.260 --> 00:05:18.159 align:start position:0%
the one-to-many relationship so now we
can<00:05:15.560><c> see</c><00:05:15.800><c> that</c><00:05:16.039><c> we</c><00:05:16.160><c> have</c><00:05:16.400><c> one</c><00:05:16.760><c> book</c><00:05:17.030><c> ID</c><00:05:17.270><c> for</c>

00:05:18.159 --> 00:05:18.169 align:start position:0%
can see that we have one book ID for
 

00:05:18.169 --> 00:05:20.950 align:start position:0%
can see that we have one book ID for
each<00:05:18.320><c> book</c><00:05:18.740><c> but</c><00:05:19.520><c> there</c><00:05:19.669><c> can</c><00:05:19.850><c> be</c><00:05:19.880><c> many</c><00:05:20.210><c> book</c><00:05:20.570><c> IDs</c>

00:05:20.950 --> 00:05:20.960 align:start position:0%
each book but there can be many book IDs
 

00:05:20.960 --> 00:05:24.370 align:start position:0%
each book but there can be many book IDs
and<00:05:21.350><c> in</c><00:05:21.650><c> order</c><00:05:22.039><c> I</c><00:05:22.250><c> hope</c><00:05:22.789><c> you</c><00:05:22.910><c> got</c><00:05:23.090><c> that</c><00:05:23.380><c> now</c>

00:05:24.370 --> 00:05:24.380 align:start position:0%
and in order I hope you got that now
 

00:05:24.380 --> 00:05:25.690 align:start position:0%
and in order I hope you got that now
everything<00:05:24.830><c> looks</c><00:05:24.860><c> good</c>

00:05:25.690 --> 00:05:25.700 align:start position:0%
everything looks good
 

00:05:25.700 --> 00:05:27.460 align:start position:0%
everything looks good
but<00:05:25.850><c> if</c><00:05:25.940><c> I</c><00:05:26.030><c> needed</c><00:05:26.270><c> to</c><00:05:26.479><c> go</c><00:05:26.600><c> back</c><00:05:26.870><c> and</c><00:05:27.110><c> edit</c><00:05:27.260><c> my</c>

00:05:27.460 --> 00:05:27.470 align:start position:0%
but if I needed to go back and edit my
 

00:05:27.470 --> 00:05:29.500 align:start position:0%
but if I needed to go back and edit my
relationships<00:05:28.190><c> I</c><00:05:28.400><c> could</c><00:05:28.700><c> go</c><00:05:28.910><c> to</c><00:05:28.970><c> edit</c>

00:05:29.500 --> 00:05:29.510 align:start position:0%
relationships I could go to edit
 

00:05:29.510 --> 00:05:32.020 align:start position:0%
relationships I could go to edit
relationships<00:05:30.169><c> or</c><00:05:30.860><c> double</c><00:05:31.430><c> click</c><00:05:31.669><c> on</c><00:05:31.700><c> the</c>

00:05:32.020 --> 00:05:32.030 align:start position:0%
relationships or double click on the
 

00:05:32.030 --> 00:05:34.810 align:start position:0%
relationships or double click on the
links<00:05:32.330><c> between</c><00:05:32.479><c> the</c><00:05:32.780><c> tables</c><00:05:33.169><c> I</c><00:05:33.520><c> want</c><00:05:34.520><c> to</c><00:05:34.640><c> show</c>

00:05:34.810 --> 00:05:34.820 align:start position:0%
links between the tables I want to show
 

00:05:34.820 --> 00:05:35.770 align:start position:0%
links between the tables I want to show
you<00:05:34.880><c> one</c><00:05:35.300><c> more</c>

00:05:35.770 --> 00:05:35.780 align:start position:0%
you one more
 

00:05:35.780 --> 00:05:38.800 align:start position:0%
you one more
saying<00:05:35.990><c> before</c><00:05:36.200><c> we</c><00:05:36.440><c> wrap</c><00:05:36.650><c> up</c><00:05:36.730><c> if</c><00:05:37.730><c> I</c><00:05:38.540><c> move</c><00:05:38.780><c> my</c>

00:05:38.800 --> 00:05:38.810 align:start position:0%
saying before we wrap up if I move my
 

00:05:38.810 --> 00:05:41.110 align:start position:0%
saying before we wrap up if I move my
tables<00:05:39.410><c> around</c><00:05:39.800><c> and</c><00:05:40.250><c> a</c><00:05:40.310><c> relationship</c><00:05:40.850><c> map</c>

00:05:41.110 --> 00:05:41.120 align:start position:0%
tables around and a relationship map
 

00:05:41.120 --> 00:05:44.050 align:start position:0%
tables around and a relationship map
here<00:05:41.480><c> the</c><00:05:41.660><c> relationship</c><00:05:42.590><c> remains</c><00:05:42.710><c> intact</c><00:05:43.430><c> no</c>

00:05:44.050 --> 00:05:44.060 align:start position:0%
here the relationship remains intact no
 

00:05:44.060 --> 00:05:46.900 align:start position:0%
here the relationship remains intact no
matter<00:05:44.300><c> where</c><00:05:44.690><c> I</c><00:05:44.720><c> move</c><00:05:45.050><c> the</c><00:05:45.200><c> tables</c><00:05:45.620><c> I'm</c><00:05:45.919><c> going</c>

00:05:46.900 --> 00:05:46.910 align:start position:0%
matter where I move the tables I'm going
 

00:05:46.910 --> 00:05:48.190 align:start position:0%
matter where I move the tables I'm going
to<00:05:47.000><c> move</c><00:05:47.150><c> them</c><00:05:47.330><c> back</c><00:05:47.600><c> to</c><00:05:47.870><c> their</c><00:05:48.020><c> original</c>

00:05:48.190 --> 00:05:48.200 align:start position:0%
to move them back to their original
 

00:05:48.200 --> 00:05:50.800 align:start position:0%
to move them back to their original
spots<00:05:48.889><c> since</c><00:05:49.639><c> this</c><00:05:49.880><c> is</c><00:05:50.060><c> the</c><00:05:50.180><c> easiest</c><00:05:50.540><c> way</c><00:05:50.780><c> to</c>

00:05:50.800 --> 00:05:50.810 align:start position:0%
spots since this is the easiest way to
 

00:05:50.810 --> 00:05:55.390 align:start position:0%
spots since this is the easiest way to
see<00:05:51.080><c> the</c><00:05:51.169><c> relationships</c><00:05:53.740><c> my</c><00:05:54.740><c> relationships</c>

00:05:55.390 --> 00:05:55.400 align:start position:0%
see the relationships my relationships
 

00:05:55.400 --> 00:05:58.060 align:start position:0%
see the relationships my relationships
are<00:05:55.550><c> set</c><00:05:55.850><c> so</c><00:05:56.570><c> now</c><00:05:56.810><c> I</c><00:05:56.840><c> can</c><00:05:57.139><c> close</c><00:05:57.380><c> relationships</c>

00:05:58.060 --> 00:05:58.070 align:start position:0%
are set so now I can close relationships
 

00:05:58.070 --> 00:06:01.690 align:start position:0%
are set so now I can close relationships
tab<00:05:59.380><c> you'll</c><00:06:00.380><c> be</c><00:06:00.560><c> prompted</c><00:06:00.830><c> to</c><00:06:01.070><c> save</c><00:06:01.400><c> your</c>

00:06:01.690 --> 00:06:01.700 align:start position:0%
tab you'll be prompted to save your
 

00:06:01.700 --> 00:06:06.909 align:start position:0%
tab you'll be prompted to save your
relationships<00:06:02.300><c> click</c><00:06:03.020><c> yes</c><00:06:03.440><c> to</c><00:06:03.650><c> save</c><00:06:05.919><c> our</c>

00:06:06.909 --> 00:06:06.919 align:start position:0%
relationships click yes to save our
 

00:06:06.919 --> 00:06:08.200 align:start position:0%
relationships click yes to save our
tables<00:06:07.490><c> are</c><00:06:07.639><c> related</c>

00:06:08.200 --> 00:06:08.210 align:start position:0%
tables are related
 

00:06:08.210 --> 00:06:10.720 align:start position:0%
tables are related
next<00:06:08.870><c> we'll</c><00:06:08.990><c> start</c><00:06:09.200><c> adding</c><00:06:09.530><c> records</c><00:06:09.770><c> also</c>

00:06:10.720 --> 00:06:10.730 align:start position:0%
next we'll start adding records also
 

00:06:10.730 --> 00:06:13.900 align:start position:0%
next we'll start adding records also
known<00:06:10.940><c> as</c><00:06:11.060><c> populating</c><00:06:11.660><c> the</c><00:06:11.780><c> database</c>