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 |