Example Database

We will use this example database in various examples. The data is not complete or not necessarily accurate. We will discuss this in detail in class.

MarvelHeroes

hid hero realname
h1 Captain America Steve Rogers
h2 Iron Man Tony Stark
h3 Hulk Bruce Banner
h4 Thor Thor
h5 Hawkeye Clint Barton
h6 Black Widow Natasha Romanoff
h7 Ant-Man Scott Lang
h15 Jessica Jones Jessica Jones

DCHeroes

hid hero realname
h8 Superman Clark Kent
h9 Batman Bruce Wayne
h10 Supergirl Kara Danvers
h11 Flash Barry Allen
h12 Arrow Oliver Queen
h13 Green Lantern Hal Jordan
h14 Wonder Woman Diana Prince

TVHeroes

hid hero realname
h3 Hulk Bruce Banner
h8 Superman Clark Kent
h9 Batman Bruce Wayne
h10 Supergirl Kara Danvers
h11 Flash Barry Allen
h12 Arrow Oliver Queen
h14 Wonder Woman Diana Prince
h15 Jessica Jones Jessica Jones

Movies

mid moviename year
m1 Captain America: The First Avenger 2011
m2 Iron Man 2008
m3 Iron Man 2 2010
m4 The Incredible Hulk 2008
m5 Thor 2011
m6 The Avengers 2012
m7 Iron Man 3 2013
m8 Thor: The Dark World 2013
m9 Captain America: The Winter Soldier 2014
m10 Guardians of the Galaxy 2014
m11 Avengers: Age of Ultron 2015
m12 Ant-Man 2015
m13 Superman Returns 2006
m14 The Dark Knight 2008
m15 Green Lantern 2011
m16 Wonder Woman 2017

TVShows

sid showname hid Channel FirstYear LastYear Ended
s1 Arrow h12 CW 2012 2016 No
s2 The Flash h11 CW 2012 2016 No
s3 Supergirl h10 CBS 2015 2016 No
s4 Gotham h9 FOX 2014 2016 No
s5 Jessica Jones h15 Netflix 2015 2016 No
s6 The Flash h11 CBS 1990 1991 Yes

HeroInMovie

hid mid
h1 m1
h2 m2
h2 m3
h3 m4
h4 m5
h1 m6
h2 m6
h3 m6
h4 m6
h5 m6
h6 m6
h2 m7
h4 m8
h1 m9
h1 m11
h2 m11
h3 m11
h4 m11
h5 m11
h6 m11
h7 m12
h8 m13
h9 m14
h13 m15
h14 m16