1
00:00:00,450 --> 00:00:02,190
Hey, welcome to the next section.

2
00:00:02,370 --> 00:00:05,689
So I'd like to start off this section by asking you a question.

3
00:00:05,700 --> 00:00:10,650
It's not really a quiz or anything, but I just want to know why there's a chicken on my desk.

4
00:00:11,160 --> 00:00:15,800
And in the meantime, Blue and I are here to talk to you about the next section.

5
00:00:15,870 --> 00:00:20,060
So we're continuing on our trend of working with multiple tables.

6
00:00:20,070 --> 00:00:23,280
We saw a one to many relationship in the last section.

7
00:00:23,280 --> 00:00:27,690
Now we're moving on to a many to many relationship, and I save this one for second.

8
00:00:27,690 --> 00:00:29,000
It's a little more complex.

9
00:00:29,010 --> 00:00:30,390
Don't be afraid.

10
00:00:30,720 --> 00:00:33,270
It's still very doable and very important.

11
00:00:33,360 --> 00:00:34,110
I keep saying that.

12
00:00:34,110 --> 00:00:38,820
Very useful to be able to have multiple tables with the many to many relationship.

13
00:00:38,820 --> 00:00:45,630
So we're going to focus on this section on implementing a schema for TV shows with reviewers and the

14
00:00:45,630 --> 00:00:47,160
reviews that they write.

15
00:00:47,160 --> 00:00:53,010
So think of like, I don't know, Breaking Bad and American Horror Story are two different shows.

16
00:00:53,010 --> 00:00:53,940
We'll have a bunch of them.

17
00:00:53,940 --> 00:00:58,740
I'll give you data and then ten different human reviewers, maybe a cat or two as well.

18
00:00:58,740 --> 00:01:03,510
And these reviewers can go and assign ratings to every show.

19
00:01:03,630 --> 00:01:07,620
So I could say this is a ten, That's a nine, that's a four, whatever.

20
00:01:08,040 --> 00:01:12,280
So that's what we're going to implement that sort of a schema, which is a many to many relationship.

21
00:01:12,300 --> 00:01:13,470
Hey, hey, hey, hey.

22
00:01:13,980 --> 00:01:14,760
Stop eating that.

23
00:01:16,150 --> 00:01:16,870
Eat the chicken.

24
00:01:17,270 --> 00:01:19,150
So where was I?

25
00:01:20,470 --> 00:01:21,250
Exercises?

26
00:01:21,250 --> 00:01:21,700
Yes.

27
00:01:21,700 --> 00:01:23,880
This section is all exercise.

28
00:01:23,890 --> 00:01:30,010
Basically, the way that I decided to do it is to go through not only building the schema, but also

29
00:01:30,010 --> 00:01:35,230
asking common questions about the data and performing common operations and the joints we want to perform

30
00:01:35,230 --> 00:01:36,910
basically as we go.

31
00:01:36,910 --> 00:01:41,020
So the whole thing acts as a bit of a code slash exercise.

32
00:01:41,530 --> 00:01:43,480
So hopefully you like television.

33
00:01:43,480 --> 00:01:49,390
If you don't, then this will be a great insight, great window into the world of television for you.

34
00:01:49,390 --> 00:01:53,650
But more importantly, we're talking about joints again, working with multiple tables.

35
00:01:53,650 --> 00:01:54,220
All right.