WEBVTT
Kind: captions
Language: en

00:00:05.660 --> 00:00:08.780 align:start position:0%
 
now<00:00:06.660><c> that</c><00:00:06.870><c> we</c><00:00:06.960><c> know</c><00:00:06.990><c> what</c><00:00:07.529><c> a</c><00:00:07.560><c> database</c><00:00:08.099><c> is</c><00:00:08.400><c> and</c>

00:00:08.780 --> 00:00:08.790 align:start position:0%
now that we know what a database is and
 

00:00:08.790 --> 00:00:11.330 align:start position:0%
now that we know what a database is and
how<00:00:09.360><c> it's</c><00:00:09.540><c> used</c><00:00:09.780><c> in</c><00:00:09.900><c> everyday</c><00:00:10.260><c> life</c><00:00:10.500><c> it's</c><00:00:11.099><c> time</c>

00:00:11.330 --> 00:00:11.340 align:start position:0%
how it's used in everyday life it's time
 

00:00:11.340 --> 00:00:13.730 align:start position:0%
how it's used in everyday life it's time
to<00:00:11.550><c> think</c><00:00:11.670><c> about</c><00:00:11.790><c> creating</c><00:00:12.420><c> our</c><00:00:12.570><c> own</c><00:00:12.740><c> let's</c>

00:00:13.730 --> 00:00:13.740 align:start position:0%
to think about creating our own let's
 

00:00:13.740 --> 00:00:16.189 align:start position:0%
to think about creating our own let's
pretend<00:00:14.219><c> that</c><00:00:14.370><c> we</c><00:00:14.580><c> work</c><00:00:14.790><c> for</c><00:00:15.030><c> a</c><00:00:15.089><c> bookstore</c><00:00:15.630><c> the</c>

00:00:16.189 --> 00:00:16.199 align:start position:0%
pretend that we work for a bookstore the
 

00:00:16.199 --> 00:00:19.730 align:start position:0%
pretend that we work for a bookstore the
ready<00:00:16.470><c> three</c><00:00:16.800><c> bookstore</c>

00:00:19.730 --> 00:00:19.740 align:start position:0%
 
 

00:00:19.740 --> 00:00:22.830 align:start position:0%
 
we<00:00:20.740><c> have</c><00:00:20.920><c> customers</c><00:00:21.519><c> and</c><00:00:21.759><c> we</c><00:00:22.000><c> sell</c><00:00:22.240><c> books</c><00:00:22.599><c> in</c>

00:00:22.830 --> 00:00:22.840 align:start position:0%
we have customers and we sell books in
 

00:00:22.840 --> 00:00:26.159 align:start position:0%
we have customers and we sell books in
the<00:00:22.930><c> store</c><00:00:23.170><c> and</c><00:00:23.529><c> online</c><00:00:24.570><c> the</c><00:00:25.570><c> store</c><00:00:25.869><c> needs</c><00:00:26.019><c> a</c>

00:00:26.159 --> 00:00:26.169 align:start position:0%
the store and online the store needs a
 

00:00:26.169 --> 00:00:28.830 align:start position:0%
the store and online the store needs a
way<00:00:26.259><c> to</c><00:00:26.289><c> keep</c><00:00:26.500><c> track</c><00:00:26.590><c> of</c><00:00:27.009><c> customers</c><00:00:27.550><c> books</c><00:00:28.419><c> and</c>

00:00:28.830 --> 00:00:28.840 align:start position:0%
way to keep track of customers books and
 

00:00:28.840 --> 00:00:32.490 align:start position:0%
way to keep track of customers books and
orders<00:00:29.970><c> we</c><00:00:30.970><c> also</c><00:00:31.210><c> like</c><00:00:31.539><c> to</c><00:00:31.720><c> be</c><00:00:31.810><c> able</c><00:00:31.989><c> to</c><00:00:32.140><c> send</c>

00:00:32.490 --> 00:00:32.500 align:start position:0%
orders we also like to be able to send
 

00:00:32.500 --> 00:00:34.590 align:start position:0%
orders we also like to be able to send
books<00:00:32.680><c> to</c><00:00:32.829><c> customers</c><00:00:33.399><c> who</c><00:00:33.520><c> order</c><00:00:33.820><c> online</c><00:00:34.000><c> and</c>

00:00:34.590 --> 00:00:34.600 align:start position:0%
books to customers who order online and
 

00:00:34.600 --> 00:00:37.229 align:start position:0%
books to customers who order online and
perhaps<00:00:34.840><c> send</c><00:00:35.290><c> out</c><00:00:35.470><c> some</c><00:00:35.620><c> coupons</c><00:00:36.040><c> track</c><00:00:37.000><c> our</c>

00:00:37.229 --> 00:00:37.239 align:start position:0%
perhaps send out some coupons track our
 

00:00:37.239 --> 00:00:39.689 align:start position:0%
perhaps send out some coupons track our
sales<00:00:37.690><c> and</c><00:00:38.050><c> determine</c><00:00:39.040><c> what</c><00:00:39.250><c> books</c><00:00:39.519><c> are</c>

00:00:39.689 --> 00:00:39.699 align:start position:0%
sales and determine what books are
 

00:00:39.699 --> 00:00:41.340 align:start position:0%
sales and determine what books are
popular<00:00:39.970><c> so</c><00:00:40.300><c> we</c><00:00:40.570><c> can</c><00:00:40.839><c> establish</c><00:00:40.960><c> a</c>

00:00:41.340 --> 00:00:41.350 align:start position:0%
popular so we can establish a
 

00:00:41.350 --> 00:00:44.280 align:start position:0%
popular so we can establish a
bestsellers<00:00:42.070><c> list</c><00:00:42.339><c> at</c><00:00:42.460><c> the</c><00:00:42.550><c> store</c><00:00:43.019><c> so</c><00:00:44.019><c> we</c><00:00:44.140><c> can</c>

00:00:44.280 --> 00:00:44.290 align:start position:0%
bestsellers list at the store so we can
 

00:00:44.290 --> 00:00:47.299 align:start position:0%
bestsellers list at the store so we can
do<00:00:44.440><c> all</c><00:00:44.680><c> of</c><00:00:44.710><c> this</c><00:00:44.980><c> by</c><00:00:45.190><c> creating</c><00:00:45.250><c> a</c><00:00:45.850><c> database</c>

00:00:47.299 --> 00:00:47.309 align:start position:0%
do all of this by creating a database
 

00:00:47.309 --> 00:00:49.890 align:start position:0%
do all of this by creating a database
the<00:00:48.309><c> first</c><00:00:48.339><c> thing</c><00:00:49.059><c> to</c><00:00:49.239><c> think</c><00:00:49.269><c> about</c><00:00:49.540><c> when</c>

00:00:49.890 --> 00:00:49.900 align:start position:0%
the first thing to think about when
 

00:00:49.900 --> 00:00:52.080 align:start position:0%
the first thing to think about when
creating<00:00:50.110><c> a</c><00:00:50.500><c> database</c><00:00:50.739><c> is</c><00:00:51.220><c> the</c><00:00:51.250><c> purpose</c><00:00:51.730><c> for</c>

00:00:52.080 --> 00:00:52.090 align:start position:0%
creating a database is the purpose for
 

00:00:52.090 --> 00:00:54.330 align:start position:0%
creating a database is the purpose for
the<00:00:52.300><c> database</c><00:00:52.690><c> which</c><00:00:53.289><c> in</c><00:00:53.500><c> this</c><00:00:53.649><c> case</c><00:00:53.949><c> is</c><00:00:54.219><c> to</c>

00:00:54.330 --> 00:00:54.340 align:start position:0%
the database which in this case is to
 

00:00:54.340 --> 00:00:58.910 align:start position:0%
the database which in this case is to
keep<00:00:54.520><c> track</c><00:00:54.789><c> of</c><00:00:54.940><c> customers</c><00:00:55.449><c> orders</c><00:00:55.960><c> and</c><00:00:56.260><c> books</c>

00:00:58.910 --> 00:00:58.920 align:start position:0%
 
 

00:00:58.920 --> 00:01:01.619 align:start position:0%
 
the<00:00:59.920><c> next</c><00:01:00.460><c> step</c><00:01:00.850><c> is</c><00:01:01.090><c> to</c><00:01:01.239><c> do</c><00:01:01.360><c> a</c><00:01:01.390><c> little</c>

00:01:01.619 --> 00:01:01.629 align:start position:0%
the next step is to do a little
 

00:01:01.629 --> 00:01:04.320 align:start position:0%
the next step is to do a little
brainstorming<00:01:02.250><c> think</c><00:01:03.250><c> about</c><00:01:03.519><c> what</c><00:01:03.879><c> you</c><00:01:04.089><c> need</c>

00:01:04.320 --> 00:01:04.330 align:start position:0%
brainstorming think about what you need
 

00:01:04.330 --> 00:01:07.590 align:start position:0%
brainstorming think about what you need
to<00:01:04.390><c> create</c><00:01:04.839><c> a</c><00:01:05.080><c> database</c><00:01:06.090><c> now</c><00:01:07.090><c> I'm</c><00:01:07.240><c> a</c><00:01:07.270><c> visual</c>

00:01:07.590 --> 00:01:07.600 align:start position:0%
to create a database now I'm a visual
 

00:01:07.600 --> 00:01:09.359 align:start position:0%
to create a database now I'm a visual
person<00:01:07.780><c> so</c><00:01:08.380><c> I</c><00:01:08.409><c> like</c><00:01:08.650><c> to</c><00:01:08.680><c> take</c><00:01:08.890><c> out</c><00:01:09.070><c> a</c><00:01:09.100><c> sheet</c><00:01:09.310><c> of</c>

00:01:09.359 --> 00:01:09.369 align:start position:0%
person so I like to take out a sheet of
 

00:01:09.369 --> 00:01:13.450 align:start position:0%
person so I like to take out a sheet of
paper<00:01:09.490><c> and</c><00:01:10.030><c> write</c><00:01:10.540><c> all</c><00:01:10.780><c> of</c><00:01:10.840><c> this</c><00:01:11.229><c> stuff</c><00:01:11.500><c> down</c>

00:01:13.450 --> 00:01:13.460 align:start position:0%
paper and write all of this stuff down
 

00:01:13.460 --> 00:01:16.030 align:start position:0%
paper and write all of this stuff down
now<00:01:14.180><c> what</c><00:01:14.420><c> do</c><00:01:14.690><c> I</c><00:01:14.750><c> want</c><00:01:15.110><c> to</c><00:01:15.260><c> know</c><00:01:15.470><c> about</c><00:01:15.650><c> my</c>

00:01:16.030 --> 00:01:16.040 align:start position:0%
now what do I want to know about my
 

00:01:16.040 --> 00:01:18.430 align:start position:0%
now what do I want to know about my
customers<00:01:16.610><c> their</c><00:01:17.030><c> orders</c><00:01:17.450><c> and</c><00:01:17.720><c> the</c><00:01:18.020><c> books</c><00:01:18.230><c> in</c>

00:01:18.430 --> 00:01:18.440 align:start position:0%
customers their orders and the books in
 

00:01:18.440 --> 00:01:22.290 align:start position:0%
customers their orders and the books in
my<00:01:18.590><c> inventory</c><00:01:19.150><c> let's</c><00:01:20.150><c> start</c><00:01:20.600><c> with</c><00:01:20.810><c> customers</c>

00:01:22.290 --> 00:01:22.300 align:start position:0%
my inventory let's start with customers
 

00:01:22.300 --> 00:01:24.910 align:start position:0%
my inventory let's start with customers
since<00:01:23.300><c> I</c><00:01:23.360><c> plan</c><00:01:23.600><c> to</c><00:01:23.630><c> Mail</c><00:01:23.960><c> coupons</c><00:01:24.470><c> and</c><00:01:24.680><c> books</c>

00:01:24.910 --> 00:01:24.920 align:start position:0%
since I plan to Mail coupons and books
 

00:01:24.920 --> 00:01:27.270 align:start position:0%
since I plan to Mail coupons and books
out<00:01:25.160><c> I</c><00:01:25.400><c> want</c><00:01:25.730><c> to</c><00:01:25.850><c> know</c><00:01:25.940><c> my</c><00:01:26.060><c> customers</c><00:01:26.600><c> name</c>

00:01:27.270 --> 00:01:27.280 align:start position:0%
out I want to know my customers name
 

00:01:27.280 --> 00:01:31.060 align:start position:0%
out I want to know my customers name
their<00:01:28.280><c> address</c><00:01:28.670><c> is</c><00:01:28.820><c> important</c><00:01:29.270><c> too</c><00:01:29.800><c> later</c><00:01:30.800><c> on</c>

00:01:31.060 --> 00:01:31.070 align:start position:0%
their address is important too later on
 

00:01:31.070 --> 00:01:32.650 align:start position:0%
their address is important too later on
this<00:01:31.250><c> information</c><00:01:31.550><c> may</c><00:01:32.030><c> help</c><00:01:32.270><c> me</c><00:01:32.479><c> determine</c>

00:01:32.650 --> 00:01:32.660 align:start position:0%
this information may help me determine
 

00:01:32.660 --> 00:01:34.900 align:start position:0%
this information may help me determine
which<00:01:33.170><c> states</c><00:01:33.530><c> order</c><00:01:33.860><c> most</c><00:01:34.040><c> of</c><00:01:34.190><c> my</c><00:01:34.280><c> books</c><00:01:34.610><c> and</c>

00:01:34.900 --> 00:01:34.910 align:start position:0%
which states order most of my books and
 

00:01:34.910 --> 00:01:37.030 align:start position:0%
which states order most of my books and
in<00:01:35.390><c> turn</c><00:01:35.660><c> I'll</c><00:01:35.990><c> want</c><00:01:36.229><c> to</c><00:01:36.410><c> thank</c><00:01:36.680><c> them</c><00:01:36.860><c> by</c>

00:01:37.030 --> 00:01:37.040 align:start position:0%
in turn I'll want to thank them by
 

00:01:37.040 --> 00:01:40.060 align:start position:0%
in turn I'll want to thank them by
mailing<00:01:37.460><c> out</c><00:01:37.580><c> coupons</c><00:01:38.000><c> oh</c><00:01:38.560><c> and</c><00:01:39.560><c> just</c><00:01:39.830><c> in</c><00:01:39.860><c> case</c>

00:01:40.060 --> 00:01:40.070 align:start position:0%
mailing out coupons oh and just in case
 

00:01:40.070 --> 00:01:41.920 align:start position:0%
mailing out coupons oh and just in case
I<00:01:40.220><c> need</c><00:01:40.250><c> to</c><00:01:40.520><c> contact</c><00:01:40.970><c> them</c><00:01:41.210><c> it</c><00:01:41.420><c> would</c><00:01:41.570><c> be</c><00:01:41.660><c> nice</c>

00:01:41.920 --> 00:01:41.930 align:start position:0%
I need to contact them it would be nice
 

00:01:41.930 --> 00:01:45.820 align:start position:0%
I need to contact them it would be nice
to<00:01:42.140><c> have</c><00:01:42.290><c> an</c><00:01:42.440><c> email</c><00:01:42.740><c> address</c><00:01:44.530><c> now</c><00:01:45.530><c> what</c><00:01:45.710><c> about</c>

00:01:45.820 --> 00:01:45.830 align:start position:0%
to have an email address now what about
 

00:01:45.830 --> 00:01:48.880 align:start position:0%
to have an email address now what about
our<00:01:45.979><c> books</c><00:01:46.869><c> what</c><00:01:47.869><c> information</c><00:01:48.440><c> do</c><00:01:48.530><c> we</c><00:01:48.590><c> need</c><00:01:48.649><c> to</c>

00:01:48.880 --> 00:01:48.890 align:start position:0%
our books what information do we need to
 

00:01:48.890 --> 00:01:51.430 align:start position:0%
our books what information do we need to
know<00:01:48.950><c> about</c><00:01:49.130><c> those</c><00:01:49.490><c> well</c><00:01:50.360><c> we</c><00:01:50.780><c> know</c><00:01:51.080><c> that</c><00:01:51.110><c> each</c>

00:01:51.430 --> 00:01:51.440 align:start position:0%
know about those well we know that each
 

00:01:51.440 --> 00:01:54.060 align:start position:0%
know about those well we know that each
book<00:01:51.770><c> has</c><00:01:51.979><c> a</c><00:01:52.009><c> title</c><00:01:52.460><c> and</c><00:01:52.790><c> author</c><00:01:53.210><c> in</c><00:01:53.600><c> the</c><00:01:53.720><c> price</c>

00:01:54.060 --> 00:01:54.070 align:start position:0%
book has a title and author in the price
 

00:01:54.070 --> 00:01:56.530 align:start position:0%
book has a title and author in the price
books<00:01:55.070><c> also</c><00:01:55.369><c> fit</c><00:01:55.820><c> into</c><00:01:55.970><c> different</c><00:01:56.300><c> categories</c>

00:01:56.530 --> 00:01:56.540 align:start position:0%
books also fit into different categories
 

00:01:56.540 --> 00:01:59.460 align:start position:0%
books also fit into different categories
such<00:01:57.380><c> as</c><00:01:57.410><c> fiction</c><00:01:57.979><c> romance</c><00:01:58.520><c> and</c><00:01:58.729><c> computers</c>

00:01:59.460 --> 00:01:59.470 align:start position:0%
such as fiction romance and computers
 

00:01:59.470 --> 00:02:01.840 align:start position:0%
such as fiction romance and computers
knowing<00:02:00.470><c> the</c><00:02:00.619><c> category</c><00:02:01.190><c> will</c><00:02:01.430><c> help</c><00:02:01.700><c> us</c>

00:02:01.840 --> 00:02:01.850 align:start position:0%
knowing the category will help us
 

00:02:01.850 --> 00:02:04.719 align:start position:0%
knowing the category will help us
pinpoint<00:02:02.390><c> which</c><00:02:03.020><c> types</c><00:02:03.350><c> of</c><00:02:03.500><c> books</c><00:02:03.800><c> sell</c><00:02:04.520><c> the</c>

00:02:04.719 --> 00:02:04.729 align:start position:0%
pinpoint which types of books sell the
 

00:02:04.729 --> 00:02:07.060 align:start position:0%
pinpoint which types of books sell the
best<00:02:05.000><c> and</c><00:02:05.570><c> we</c><00:02:05.690><c> can</c><00:02:05.840><c> keep</c><00:02:06.110><c> that</c><00:02:06.380><c> type</c><00:02:06.680><c> of</c><00:02:06.860><c> book</c>

00:02:07.060 --> 00:02:07.070 align:start position:0%
best and we can keep that type of book
 

00:02:07.070 --> 00:02:11.560 align:start position:0%
best and we can keep that type of book
and<00:02:07.220><c> stock</c><00:02:07.490><c> at</c><00:02:07.670><c> all</c><00:02:07.790><c> times</c><00:02:10.030><c> but</c><00:02:11.030><c> what's</c><00:02:11.239><c> left</c>

00:02:11.560 --> 00:02:11.570 align:start position:0%
and stock at all times but what's left
 

00:02:11.570 --> 00:02:15.460 align:start position:0%
and stock at all times but what's left
ah<00:02:12.400><c> the</c><00:02:13.400><c> orders</c><00:02:13.790><c> now</c><00:02:14.510><c> this</c><00:02:14.720><c> is</c><00:02:14.840><c> a</c><00:02:14.870><c> stage</c><00:02:15.200><c> where</c>

00:02:15.460 --> 00:02:15.470 align:start position:0%
ah the orders now this is a stage where
 

00:02:15.470 --> 00:02:17.940 align:start position:0%
ah the orders now this is a stage where
the<00:02:15.560><c> customer</c><00:02:16.070><c> actually</c><00:02:16.280><c> buys</c><00:02:16.880><c> the</c><00:02:17.209><c> book</c><00:02:17.420><c> I</c>

00:02:17.940 --> 00:02:17.950 align:start position:0%
the customer actually buys the book I
 

00:02:17.950 --> 00:02:20.890 align:start position:0%
the customer actually buys the book I
want<00:02:18.950><c> the</c><00:02:19.100><c> orders</c><00:02:19.489><c> part</c><00:02:19.790><c> of</c><00:02:19.880><c> my</c><00:02:20.000><c> database</c><00:02:20.570><c> to</c>

00:02:20.890 --> 00:02:20.900 align:start position:0%
want the orders part of my database to
 

00:02:20.900 --> 00:02:26.770 align:start position:0%
want the orders part of my database to
tell<00:02:21.290><c> me</c><00:02:21.530><c> who</c><00:02:22.310><c> ordered</c><00:02:22.910><c> what</c><00:02:23.480><c> and</c><00:02:23.870><c> win</c><00:02:25.750><c> now</c><00:02:26.750><c> I</c>

00:02:26.770 --> 00:02:26.780 align:start position:0%
tell me who ordered what and win now I
 

00:02:26.780 --> 00:02:28.600 align:start position:0%
tell me who ordered what and win now I
want<00:02:27.170><c> to</c><00:02:27.230><c> show</c><00:02:27.440><c> you</c><00:02:27.500><c> how</c><00:02:27.830><c> these</c><00:02:28.070><c> three</c><00:02:28.340><c> things</c>

00:02:28.600 --> 00:02:28.610 align:start position:0%
want to show you how these three things
 

00:02:28.610 --> 00:02:32.800 align:start position:0%
want to show you how these three things
are<00:02:28.850><c> related</c><00:02:29.030><c> a</c><00:02:30.760><c> customer</c><00:02:31.760><c> finds</c><00:02:32.180><c> a</c><00:02:32.239><c> book</c><00:02:32.450><c> and</c>

00:02:32.800 --> 00:02:32.810 align:start position:0%
are related a customer finds a book and
 

00:02:32.810 --> 00:02:36.370 align:start position:0%
are related a customer finds a book and
places<00:02:33.230><c> an</c><00:02:33.350><c> order</c><00:02:33.560><c> or</c><00:02:33.920><c> makes</c><00:02:34.130><c> a</c><00:02:34.250><c> purchase</c><00:02:35.380><c> our</c>

00:02:36.370 --> 00:02:36.380 align:start position:0%
places an order or makes a purchase our
 

00:02:36.380 --> 00:02:39.460 align:start position:0%
places an order or makes a purchase our
database<00:02:37.100><c> will</c><00:02:37.400><c> tell</c><00:02:37.640><c> us</c><00:02:37.850><c> who</c><00:02:38.150><c> they</c><00:02:38.299><c> are</c><00:02:38.470><c> what</c>

00:02:39.460 --> 00:02:39.470 align:start position:0%
database will tell us who they are what
 

00:02:39.470 --> 00:02:44.620 align:start position:0%
database will tell us who they are what
they<00:02:39.620><c> bought</c><00:02:39.830><c> and</c><00:02:40.280><c> when</c><00:02:40.610><c> they</c><00:02:40.760><c> bought</c><00:02:40.970><c> it</c><00:02:43.630><c> we</c>

00:02:44.620 --> 00:02:44.630 align:start position:0%
they bought and when they bought it we
 

00:02:44.630 --> 00:02:46.539 align:start position:0%
they bought and when they bought it we
know<00:02:44.900><c> what</c><00:02:45.170><c> we</c><00:02:45.260><c> want</c><00:02:45.560><c> so</c><00:02:45.980><c> now</c><00:02:46.160><c> let's</c><00:02:46.400><c> figure</c>

00:02:46.539 --> 00:02:46.549 align:start position:0%
know what we want so now let's figure
 

00:02:46.549 --> 00:02:48.460 align:start position:0%
know what we want so now let's figure
out<00:02:46.730><c> what</c><00:02:47.269><c> all</c><00:02:47.480><c> of</c><00:02:47.630><c> this</c><00:02:47.750><c> has</c><00:02:47.959><c> to</c><00:02:48.140><c> do</c><00:02:48.260><c> with</c><00:02:48.290><c> the</c>

00:02:48.460 --> 00:02:48.470 align:start position:0%
out what all of this has to do with the
 

00:02:48.470 --> 00:02:51.520 align:start position:0%
out what all of this has to do with the
database<00:02:49.150><c> you</c><00:02:50.150><c> see</c><00:02:50.390><c> each</c><00:02:50.660><c> of</c><00:02:50.720><c> these</c><00:02:51.170><c> three</c>

00:02:51.520 --> 00:02:51.530 align:start position:0%
database you see each of these three
 

00:02:51.530 --> 00:02:53.590 align:start position:0%
database you see each of these three
things<00:02:51.790><c> represents</c><00:02:52.790><c> a</c><00:02:52.910><c> table</c><00:02:53.390><c> in</c><00:02:53.510><c> the</c>

00:02:53.590 --> 00:02:53.600 align:start position:0%
things represents a table in the
 

00:02:53.600 --> 00:02:59.289 align:start position:0%
things represents a table in the
database<00:02:53.720><c> a</c><00:02:56.829><c> table</c><00:02:57.829><c> is</c><00:02:57.980><c> one</c><00:02:58.340><c> logical</c><00:02:58.910><c> unit</c><00:02:59.209><c> of</c>

00:02:59.289 --> 00:02:59.299 align:start position:0%
database a table is one logical unit of
 

00:02:59.299 --> 00:03:01.330 align:start position:0%
database a table is one logical unit of
information<00:02:59.959><c> broken</c><00:03:00.500><c> up</c><00:03:00.890><c> in</c><00:03:01.040><c> rows</c><00:03:01.310><c> and</c>

00:03:01.330 --> 00:03:01.340 align:start position:0%
information broken up in rows and
 

00:03:01.340 --> 00:03:03.699 align:start position:0%
information broken up in rows and
columns<00:03:01.630><c> just</c><00:03:02.630><c> like</c><00:03:02.780><c> a</c><00:03:02.810><c> table</c><00:03:03.290><c> you</c><00:03:03.440><c> may</c><00:03:03.590><c> have</c>

00:03:03.699 --> 00:03:03.709 align:start position:0%
columns just like a table you may have
 

00:03:03.709 --> 00:03:07.390 align:start position:0%
columns just like a table you may have
seen<00:03:03.890><c> an</c><00:03:04.040><c> excel</c><00:03:04.459><c> or</c><00:03:04.700><c> word</c><00:03:05.709><c> the</c><00:03:06.709><c> specific</c>

00:03:07.390 --> 00:03:07.400 align:start position:0%
seen an excel or word the specific
 

00:03:07.400 --> 00:03:10.000 align:start position:0%
seen an excel or word the specific
information<00:03:07.579><c> in</c><00:03:08.239><c> each</c><00:03:08.480><c> table</c><00:03:08.900><c> will</c><00:03:09.620><c> be</c><00:03:09.650><c> the</c>

00:03:10.000 --> 00:03:10.010 align:start position:0%
information in each table will be the
 

00:03:10.010 --> 00:03:12.880 align:start position:0%
information in each table will be the
fields<00:03:10.489><c> you</c><00:03:10.640><c> set</c><00:03:10.880><c> up</c><00:03:11.030><c> later</c><00:03:11.329><c> the</c><00:03:12.290><c> fields</c><00:03:12.799><c> are</c>

00:03:12.880 --> 00:03:12.890 align:start position:0%
fields you set up later the fields are
 

00:03:12.890 --> 00:03:16.560 align:start position:0%
fields you set up later the fields are
the<00:03:13.010><c> small</c><00:03:13.370><c> chunks</c><00:03:14.060><c> of</c><00:03:14.180><c> info</c><00:03:14.630><c> in</c><00:03:14.840><c> each</c><00:03:14.989><c> table</c>

00:03:16.560 --> 00:03:16.570 align:start position:0%
the small chunks of info in each table
 

00:03:16.570 --> 00:03:20.380 align:start position:0%
the small chunks of info in each table
so<00:03:17.570><c> we</c><00:03:17.720><c> have</c><00:03:17.989><c> our</c><00:03:18.200><c> tables</c><00:03:18.829><c> we</c><00:03:19.760><c> said</c><00:03:20.090><c> the</c>

00:03:20.380 --> 00:03:20.390 align:start position:0%
so we have our tables we said the
 

00:03:20.390 --> 00:03:22.690 align:start position:0%
so we have our tables we said the
customer<00:03:20.630><c> table</c><00:03:21.140><c> will</c><00:03:21.470><c> include</c><00:03:21.859><c> name</c><00:03:22.310><c> address</c>

00:03:22.690 --> 00:03:22.700 align:start position:0%
customer table will include name address
 

00:03:22.700 --> 00:03:25.960 align:start position:0%
customer table will include name address
and<00:03:23.269><c> email</c><00:03:23.450><c> in</c><00:03:24.019><c> a</c><00:03:24.620><c> database</c><00:03:24.980><c> it's</c><00:03:25.400><c> easier</c><00:03:25.790><c> to</c>

00:03:25.960 --> 00:03:25.970 align:start position:0%
and email in a database it's easier to
 

00:03:25.970 --> 00:03:27.080 align:start position:0%
and email in a database it's easier to
break<00:03:26.180><c> down</c><00:03:26.480><c> a</c><00:03:26.510><c> few</c>

00:03:27.080 --> 00:03:27.090 align:start position:0%
break down a few
 

00:03:27.090 --> 00:03:31.009 align:start position:0%
break down a few
these<00:03:27.269><c> fields</c><00:03:28.580><c> so</c><00:03:29.580><c> we'll</c><00:03:30.120><c> say</c><00:03:30.420><c> first</c><00:03:30.840><c> name</c>

00:03:31.009 --> 00:03:31.019 align:start position:0%
these fields so we'll say first name
 

00:03:31.019 --> 00:03:36.610 align:start position:0%
these fields so we'll say first name
last<00:03:31.709><c> name</c><00:03:32.040><c> and</c><00:03:33.080><c> for</c><00:03:34.080><c> the</c><00:03:34.140><c> address</c><00:03:34.830><c> we'll</c><00:03:35.580><c> put</c>

00:03:36.610 --> 00:03:36.620 align:start position:0%
last name and for the address we'll put
 

00:03:36.620 --> 00:03:41.000 align:start position:0%
last name and for the address we'll put
Street<00:03:37.620><c> city</c><00:03:38.160><c> state</c><00:03:38.280><c> and</c><00:03:39.209><c> zip</c><00:03:39.410><c> now</c><00:03:40.410><c> the</c><00:03:40.470><c> email</c>

00:03:41.000 --> 00:03:41.010 align:start position:0%
Street city state and zip now the email
 

00:03:41.010 --> 00:03:45.400 align:start position:0%
Street city state and zip now the email
will<00:03:41.340><c> remain</c><00:03:41.700><c> the</c><00:03:41.879><c> same</c><00:03:43.580><c> for</c><00:03:44.580><c> my</c><00:03:44.700><c> orders</c><00:03:45.060><c> table</c>

00:03:45.400 --> 00:03:45.410 align:start position:0%
will remain the same for my orders table
 

00:03:45.410 --> 00:03:47.770 align:start position:0%
will remain the same for my orders table
everything<00:03:46.410><c> could</c><00:03:46.739><c> stay</c><00:03:46.769><c> the</c><00:03:46.890><c> same</c><00:03:47.160><c> for</c><00:03:47.519><c> now</c>

00:03:47.770 --> 00:03:47.780 align:start position:0%
everything could stay the same for now
 

00:03:47.780 --> 00:03:51.369 align:start position:0%
everything could stay the same for now
so<00:03:48.780><c> we'll</c><00:03:48.930><c> just</c><00:03:49.110><c> say</c><00:03:49.319><c> customer</c><00:03:50.069><c> book</c><00:03:50.459><c> and</c><00:03:50.760><c> date</c>

00:03:51.369 --> 00:03:51.379 align:start position:0%
so we'll just say customer book and date
 

00:03:51.379 --> 00:03:54.320 align:start position:0%
so we'll just say customer book and date
my<00:03:52.379><c> books</c><00:03:52.650><c> table</c><00:03:53.069><c> includes</c><00:03:53.459><c> title</c><00:03:54.060><c> author</c>

00:03:54.320 --> 00:03:54.330 align:start position:0%
my books table includes title author
 

00:03:54.330 --> 00:03:57.710 align:start position:0%
my books table includes title author
price<00:03:55.019><c> and</c><00:03:55.349><c> category</c><00:03:56.060><c> title</c><00:03:57.060><c> will</c><00:03:57.209><c> remain</c><00:03:57.510><c> the</c>

00:03:57.710 --> 00:03:57.720 align:start position:0%
price and category title will remain the
 

00:03:57.720 --> 00:04:01.069 align:start position:0%
price and category title will remain the
same<00:03:57.750><c> but</c><00:03:58.379><c> I'll</c><00:03:59.010><c> break</c><00:03:59.370><c> author</c><00:03:59.610><c> into</c><00:04:00.269><c> two</c><00:04:00.540><c> i'll</c>

00:04:01.069 --> 00:04:01.079 align:start position:0%
same but I'll break author into two i'll
 

00:04:01.079 --> 00:04:04.190 align:start position:0%
same but I'll break author into two i'll
have<00:04:01.530><c> author</c><00:04:01.829><c> first</c><00:04:02.310><c> name</c><00:04:02.730><c> and</c><00:04:03.180><c> author</c><00:04:03.630><c> last</c>

00:04:04.190 --> 00:04:04.200 align:start position:0%
have author first name and author last
 

00:04:04.200 --> 00:04:07.130 align:start position:0%
have author first name and author last
name<00:04:04.500><c> and</c><00:04:05.069><c> I'm</c><00:04:06.030><c> going</c><00:04:06.209><c> to</c><00:04:06.269><c> leave</c><00:04:06.450><c> price</c><00:04:06.810><c> and</c>

00:04:07.130 --> 00:04:07.140 align:start position:0%
name and I'm going to leave price and
 

00:04:07.140 --> 00:04:12.920 align:start position:0%
name and I'm going to leave price and
category<00:04:07.709><c> the</c><00:04:08.010><c> same</c><00:04:11.329><c> now</c><00:04:12.329><c> don't</c><00:04:12.569><c> worry</c><00:04:12.780><c> about</c>

00:04:12.920 --> 00:04:12.930 align:start position:0%
category the same now don't worry about
 

00:04:12.930 --> 00:04:14.690 align:start position:0%
category the same now don't worry about
the<00:04:13.290><c> details</c><00:04:13.440><c> of</c><00:04:13.860><c> the</c><00:04:13.980><c> tables</c><00:04:14.400><c> and</c><00:04:14.579><c> fields</c>

00:04:14.690 --> 00:04:14.700 align:start position:0%
the details of the tables and fields
 

00:04:14.700 --> 00:04:17.390 align:start position:0%
the details of the tables and fields
right<00:04:15.060><c> now</c><00:04:15.239><c> we'll</c><00:04:15.870><c> go</c><00:04:16.019><c> over</c><00:04:16.350><c> that</c><00:04:16.560><c> in</c><00:04:16.620><c> our</c><00:04:16.889><c> next</c>

00:04:17.390 --> 00:04:17.400 align:start position:0%
right now we'll go over that in our next
 

00:04:17.400 --> 00:04:20.000 align:start position:0%
right now we'll go over that in our next
lesson<00:04:18.019><c> now</c><00:04:19.019><c> that</c><00:04:19.229><c> we've</c><00:04:19.350><c> played</c><00:04:19.500><c> everything</c>

00:04:20.000 --> 00:04:20.010 align:start position:0%
lesson now that we've played everything
 

00:04:20.010 --> 00:04:22.340 align:start position:0%
lesson now that we've played everything
out<00:04:20.370><c> let's</c><00:04:20.850><c> start</c><00:04:21.120><c> creating</c><00:04:21.269><c> our</c><00:04:21.660><c> database</c><00:04:22.169><c> in</c>

00:04:22.340 --> 00:04:22.350 align:start position:0%
out let's start creating our database in
 

00:04:22.350 --> 00:04:24.530 align:start position:0%
out let's start creating our database in
Access