Hey, welcome to the next section.
So I'd like to start off this section by asking you a question.
It's not really a quiz or anything, but I just want to know why there's a chicken on my desk.
And in the meantime, Blue and I are here to talk to you about the next section.
So we're continuing on our trend of working with multiple tables.
We saw a one to many relationship in the last section.
Now we're moving on to a many to many relationship, and I save this one for second.
It's a little more complex.
Don't be afraid.
It's still very doable and very important.
I keep saying that.
Very useful to be able to have multiple tables with the many to many relationship.
So we're going to focus on this section on implementing a schema for TV shows with reviewers and the
reviews that they write.
So think of like, I don't know, Breaking Bad and American Horror Story are two different shows will
have a bunch of them I'll give you data and then ten different human reviewers, maybe a cat or two
as well.
And these reviewers can go and assign ratings to every show.
So I could say this is a ten, that's a nine, that's a four, whatever.
So that's what we're going to implement.
That sort of a schema, which is a many to many relationship.
Hey, hey, hey, hey.
Stop eating that.
Eat the chicken.
So, okay, where was I?
Exercises.
Yes, this section is all exercise.
Basically, the way that I decided to do it is to go through not only building the schema, but also
asking common questions about the data and performing common operations and the joints we want to perform
basically as we go.
So the whole thing acts as a bit of a code long slash exercise.
So hopefully you like television.
If you don't, then this will be a great insight, great window into the world of television for you.
But more importantly, we're talking about joints again, working with multiple tables.
All right.