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
===   ====