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 |