pPYYkJS8

1use master;
2
3
4IF (EXISTS (SELECT name 
5FROM master.dbo.sysdatabases 
6WHERE name = 'Series_DB'  ))
7drop database Series_DB;  
8
9create  database Series_DB;
10
11use Series_DB;
12
13
14create table Serie(
15	Naam		varchar(255) primary key,
16	Omschrijving text
17);
18
19create table Episode(
20	EpisodeId	int identity(1,1) primary key,
21	Naam		varchar(255),
22	Seizoen		int,
23	Nummer		int,
24	Omschrijving text,
25	airdate		datetime,
26	serie		varchar(255) references serie(Naam)
27);
28
29create table Acteur(
30	naam		varchar(255),
31	Bio			text,
32	Geboortedatum datetime,
33	ActeurId	int identity(1,1),
34	primary key(ActeurId));
35
36create table ActeurEpisode(
37	Acteur		int references Acteur(ActeurId),
38	Episode		int references Episode(EpisodeId),
39	primary key(Acteur,Episode)
40)
41
42-- Naam, Omschrijving
43insert into Serie values('Lucifer', 'Lucifer takes up residence in Los Angeles.');
44insert into Serie values('Close to the enemy', 'A British intelligence officer has to ensure that a captured German scientist helps the British develop jet aircraft.');
45insert into Serie values('Supernatural', N'Two brothers follow their fathers footsteps as "hunters" fighting evil supernatural beings of many kinds including monsters, demons, and gods that roam the earth.');
46insert into Serie values('Game of Thrones', 'While a civil war brews between several noble families in Westeros, the children of the former rulers of the land attempt to rise to power.');
47insert into Serie values('South Park', 'Follows the misadventures of four irreverent grade-schoolers in the quiet, dysfunctional town of South Park, Colorado.');
48insert into Serie values('Vikings', 'The world of the Vikings is brought to life through the journey of Ragnar Lothbrok, the first Viking to emerge from Norse legend and onto the pages of history - a man on the edge of myth.');
49insert into Serie values('Modern Family', 'Three different, but related families face trials and tribulations in their own uniquely comedic ways.');
50insert into Serie values('Doctor Who (2005)', 'The adventures of the Doctor, who is a time travelling alien from the planet Gallifrey. He has commons and space and lots more');
51insert into Serie values('The Grand Tour', 'Follow Jeremy, Richard, and James, as they embark on an adventure across the globe. Driving new and exciting automobiles from manufactures all over the world.');
52-- Naam, Seizoen, Ep nummer, Omschrijving, Air date, Serie
53insert into Episode values('Pilot',1,1,'Lucifer has left Hell to take up a life on Earth. When a friend of his is murdered Lucifer joins forces with the good side of the law to discover who the perpetrators are and to give them what they rightfully deserve.','2016-01-25','Lucifer')
54insert into Episode values('Lucifer, Stay. Good Devil.',1,2,'When a movie stars son is killed after being chased by the paparazzi, Chloe takes a deep look into the case with a little help from Lucifer. Meanwhile, Maze and Amenadiel continue to encourage Lucifer to go back to hell.','2016-02-01','Lucifer')
55insert into Episode values('The would-be Prince of Darkness',1,3,'An up-and-coming quarterback calls Lucifer after finding a corpse in his pool; Lucifer asks Chloe to help investigate, which leads them into the world of big-money sports.','2016-02-08','Lucifer')
56insert into Episode values('Manly Whatnots',1,4,'In an effort to get over his infatuation with Chloe, Lucifer decides that he must seduce her. Meanwhile, the two team up on a missing girl case and Amenadiel confronts Maze about his concerns about Lucifer.','2016-02-15','Lucifer')
57insert into Episode values('Everythings Coming Up Lucifer',2,1,'Lucifer and Chloe look into the murder of a stand-in actress; Chloes faith in Lucifer is tested.','2016-09-19','Lucifer')
58insert into Episode values('Liar, Liar, Slutty Dress on Fire',2,2,'Lucifer suspects his mother may be involved in a ghastly murder for which she claims shes innocent.','2016-10-03','Lucifer')
59insert into Episode values('Sin-Eater',2,3,'Lucifer and Chloe investigate a gruesome murder after a video of the crime surfaces on social media. When a second video appears, they realize they have a serial killer on their hands.','2016-10-10','Lucifer')
60insert into Episode values('Episode #1.1',1,1,'Military Intelligence officer, Captain Callum Ferguson has been given just 6 days to persuade a German scientist to work for the British. His task is complicated by the scientists young daughter and a determined war crimes investigator.','2016-11-10','Close to the enemy')
61insert into Episode values('Episode #1.2',1,2,'Callum employs unorthodox methods to try to convince Dieter to work for the British, ultimately putting Lottie at risk. Kathy continues to seek evidence that the Government is harbouring war criminals in the name of science.','2016-11-17','Close to the enemy')
62insert into Episode values('Pilot',1,1,'Sam and Dean Winchester were trained by their father to hunt the creatures of the supernatural. Now, their father has mysteriously disappeared while hunting the demon that killed their mother, 22 years ago.','2005-09-13','Supernatural')
63insert into Episode values('Out of the Darkness, Into the Fire',11,1,'Dean and Sam dealing with the aftermath of freeing the darkness on earth.','2015-10-07','Supernatural')
64insert into Episode values('Exile on Main St.',6,1,'One year ago, Dean moved to Lisas house to live a normal, "apple-pie" life with Lisa and her son Ben, as recommended by Sam, working as a construction worker. One day, Dean finds scratches of Djinn in several places and he chases the supernatural being. When his is attacked by the Djinn, he is saved by Sam that tells him that he was released from hell one year ago and teamed-up with their Grandfather Samuel and three Campbells. Now Dean has to decide whether he wishes to leave Lisa and Ben to hunt demons again or stay with his regular life.','2010-09-24','Supernatural')
65insert into Episode values('Two and a half men',6,2,'When four families are killed and their babies are missing, Sam finds that a security company may be involved in the case and summons Dean to help him to bring the baby of a fifth slaughtered family to Samuel. However they are chased by a powerful shape shifter that wants the baby and they discover that the baby is a new breed.','2010-10-01','Supernatural')
66insert into Episode values('Winter is Coming',1,1,'Jon Arryn, the Hand of the King, is dead. King Robert Baratheon plans to ask his oldest friend, Eddard Stark, to take Jons place. Across the sea, Viserys Targaryen plans to wed his sister to a nomadic warlord in exchange for an army.','2011-04-17','Game of Thrones')
67insert into Episode values('The Kingsroad',1,2,'While Bran recovers from his fall, Ned takes only his daughters to Kings Landing. Jon Snow goes with his uncle Benjen to The Wall. Tyrion joins them.','2011-04-24','Game of Thrones')
68insert into Episode values('Lord Snow',1,3,'Lord Stark and his daughters arrive at Kings Landing to discover the intrigues of the kings realm.','2011-05-01','Game of Thrones')
69insert into Episode values('Valar Dohaeris',3,1,'Jon is brought before Mance Rayder, the King Beyond the Wall, while the Nights Watch survivors retreat south. In Kings Landing, Tyrion asks for his reward. Littlefinger offers Sansa a way out.','2013-03-31','Game of Thrones')
70insert into Episode values('Dark Wings, Dark Words',3,2,'Bran and company meet Jojen and Meera Reed. Arya, Gendry, and Hot Pie meet the Brotherhood. Jaime travels through the wilderness with Brienne. Sansa confesses her true feelings about Joffery to Margaery.','2013-04-07','Game of Thrones')
71insert into Episode values('Walk of Punishment',3,3,'Robb and Catelyn arrive at Riverrun for Lord Hoster Tullys funeral. Tywin names Tyrion the new Master of Coin. Arya says goodbye to Hot Pie. The Nights Watch returns to Crasters. Brienne and Jamie are taken prisoner.','2013-04-14','Game of Thrones')
72insert into Episode values('Go Fund Yourself',18,1,'The boys use Kickstarter to fund themselves so they can sit on their butts and do absolutely nothing, but when Eric uses the name Washington Redskins, the owner of the Redskins is determined to stop him.','2014-09-24','South Park')
73insert into Episode values('Stunning and Brave',19,1,'The boys show their respect for Caitlyn Jenner when a new principal makes them atone for a history of prejudice.','2015-09-16','South Park')
74insert into Episode values('Where My Country Gone?',19,2,'Garrison decides he wants to build a wall to keep out all the undocumented immigrants.','2015-09-23','South Park')
75insert into Episode values('The City Part of Town',19,3,'With the town of South Park gentrifying, Kenny decides to get a job at City Wok.','2015-09-30','South Park')
76insert into Episode values('You are Not Yelping',19,4,'Cartman considers himself the top online restaurant reviewer in South Park.','2015-10-14','South Park')
77insert into Episode values('Rites of Passage',1,1,'Ragnar goes on a trip of initiation with his son. Meanwhile, he thinks he has finally found a way to sail ships to the west. However, his beliefs are seen as insane so he chooses to go against the law.','2013-03-03','Vikings')
78insert into Episode values('Wrath of the Northmen',1,2,'The stage is set for the first journey west by Ragnar Lothbrok as he gathers a crew willing to risk their lives to travel into the unknown.','2013-03-10','Vikings')
79insert into Episode values('Dispossessed',1,3,'A monastery in Lindesfarne, England is about to get a firsthand look at how the Vikings operate.','2013-03-17','Vikings')
80insert into Episode values('Trial',1,4,'The Vikings head back to England to see what other treasures this new world has to offer. This go round Ragnar and his crew sail out with Earl Haraldsons permission.','2013-03-24','Vikings')
81insert into Episode values('Raid',1,5,'In the Great Hall of Kattegat, a seer reads Earl Haraldsons future and tells him that Ragnar Lothbrok searches for his death.','2013-03-31','Vikings')
82insert into Episode values('Pilot',1,1,'Jay must adapt to his young new wife, Gloria and her son. Meanwhile, Claire deals with her own family. Mitchell and Cam decide to adopt a baby.','2009-09-23','Modern Family')
83insert into Episode values('The Bicycle Thief',1,2,'After buying a new bike for his son, Phil ends up lying when it gets stolen. Jay tries bonding with Manny. Cam and Mitchell begin daycare classes for Lily.','2009-09-30','Modern Family')
84insert into Episode values('Come Fly WIth Me',1,3,'Jay takes Phil on a model-airplane excursion with disastrous results. While Manny is at their house, Claire must get used to the fact they are actually siblings.','2009-10-07','Modern Family')
85insert into Episode values('The Incident',1,4,'Jays ex-wife shows up for the first time following a nasty incident at Gloria and Jays wedding.','2009-10-14','Modern Family')
86insert into Episode values('Rose',1,1,'Rose Tyler is just an ordinary shop worker living an ordinary life in 21st century Britain. But that life is turned upside down when a strange man calling himself The Doctor drags her into an alien invasion attempt!','2005-03-17','Doctor Who (2005)')
87insert into Episode values('Blink',3,10,'Sally Sparrow receives a cryptic message from the Doctor about a mysterious new enemy species that is after the TARDIS.','2007-06-09','Doctor Who (2005)')
88insert into Episode values('Voyage of the Damned',4,1,'The Doctor finds his TARDIS colliding with a spaceship based on the RMS Titanic during a Christmas party. With the help of a waitress named Astrid, the Doctor must take on the race called the Hosts as the lives of the Titanic crew and those on Earth are in danger.','2008-04-18','Doctor Who (2005)')
89insert into Episode values('Partners in Crime',4,2,'With a new weight-loss pill tested in London by Adipose Industries, The Doctor goes to investigate the sinister truth behind the product, only to find out that his old friend Donna Noble is investigating as well.','2008-04-25','Doctor Who (2005)')
90insert into Episode values('The Fires of Pompeii',4,3,'The Doctor and Donna visit Pompeii in AD 79, on the eve of the eruption of Mount Vesuvius.','2008-05-02','Doctor Who (2005)')
91insert into Episode values('The Holy Trinity',1,1,'The Grand Tour kicks off in California, USA, when Jeremy Clarkson, Richard Hammond and James May take their famous studio tent to Dry Rabbit Lake. Hundreds of fans from across the U.S. traveled to the desert, near Lucerne Valley, outside of Los Angeles, California to be part of the first ever episode of Jeremy, Richard and James new show for Amazon Prime.','2016-11-18','The Grand Tour')
92
93--Naam, Bio geboortedatum
94insert into Acteur (Naam,Bio, Geboortedatum) values('Tom Ellis','He is an actor, known for Lucifer (2015), Buffalo Soldiers (2001) and Miranda (2009). He was previously married to Tamzin Outhwaite.','1978-11-17')
95insert into Acteur (Naam,Bio, Geboortedatum) values('Lauren German','German attended the prominent Actors Studio and attended USC. Lauren also trained as a dancer at the Orange County High School of the Arts (a.k.a. OCHSA). ','1978-11-29')
96insert into Acteur (Naam,Bio, Geboortedatum) values('August Diehl','He is an actor and writer, known for Inglourious Basterds (2009), Salt (2010) and The Counterfeiters (2007). He is married to Julia Malik. They have one child.','1976-01-04')
97insert into Acteur (Naam,Bio, Geboortedatum) values('Jim Sturgess','Jim was born in London, the son of Jane O. (Martin) and Peter J. S. Sturgess. He was raised in Surrey. First and foremost his interest was music. However, he began to develop a secret passion for acting, at age 8, when he auditioned for local theatre to get out of class.','1978-05-16')
98insert into Acteur (Naam,Bio, Geboortedatum) values('Jensen Ackles','He has English, German, and Scottish ancestry. Jensen grew up in Richardson, Texas, together with his older brother, Joshua, and a younger sister, Mackenzie.','1978-03-01')
99insert into Acteur (Naam,Bio, Geboortedatum) values('Jared Padalecki','Jared Padalecki was born in San Antonio, Texas, to Sherri (Kammer), a teacher of English, and Gerald Padalecki, a tax accountant. He is of Polish (father) and German, English, Scottish, and French (mother) descent. Jared started to take acting lessons when he was 12.','1982-07-19')
100insert into Acteur (Naam,Bio, Geboortedatum) values('Misha Collins','Misha Collins is an American actor best known for his role as the angel Castiel on the TV series Supernatural (2005). ','1974-08-20')
101insert into Acteur (Naam,Bio, Geboortedatum) values('Jim Beaver','Jim Beaver is an American character actor, best known for his leading roles on the TV series Deadwood (2004) and Supernatural (2005). ','1950-08-12')
102insert into Acteur (Naam,Bio, Geboortedatum) values('James May','James May was born in the 18th century in the British city of Bristol. He studied music at university, although secretly he was thinking about old motorcycles.','1963-01-16')
103insert into Acteur (Naam,Bio, Geboortedatum) values('Richard Hammond','Richard Hammond was born in 1969 in the British town of Solihull, which is near to Birmingham although it tries to pretend that it isnt. ','1969-12-19')
104insert into Acteur (Naam,Bio, Geboortedatum) values('Jeremy Clarkson','Jeremy Clarkson was born in 1960 in the Yorkshire town of Doncaster in the North of England, an area renowned for its loud shouting and rampant exaggeration.','1960-04-11')
105--ActeurId, EpisodeId
106insert into ActeurEpisode values(1,1)
107insert into ActeurEpisode values(2,1)
108insert into ActeurEpisode values(2,2)
109insert into ActeurEpisode values(1,2)
110insert into ActeurEpisode values(9,39)
111insert into ActeurEpisode values(10,39)
112insert into ActeurEpisode values(11,39)