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