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

2
00:00:02,370 --> 00:00:05,700
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,860
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,070
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,010
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,190
So think of like, I don't know, Breaking Bad and American Horror Story are two different shows will

16
00:00:53,190 --> 00:00:58,200
have a bunch of them I'll give you data and then ten different human reviewers, maybe a cat or two

17
00:00:58,200 --> 00:00:58,740
as well.

18
00:00:58,740 --> 00:01:03,540
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,010 --> 00:01:09,300
So that's what we're going to implement.

21
00:01:09,300 --> 00:01:12,270
That sort of a schema, which is a many to many relationship.

22
00:01:12,310 --> 00:01:13,470
Hey, hey, hey, hey.

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

24
00:01:16,140 --> 00:01:16,860
Eat the chicken.

25
00:01:17,250 --> 00:01:19,140
So, okay, where was I?

26
00:01:20,460 --> 00:01:21,270
Exercises.

27
00:01:21,270 --> 00:01:23,910
Yes, this section is all exercise.

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

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

30
00:01:35,220 --> 00:01:36,900
basically as we go.

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

32
00:01:41,520 --> 00:01:43,470
So hopefully you like television.

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

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

35
00:01:53,640 --> 00:01:54,210
All right.