## TV_Show

id | Title | Genre | Network | CreatedDate
--- | --- | --- | --- | ---
1 | The Big Bang Theory | Comedy | CBS | 2007-09-24
2 | Friends | Comedy | NBC | 1994-09-22
3 | Breaking Bad | Crime Drama | AMC | 2008-01-20
4 | Game of Thrones | Fantasy Drama | HBO | 2011-04-17
5 | Stranger Things | Mystery Sci-fi | Netflix | 2016-07-15

## Director

id | Name | Birthdate
--- | --- | ---
1 | Chuck Lorre | 1952-10-18
2 | Martin Scorsese | 1942-11-22
3 | Vince Gilligan | 1960-02-10
4 | David Benioff | 1969-09-25
5 | Ronald D. Moore | 1963-07-07

## Editor

id | Name | Birthdate
--- | --- | ---
1 | James Cox | 1972-07-29
2 | Tommy Kendziora | 1977-03-04
3 | Tim Binzer | 1975-02-10
4 | Kelley Dixon | 1965-09-19
5 | Brent Bird | 1970-11-16

## Episode

id | ShowID | EpisodeNumber | Title | ReleaseDate
--- | --- | --- | --- | ---
| (→ TV_Show.id) |  |  |
1 | 1 | 1 | Pilot | 2007-09-24
2 | 1 | 2 | The Big Bang Theory Pilot | 2007-09-27
3 | 2 | 1 | Pilot | 1994-09-22
4 | 2 | 2 | Friends Pilot | 1994-09-22
5 | 3 | 1 | Breaking Bad Pilot | 2008-01-20
6 | 3 | 2 | A No-Good, Very Bad Day | 2008-01-20
7 | 4 | 1 | Winter Is Coming | 2011-04-17
8 | 4 | 2 | The Veldt | 2011-04-24
9 | 5 | 1 | The Vanishing of Will Byers | 2016-07-15
10 | 5 | 2 | The Weirdo on Maple Street | 2016-07-22

## CrewMember

ID | Role | EpisodeID
--- | --- | ---
|  | (→ Episode.id)
1 | Director | 1
2 | Director | 3
3 | Editor | 1
4 | Editor | 2
5 | Director | 4
6 | Director | 5
7 | Editor | 4
8 | Editor | 5
9 | Actor | 2
10 | Writer | 3
11 | Camera Operator | 4