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