Oracle Assignment

IMDB_Data.sql

DELETE FROM tblKeyWordDetail; DELETE FROM tblKeyWord; DELETE FROM tblActorDetail; DELETE FROM tblActor; DELETE FROM tblGenreDetail; DELETE FROM tblGenre; DELETE FROM tblWriterDetail; DELETE FROM tblWriter; DELETE FROM tblAwardDetail; DELETE FROM tblAwardResult; DELETE FROM tblAwardCategoryDesc; DELETE FROM tblAwardType; DELETE FROM tblReview; DELETE FROM tblCritic; DELETE FROM tblCriticClass; DELETE FROM tblMovie; DELETE FROM tblDirector; DELETE FROM tblMPAA; COMMIT; PAUSE Existing data deleted. Press [Enter] INSERT INTO tblKeyword VALUES (1,'Chase'); INSERT INTO tblKeyword VALUES (2,'Oklahoma'); INSERT INTO tblKeyword VALUES (3,'Waitress'); INSERT INTO tblKeyword VALUES (4,'Hell'); INSERT INTO tblKeyword VALUES (5,'Satanic Cult'); INSERT INTO tblKeyword VALUES (6,'Agent'); INSERT INTO tblKeyword VALUES (7,'CIA'); INSERT INTO tblKeyword VALUES (8,'France'); INSERT INTO tblKeyword VALUES (9,'Prostitution'); INSERT INTO tblKeyword VALUES (10,'Albanian'); INSERT INTO tblKeyword VALUES (11,'Pizza Delivery'); INSERT INTO tblKeyword VALUES (12,'Heist'); INSERT INTO tblKeyword VALUES (13,'Scheme'); INSERT INTO tblKeyword VALUES (14,'Pizza Delivery Boy'); INSERT INTO tblKeyword VALUES (15,'Invasion'); INSERT INTO tblKeyword VALUES (16,'General'); INSERT INTO tblKeyword VALUES (17,'Killed In Action'); PAUSE Keywords Created. Press [Enter] INSERT INTO tblCriticClass VALUES (1,'Critic'); INSERT INTO tblCriticClass VALUES (2,'User'); DELETE FROM tblCritic; INSERT INTO tblCritic VALUES (1,'','','User1',2); INSERT INTO tblCritic VALUES (2,'','','User2',2); INSERT INTO tblCritic VALUES (3,'','','User3',2); INSERT INTO tblCritic VALUES (4,'','','User4',2); INSERT INTO tblCritic VALUES (5,'','','User5',2); INSERT INTO tblCritic VALUES (6,'','','User6',2); INSERT INTO tblCritic VALUES (7,'','','User7',2); INSERT INTO tblCritic VALUES (8,'','','User8',2); INSERT INTO tblCritic VALUES (9,'','','User9',2); INSERT INTO tblCritic VALUES (10,'','','User10',2); INSERT INTO tblCritic VALUES (11,'','','User11',2); INSERT INTO tblCritic VALUES (12,'','','User12',2); INSERT INTO tblCritic VALUES (13,'','','User13',2); INSERT INTO tblCritic VALUES (14,'','','User14',2); INSERT INTO tblCritic VALUES (15,'','','User15',2); INSERT INTO tblCritic VALUES (16,'','','User16',2); INSERT INTO tblCritic VALUES (17,'','','User17',2); INSERT INTO tblCritic VALUES (18,'','','User18',2); INSERT INTO tblCritic VALUES (19,'','','User19',2); INSERT INTO tblCritic VALUES (20,'','','User20',2); INSERT INTO tblCritic VALUES (21,'','','User21',2); INSERT INTO tblCritic VALUES (22,'','','User22',2); INSERT INTO tblCritic VALUES (23,'','','User23',2); INSERT INTO tblCritic VALUES (24,'','','User24',2); INSERT INTO tblCritic VALUES (25,'','','User25',2); INSERT INTO tblCritic VALUES (26,'','','User26',2); INSERT INTO tblCritic VALUES (27,'','','User27',2); INSERT INTO tblCritic VALUES (28,'Roger','Ebert','',1); INSERT INTO tblCritic VALUES (29,'Peter','Travers','',1); INSERT INTO tblCritic VALUES (30,'Stephanie','Zacharek','',1); INSERT INTO tblCritic VALUES (31,'Mick','LaSalle','',1); INSERT INTO tblCritic VALUES (32,'Claude','Puig','',1); INSERT INTO tblCritic VALUES (33,'','','Screen It!',1); INSERT INTO tblCritic VALUES (34,'','','Urban Cinefile',1); INSERT INTO tblCritic VALUES (35,'','','FlickFile',1); INSERT INTO tblCritic VALUES (36,'Jennifer','Fallon','',1); PAUSE Critic data created. Press [Enter] INSERT INTO tblGenre VALUES (1,'Action'); INSERT INTO tblGenre VALUES (2,'Comedy'); INSERT INTO tblGenre VALUES (3,'Family'); INSERT INTO tblGenre VALUES (4,'History'); INSERT INTO tblGenre VALUES (5,'Mystery'); INSERT INTO tblGenre VALUES (6,'Sci-Fi'); INSERT INTO tblGenre VALUES (7,'War'); INSERT INTO tblGenre VALUES (8,'Adventure'); INSERT INTO tblGenre VALUES (9,'Crime'); INSERT INTO tblGenre VALUES (10,'Fantasy'); INSERT INTO tblGenre VALUES (11,'Horror'); INSERT INTO tblGenre VALUES (12,'News'); INSERT INTO tblGenre VALUES (13,'Sport'); INSERT INTO tblGenre VALUES (14,'Western'); INSERT INTO tblGenre VALUES (15,'Animation'); INSERT INTO tblGenre VALUES (16,'Documentary'); INSERT INTO tblGenre VALUES (17,'Film-Noir'); INSERT INTO tblGenre VALUES (18,'Musical'); INSERT INTO tblGenre VALUES (19,'Biography'); INSERT INTO tblGenre VALUES (20,'Romance'); INSERT INTO tblGenre VALUES (21,'Thriller'); INSERT INTO tblGenre VALUES (22,'Drama'); PAUSE Genre data created. Press [Enter] INSERT INTO tblAwardType VALUES (1,'Academy of Motion Picture Arts and Sciences','Oscar'); INSERT INTO tblAwardType VALUES (2,'Academy of Science Fiction, Fantasy, and Horror Films','Saturn'); INSERT INTO tblAwardType VALUES (3,'Genie',''); INSERT INTO tblAwardType VALUES (4,'American Film Institute','AFI'); INSERT INTO tblAwardType VALUES (5,'Golden Raspberry Award','Razzie'); INSERT INTO tblAwardType VALUES (6,'Toronto International Film Festival','TIFF'); INSERT INTO tblAwardType VALUES (7,'Sundance Film Festival',''); INSERT INTO tblAwardType VALUES (8,'Art Directors Guild',''); INSERT INTO tblAwardType VALUES (9,'Directors Guild of America',''); INSERT INTO tblAwardType VALUES (10,'Hollywood Foreign Press Association','Golden Globe'); INSERT INTO tblAwardType VALUES (11,'International Animated Film Society','Annie'); INSERT INTO tblAwardType VALUES (12,'Screen Actors Guild',''); INSERT INTO tblAwardType VALUES (13,'Nickelodeon','Kid''s Choice Awards'); INSERT INTO tblAwardType VALUES (14,'Fox','Teen Choice Awards'); INSERT INTO tblAwardType VALUES (15,'Procter and Gamble','People''s Choice Awards'); INSERT INTO tblAwardType VALUES (16,'BMI Film and TV',''); INSERT INTO tblAwardType VALUES (17,'Austin Fantastic Fest',''); INSERT INTO tblAwardType VALUES (18,'Chicago International Film Festival',''); INSERT INTO tblAwardType VALUES (19,'Toronto After Dark Film Festival',''); INSERT INTO tblAwardType VALUES (20,'NCLR Alma',''); INSERT INTO tblAwardType VALUES (21,'Empire Awards - UK',''); INSERT INTO tblAwardType VALUES (22,'Hugo Awards',''); INSERT INTO tblAwardType VALUES (23,'MTV Movie Awards',''); INSERT INTO tblAwardType VALUES (24,'Phoenix Film Critics Society',''); INSERT INTO tblAwardType VALUES (25,'Visual Effects Society Awards',''); INSERT INTO tblAwardType VALUES (26,'Science Fiction and Fantasy Writers of America',''); INSERT INTO tblAwardType VALUES (27,'Broadcast Film Critics Association Awards','Critics Choice Awards'); PAUSE Award types created. Press [Enter] INSERT INTO tblAwardCategoryDesc VALUES (1,'Favorite Movie',13); INSERT INTO tblAwardCategoryDesc VALUES (2,'Favorite Movie Actor',13); INSERT INTO tblAwardCategoryDesc VALUES (3,'Favorite Movie Actress',13); INSERT INTO tblAwardCategoryDesc VALUES (4,'Hall of Fame Award',13); INSERT INTO tblAwardCategoryDesc VALUES (5,'Wannabe Award',13); INSERT INTO tblAwardCategoryDesc VALUES (6,'Cutest Couple',13); INSERT INTO tblAwardCategoryDesc VALUES (7,'Favorite Animated Movie',13); INSERT INTO tblAwardCategoryDesc VALUES (8,'Favorite Voice from an Animated Movie',13); INSERT INTO tblAwardCategoryDesc VALUES (9,'Favorite Buttkicker',13); INSERT INTO tblAwardCategoryDesc VALUES (10,'Choice Movie: Action',14); INSERT INTO tblAwardCategoryDesc VALUES (11,'Choice Movie: Action Actor',14); INSERT INTO tblAwardCategoryDesc VALUES (12,'Choice Movie: Action Actress',14); INSERT INTO tblAwardCategoryDesc VALUES (13,'Choice Movie: Drama',14); INSERT INTO tblAwardCategoryDesc VALUES (14,'Choice Movie: Drama Actor',14); INSERT INTO tblAwardCategoryDesc VALUES (15,'Choice Movie: Drama Actress',14); INSERT INTO tblAwardCategoryDesc VALUES (16,'Choice Movie: Romantic Comedy',14); INSERT INTO tblAwardCategoryDesc VALUES (17,'Choice Movie: Romantic Comedy Actor',14); INSERT INTO tblAwardCategoryDesc VALUES (18,'Choice Movie: Romantic Comedy Actress',14); INSERT INTO tblAwardCategoryDesc VALUES (19,'Choice Movie: Thriller',14); INSERT INTO tblAwardCategoryDesc VALUES (20,'Choice Movie: Thriller Actor',14); INSERT INTO tblAwardCategoryDesc VALUES (21,'Choice Movie: Thriller Actress',14); INSERT INTO tblAwardCategoryDesc VALUES (22,'Choice Movie: Comedy',14); INSERT INTO tblAwardCategoryDesc VALUES (23,'Choice Movie: Comedy Actor',14); INSERT INTO tblAwardCategoryDesc VALUES (24,'Choice Movie: Comedy Actress',14); INSERT INTO tblAwardCategoryDesc VALUES (25,'Choice Movie: Fantasy',14); INSERT INTO tblAwardCategoryDesc VALUES (26,'Choice Movie: Fantasy Actor',14); INSERT INTO tblAwardCategoryDesc VALUES (27,'Choice Movie: Fantasy Actress',14); INSERT INTO tblAwardCategoryDesc VALUES (28,'Choice Movie: Sci-Fi',14); INSERT INTO tblAwardCategoryDesc VALUES (29,'Choice Movie: Sci-Fi Actor',14); INSERT INTO tblAwardCategoryDesc VALUES (30,'Choice Movie: Sci-Fi Actress',14); INSERT INTO tblAwardCategoryDesc VALUES (31,'Choice Movie: Breakout Male',14); INSERT INTO tblAwardCategoryDesc VALUES (32,'Choice Movie: Breakout Female',14); INSERT INTO tblAwardCategoryDesc VALUES (33,'Choice Movie: Chemistry',14); INSERT INTO tblAwardCategoryDesc VALUES (34,'Choice Movie: Liplock',14); INSERT INTO tblAwardCategoryDesc VALUES (35,'Choice Movie: Fight',14); INSERT INTO tblAwardCategoryDesc VALUES (36,'Choice Movie: Villain',14); INSERT INTO tblAwardCategoryDesc VALUES (37,'Choice Movie: Animated',14); INSERT INTO tblAwardCategoryDesc VALUES (38,'Choice Movie: Hissy Fit',14); INSERT INTO tblAwardCategoryDesc VALUES (39,'Best Science Fiction Film',2); INSERT INTO tblAwardCategoryDesc VALUES (40,'Best Fantasy Film',2); INSERT INTO tblAwardCategoryDesc VALUES (41,'Best Horror-Thriller Film',2); INSERT INTO tblAwardCategoryDesc VALUES (42,'Best Action-Adventure Film',2); INSERT INTO tblAwardCategoryDesc VALUES (43,'Best Actor',2); INSERT INTO tblAwardCategoryDesc VALUES (44,'Best Actress',2); INSERT INTO tblAwardCategoryDesc VALUES (45,'Best Supporting Actor',2); INSERT INTO tblAwardCategoryDesc VALUES (46,'Best Supporting Actress',2); INSERT INTO tblAwardCategoryDesc VALUES (47,'Best Performance by a Younger Actor',2); INSERT INTO tblAwardCategoryDesc VALUES (48,'Best Director',2); INSERT INTO tblAwardCategoryDesc VALUES (49,'Best Writing',2); INSERT INTO tblAwardCategoryDesc VALUES (50,'Best Music',2); INSERT INTO tblAwardCategoryDesc VALUES (51,'Best Production Design',2); INSERT INTO tblAwardCategoryDesc VALUES (52,'Best Editing',2); INSERT INTO tblAwardCategoryDesc VALUES (53,'Best Costume',2); INSERT INTO tblAwardCategoryDesc VALUES (54,'Best Make-Up',2); INSERT INTO tblAwardCategoryDesc VALUES (55,'Best Special Effects',2); INSERT INTO tblAwardCategoryDesc VALUES (56,'Best International Film',2); INSERT INTO tblAwardCategoryDesc VALUES (57,'Best Animated Film',2); INSERT INTO tblAwardCategoryDesc VALUES (58,'BMI Film Music',16); INSERT INTO tblAwardCategoryDesc VALUES (60,'Best Horror Film (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (61,'Best Sci-Fi Film (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (62,'Best Action Film (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (63,'Best Comedy (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (64,'Best Director (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (65,'Best Screenplay (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (66,'Best Canadian Feature Film (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (67,'Best Leading Actor (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (68,'Best Leading Actress (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (69,'Best Ensemble Cast (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (70,'Best Make-Up (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (71,'Best Special Effects (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (72,'Best Soundtrack (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (73,'Best Cinematography (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (74,'Best Editing (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (75,'Best Trailer (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (76,'Best Poster (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (77,'Best Title Sequence (Fan Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (78,'Best Feature Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (79,'Best Canadian Short Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (80,'Best International Short Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (81,'Best Film to Watch with a Crowd (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (82,'Film Most Like to See a Sequel To (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (83,'Best Villain (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (84,'Best Hero (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (85,'Best Antihero (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (86,'Best Kill (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (87,'Best Fight (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (88,'Goriest Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (89,'Scariest Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (90,'Most Innovative Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (91,'Most Disturbing Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (92,'Most Thrilling Film (Audience Choice)',19); INSERT INTO tblAwardCategoryDesc VALUES (93,'After Dark Competition (Silver Hugo)',18); INSERT INTO tblAwardCategoryDesc VALUES (94,'Best Actor - Feature (Horror Jury)',17); INSERT INTO tblAwardCategoryDesc VALUES (95,'Favorite Movie',20); INSERT INTO tblAwardCategoryDesc VALUES (96,'Favorite Movie Actress - Drama/Adventure',20); INSERT INTO tblAwardCategoryDesc VALUES (97,'Best Sci-Fi/Fantasy',21); INSERT INTO tblAwardCategoryDesc VALUES (98,'Best Dramatic Presentation - Long Form',22); INSERT INTO tblAwardCategoryDesc VALUES (99,'Best Hero',23); INSERT INTO tblAwardCategoryDesc VALUES (100,'Best Original Song',24); INSERT INTO tblAwardCategoryDesc VALUES (101,'Fantasy Film - Excellence in Production Design',8); INSERT INTO tblAwardCategoryDesc VALUES (102,'Choice Summer Movie',14); INSERT INTO tblAwardCategoryDesc VALUES (103,'Choice Summer Movie Star: Male',14); INSERT INTO tblAwardCategoryDesc VALUES (104,'Choice Summer Movie Star: Female',14); INSERT INTO tblAwardCategoryDesc VALUES (105,'Outstanding Composting in a Feature Motion Picture',25); INSERT INTO tblAwardCategoryDesc VALUES (106,'Outstanding Visual Effects in a Visual Effects Driven Feature Motion Picture',25); INSERT INTO tblAwardCategoryDesc VALUES (107,'Ray Bradbury Award',26); INSERT INTO tblAwardCategoryDesc VALUES (108,'Best Comedy Movie',27); INSERT INTO tblAwardCategoryDesc VALUES (109,'Favorite Comedy Movie',15); INSERT INTO tblAwardCategoryDesc VALUES (110,'Favorite On Screen Team',15); INSERT INTO tblAwardCategoryDesc VALUES (111,'Worst Actor',5); INSERT INTO tblAwardCategoryDesc VALUES (112,'Worst Screen Couple',5); INSERT INTO tblAwardCategoryDesc VALUES (113,'Best Cinematography',1); INSERT INTO tblAwardCategoryDesc VALUES (114,'Best Director',1); INSERT INTO tblAwardCategoryDesc VALUES (115,'Best Effects, Sound Effects Editing',1); INSERT INTO tblAwardCategoryDesc VALUES (116,'Best Film Editing',1); INSERT INTO tblAwardCategoryDesc VALUES (117,'Best Sound',1); INSERT INTO tblAwardCategoryDesc VALUES (118,'Best Actor in a Leading Role',1); INSERT INTO tblAwardCategoryDesc VALUES (119,'Best Art Direction-Set Decoration',1); INSERT INTO tblAwardCategoryDesc VALUES (120,'Best Makeup',1); INSERT INTO tblAwardCategoryDesc VALUES (121,'Best Music, Original Dramatic Score',1); INSERT INTO tblAwardCategoryDesc VALUES (122,'Best Picture',1); INSERT INTO tblAwardCategoryDesc VALUES (123,'Best Writing, Screenplay Written Directly for the Screen',1); PAUSE Award categories created. Press [Enter] INSERT INTO tblAwardResult VALUES (1,'Won'); INSERT INTO tblAwardResult VALUES (2,'Nominated'); PAUSE Award results created. Press [Enter] INSERT INTO tblDirector VALUES (1,'Pierre','Morel'); INSERT INTO tblDirector VALUES (2,'Ruben','Fleischer'); INSERT INTO tblDirector VALUES (3,'Julian','Gilbey'); INSERT INTO tblDirector VALUES (4,'Timur','Bekmambetoy'); INSERT INTO tblDirector VALUES (5,'Mike','McCoy'); INSERT INTO tblDirector VALUES (6,'Scott','Waugh'); INSERT INTO tblDirector VALUES (7,'Joe','Johnston'); INSERT INTO tblDirector VALUES (8,'Olivier','Megaton'); INSERT INTO tblDirector VALUES (9,'Shawn','Levy'); INSERT INTO tblDirector VALUES (10,'Neil','Marshall'); INSERT INTO tblDirector VALUES (11,'Baltasar','Kormakur'); INSERT INTO tblDirector VALUES (12,'Patrick','Lussier'); INSERT INTO tblDirector VALUES (13,'Steven','Spielberg'); PAUSE Director data created. Press [Enter] INSERT INTO tblMPAA VALUES (1,'G','General Audiences. All Ages Admitted'); INSERT INTO tblMPAA VALUES (2,'PG','Parental Guidance Suggested. Some Material May Not Be Suitable For Children'); INSERT INTO tblMPAA VALUES (3,'PG-13','Parents Strongly Cautioned. Some Material May Be Inappropriate For Children Under 13'); INSERT INTO tblMPAA VALUES (4,'R','Restricted. Children Under 17 Require Accompanying Parent or Adult Guardian'); INSERT INTO tblMPAA VALUES (5,'NC-17','No One 17 and Under Admitted'); PAUSE MPAA data created. Press [Enter] INSERT INTO tblWriter VALUES (1,'Ben','Hecht'); INSERT INTO tblWriter VALUES (2,'Christopher','Nolan'); INSERT INTO tblWriter VALUES (3,'Walon','Green'); INSERT INTO tblWriter VALUES (4,'Sam','Peckinpah'); INSERT INTO tblWriter VALUES (5,'Nunnally','Johnson'); INSERT INTO tblWriter VALUES (6,'Frank S.','Nugent'); INSERT INTO tblWriter VALUES (7,'Sidney','Carroll'); INSERT INTO tblWriter VALUES (8,'Robert','Rossen'); INSERT INTO tblWriter VALUES (9,'Woody','Allen'); INSERT INTO tblWriter VALUES (10,'Francis Ford','Coppola'); INSERT INTO tblWriter VALUES (11,'Edmund H.','North'); INSERT INTO tblWriter VALUES (12,'Joseph','Stefano'); INSERT INTO tblWriter VALUES (13,'David','Mamet'); INSERT INTO tblWriter VALUES (14,'Alexander','Payne'); INSERT INTO tblWriter VALUES (15,'Jim','Taylor'); INSERT INTO tblWriter VALUES (16,'Eric','Roth'); INSERT INTO tblWriter VALUES (17,'Phil Alden','Robinson'); INSERT INTO tblWriter VALUES (18,'Federico','Fellini'); INSERT INTO tblWriter VALUES (19,'Brunello','Rondi'); INSERT INTO tblWriter VALUES (20,'Tullio','Pinelli'); INSERT INTO tblWriter VALUES (21,'Ennio','Flaiano'); INSERT INTO tblWriter VALUES (22,'Colin','Higgins'); INSERT INTO tblWriter VALUES (23,'Jean','Renoir'); INSERT INTO tblWriter VALUES (24,'Charles','Spaak'); INSERT INTO tblWriter VALUES (25,'William','Goldman'); INSERT INTO tblWriter VALUES (26,'John Michael','Hayes'); INSERT INTO tblWriter VALUES (27,'Donn','Pearce'); INSERT INTO tblWriter VALUES (28,'Frank','Pierson'); INSERT INTO tblWriter VALUES (29,'Jerzy','Kosinski'); INSERT INTO tblWriter VALUES (30,'Earl W.','Wallace'); INSERT INTO tblWriter VALUES (31,'William','Kelley'); INSERT INTO tblWriter VALUES (32,'Mel','Brooks'); INSERT INTO tblWriter VALUES (33,'Sylvester','Stallone'); INSERT INTO tblWriter VALUES (34,'Charlie','Kaufman'); INSERT INTO tblWriter VALUES (35,'Donald','Kaufman'); INSERT INTO tblWriter VALUES (36,'Paul','Schrader'); INSERT INTO tblWriter VALUES (37,'Mardik','Martin'); INSERT INTO tblWriter VALUES (38,'Carl','Foreman'); INSERT INTO tblWriter VALUES (39,'George','Lucas'); INSERT INTO tblWriter VALUES (40,'Cameron','Crowe'); INSERT INTO tblWriter VALUES (41,'Betty','Comden'); INSERT INTO tblWriter VALUES (42,'Adolph','Green'); INSERT INTO tblWriter VALUES (43,'James L.','Brooks'); INSERT INTO tblWriter VALUES (44,'Peter','Benchley'); INSERT INTO tblWriter VALUES (45,'Carl','Gottlieb'); INSERT INTO tblWriter VALUES (46,'Ted','Tally'); INSERT INTO tblWriter VALUES (47,'Robert','Zemeckis'); INSERT INTO tblWriter VALUES (48,'Bob','Gale'); INSERT INTO tblWriter VALUES (49,'Luc','Besson'); INSERT INTO tblWriter VALUES (50,'Robert Mark','Kamen'); INSERT INTO tblWriter VALUES (51,'Michael','Diliberti'); INSERT INTO tblWriter VALUES (52,'Julian','Gilbey'); INSERT INTO tblWriter VALUES (53,'Will','Gilbey'); INSERT INTO tblWriter VALUES (54,'Seth','Grahame-Smith'); INSERT INTO tblWriter VALUES (55,'Kurt','Johnstad'); INSERT INTO tblWriter VALUES (56,'Christopher','Marcus'); INSERT INTO tblWriter VALUES (57,'Josh','Klausner'); INSERT INTO tblWriter VALUES (58,'Robert','Rodat'); PAUSE Writer data created. Press [Enter] INSERT INTO tblActor VALUES (856,'Tracy','Nelson','F'); INSERT INTO tblActor VALUES (1101,'Maggie','Grace','F'); INSERT INTO tblActor VALUES (1102,'Famke','Janssen','F'); INSERT INTO tblActor VALUES (1105,'Nick','Swardson','M'); INSERT INTO tblActor VALUES (1103,'Jesse','Eisenberg','M'); INSERT INTO tblActor VALUES (1104,'Danny','McBride','M'); INSERT INTO tblActor VALUES (1106,'Alec','Newman','M'); INSERT INTO tblActor VALUES (1107,'Ed','Speleers','M'); INSERT INTO tblActor VALUES (1108,'Melissa','George','F'); INSERT INTO tblActor VALUES (1109,'Benjamin','Walker','M'); INSERT INTO tblActor VALUES (1110,'Rufus','Sewell','M'); INSERT INTO tblActor VALUES (1111,'Dominic','Cooper','M'); INSERT INTO tblActor VALUES (1113,'Alex','Veadov','M'); INSERT INTO tblActor VALUES (1112,'Roselyn','Sanchez','F'); INSERT INTO tblActor VALUES (1114,'Nestor','Serrano','M'); INSERT INTO tblActor VALUES (1115,'Chris','Evans','M'); INSERT INTO tblActor VALUES (1116,'Hugo','Weaving','M'); INSERT INTO tblActor VALUES (193,'Samuel L.','Jackson','M'); INSERT INTO tblActor VALUES (261,'Liam','Neeson','M'); INSERT INTO tblActor VALUES (1117,'Steve','Carell','M'); INSERT INTO tblActor VALUES (1119,'Mark','Wahlberg','M'); INSERT INTO tblActor VALUES (1118,'Tina','Fey','F'); INSERT INTO tblActor VALUES (54,'Nicolas','Cage','M'); INSERT INTO tblActor VALUES (1121,'William','Fichtner','M'); INSERT INTO tblActor VALUES (1120,'Amber','Heard','F'); INSERT INTO tblActor VALUES (168,'Tom','Hanks','M'); INSERT INTO tblActor VALUES (97,'Matt','Damon','M'); INSERT INTO tblActor VALUES (1122,'Tom','Sizemore','M'); PAUSE Actor data created. Press [Enter] INSERT INTO tblMovie VALUES (10,'Date Night',88,2010,'',9,3); INSERT INTO tblMovie VALUES (36,'30 Minutes or Less',83,2011,'',2,4); INSERT INTO tblMovie VALUES (37,'Captain America: The First Avenger',124,2011,'',7,3); INSERT INTO tblMovie VALUES (41,'Drive Angry',104,2011,'','',4); INSERT INTO tblMovie VALUES (48,'A Lonely Place to Die',99,2011,'',3,4); INSERT INTO tblMovie VALUES (59,'Abraham Lincoln: Vampire Hunter',105,2012,'',4,4); INSERT INTO tblMovie VALUES (60,'Act of Valor',110,2012,'',5,4); INSERT INTO tblMovie VALUES (70,'Taken 2',92,2012,'',8,3); INSERT INTO tblMovie VALUES (72,'Taken',93,2008,'',1,3); INSERT INTO tblMovie VALUES (73,'Saving Private Ryan',169,1998,'',13,4); PAUSE Movie data created. Press [Enter] INSERT INTO tblActorDetail VALUES (10,1117); INSERT INTO tblActorDetail VALUES (10,1118); INSERT INTO tblActorDetail VALUES (10,1119); INSERT INTO tblActorDetail VALUES (36,1103); INSERT INTO tblActorDetail VALUES (36,1104); INSERT INTO tblActorDetail VALUES (36,1105); INSERT INTO tblActorDetail VALUES (37,193); INSERT INTO tblActorDetail VALUES (37,1115); INSERT INTO tblActorDetail VALUES (37,1116); INSERT INTO tblActorDetail VALUES (41,54); INSERT INTO tblActorDetail VALUES (41,1120); INSERT INTO tblActorDetail VALUES (41,1121); INSERT INTO tblActorDetail VALUES (48,1106); INSERT INTO tblActorDetail VALUES (48,1107); INSERT INTO tblActorDetail VALUES (48,1108); INSERT INTO tblActorDetail VALUES (59,1109); INSERT INTO tblActorDetail VALUES (59,1110); INSERT INTO tblActorDetail VALUES (59,1111); INSERT INTO tblActorDetail VALUES (60,1112); INSERT INTO tblActorDetail VALUES (60,1113); INSERT INTO tblActorDetail VALUES (60,1114); INSERT INTO tblActorDetail VALUES (70,261); INSERT INTO tblActorDetail VALUES (70,1101); INSERT INTO tblActorDetail VALUES (70,1102); INSERT INTO tblActorDetail VALUES (72,261); INSERT INTO tblActorDetail VALUES (72,1101); INSERT INTO tblActorDetail VALUES (72,1102); INSERT INTO tblActorDetail VALUES (73,97); INSERT INTO tblActorDetail VALUES (73,168); INSERT INTO tblActorDetail VALUES (73,1122); PAUSE Actor detail data created. Press [Enter] INSERT INTO tblWriterDetail VALUES (10,57); INSERT INTO tblWriterDetail VALUES (36,51); INSERT INTO tblWriterDetail VALUES (37,56); INSERT INTO tblWriterDetail VALUES (48,52); INSERT INTO tblWriterDetail VALUES (48,53); INSERT INTO tblWriterDetail VALUES (59,54); INSERT INTO tblWriterDetail VALUES (60,55); INSERT INTO tblWriterDetail VALUES (70,49); INSERT INTO tblWriterDetail VALUES (72,49); INSERT INTO tblWriterDetail VALUES (72,50); INSERT INTO tblWriterDetail VALUES (73,58); PAUSE Writer detail data created. Press [Enter] INSERT INTO tblGenreDetail VALUES (10,2); INSERT INTO tblGenreDetail VALUES (10,9); INSERT INTO tblGenreDetail VALUES (10,20); INSERT INTO tblGenreDetail VALUES (36,1); INSERT INTO tblGenreDetail VALUES (36,2); INSERT INTO tblGenreDetail VALUES (36,9); INSERT INTO tblGenreDetail VALUES (37,1); INSERT INTO tblGenreDetail VALUES (37,6); INSERT INTO tblGenreDetail VALUES (37,8); INSERT INTO tblGenreDetail VALUES (41,1); INSERT INTO tblGenreDetail VALUES (41,9); INSERT INTO tblGenreDetail VALUES (41,10); INSERT INTO tblGenreDetail VALUES (41,21); INSERT INTO tblGenreDetail VALUES (48,8); INSERT INTO tblGenreDetail VALUES (48,9); INSERT INTO tblGenreDetail VALUES (48,21); INSERT INTO tblGenreDetail VALUES (59,1); INSERT INTO tblGenreDetail VALUES (59,10); INSERT INTO tblGenreDetail VALUES (59,11); INSERT INTO tblGenreDetail VALUES (60,1); INSERT INTO tblGenreDetail VALUES (60,7); INSERT INTO tblGenreDetail VALUES (60,8); INSERT INTO tblGenreDetail VALUES (60,21); INSERT INTO tblGenreDetail VALUES (70,1); INSERT INTO tblGenreDetail VALUES (70,9); INSERT INTO tblGenreDetail VALUES (70,21); INSERT INTO tblGenreDetail VALUES (72,1); INSERT INTO tblGenreDetail VALUES (72,9); INSERT INTO tblGenreDetail VALUES (72,21); INSERT INTO tblGenreDetail VALUES (73,1); INSERT INTO tblGenreDetail VALUES (73,7); INSERT INTO tblGenreDetail VALUES (73,22); PAUSE Genre detail data created. Press [Enter] INSERT INTO tblReview VALUES (1,'',7,5,72); INSERT INTO tblReview VALUES (2,'',9,7,72); INSERT INTO tblReview VALUES (3,'',6,26,72); INSERT INTO tblReview VALUES (4,'',8,15,72); INSERT INTO tblReview VALUES (5,'',7,22,72); INSERT INTO tblReview VALUES (6,'',8,36,72); INSERT INTO tblReview VALUES (7,'',9,24,72); INSERT INTO tblReview VALUES (8,'',5,33,72); INSERT INTO tblReview VALUES (9,'',6,2,72); INSERT INTO tblReview VALUES (10,'',6,34,72); INSERT INTO tblReview VALUES (11,'',8,29,72); INSERT INTO tblReview VALUES (12,'',9,12,72); INSERT INTO tblReview VALUES (13,'',6,27,72); INSERT INTO tblReview VALUES (14,'',7,31,72); INSERT INTO tblReview VALUES (15,'',3,32,72); INSERT INTO tblReview VALUES (16,'',5,3,72); INSERT INTO tblReview VALUES (17,'',8,10,72); INSERT INTO tblReview VALUES (18,'',4,14,36); INSERT INTO tblReview VALUES (19,'',2,8,36); INSERT INTO tblReview VALUES (20,'',2,28,36); INSERT INTO tblReview VALUES (21,'',6,24,36); INSERT INTO tblReview VALUES (22,'',6,18,36); INSERT INTO tblReview VALUES (23,'',3,15,36); INSERT INTO tblReview VALUES (24,'',9,1,48); INSERT INTO tblReview VALUES (25,'',8,5,48); INSERT INTO tblReview VALUES (26,'',8,19,48); INSERT INTO tblReview VALUES (27,'',10,25,48); INSERT INTO tblReview VALUES (28,'',8,21,48); INSERT INTO tblReview VALUES (29,'',8,23,48); INSERT INTO tblReview VALUES (30,'',10,34,48); INSERT INTO tblReview VALUES (31,'',6,3,70); INSERT INTO tblReview VALUES (32,'',7,4,70); INSERT INTO tblReview VALUES (33,'',5,8,70); INSERT INTO tblReview VALUES (34,'',6,11,70); INSERT INTO tblReview VALUES (35,'',7,18,70); INSERT INTO tblReview VALUES (36,'',7,10,70); INSERT INTO tblReview VALUES (37,'',5,29,70); INSERT INTO tblReview VALUES (38,'',3,32,70); INSERT INTO tblReview VALUES (39,'',6,23,70); INSERT INTO tblReview VALUES (40,'',4,36,70); PAUSE Review data created. Press [Enter] INSERT INTO tblAwardDetail VALUES (10,23,2,2010); INSERT INTO tblAwardDetail VALUES (10,24,1,2010); INSERT INTO tblAwardDetail VALUES (10,108,2,2011); INSERT INTO tblAwardDetail VALUES (10,109,2,2011); INSERT INTO tblAwardDetail VALUES (10,110,2,2011); INSERT INTO tblAwardDetail VALUES (37,35,2,2012); INSERT INTO tblAwardDetail VALUES (37,39,2,2012); INSERT INTO tblAwardDetail VALUES (37,43,2,2012); INSERT INTO tblAwardDetail VALUES (37,45,2,2012); INSERT INTO tblAwardDetail VALUES (37,50,2,2012); INSERT INTO tblAwardDetail VALUES (37,51,2,2012); INSERT INTO tblAwardDetail VALUES (37,53,2,2012); INSERT INTO tblAwardDetail VALUES (37,55,2,2012); INSERT INTO tblAwardDetail VALUES (37,58,1,2012); INSERT INTO tblAwardDetail VALUES (37,97,2,2012); INSERT INTO tblAwardDetail VALUES (37,98,2,2012); INSERT INTO tblAwardDetail VALUES (37,99,2,2012); INSERT INTO tblAwardDetail VALUES (37,100,2,2011); INSERT INTO tblAwardDetail VALUES (37,101,2,2012); INSERT INTO tblAwardDetail VALUES (37,102,2,2011); INSERT INTO tblAwardDetail VALUES (37,103,2,2011); INSERT INTO tblAwardDetail VALUES (37,105,1,2012); INSERT INTO tblAwardDetail VALUES (37,106,2,2012); INSERT INTO tblAwardDetail VALUES (37,107,2,2012); INSERT INTO tblAwardDetail VALUES (41,111,2,2012); INSERT INTO tblAwardDetail VALUES (41,112,2,2012); INSERT INTO tblAwardDetail VALUES (48,62,1,2011); INSERT INTO tblAwardDetail VALUES (48,73,1,2011); INSERT INTO tblAwardDetail VALUES (48,92,1,2011); INSERT INTO tblAwardDetail VALUES (48,93,1,2011); INSERT INTO tblAwardDetail VALUES (48,94,1,2011); INSERT INTO tblAwardDetail VALUES (60,10,2,2012); INSERT INTO tblAwardDetail VALUES (60,95,2,2012); INSERT INTO tblAwardDetail VALUES (60,96,2,2012); INSERT INTO tblAwardDetail VALUES (72,10,2,2009); INSERT INTO tblAwardDetail VALUES (72,56,2,2010); INSERT INTO tblAwardDetail VALUES (72,58,1,2009); INSERT INTO tblAwardDetail VALUES (73,42,1,1999); INSERT INTO tblAwardDetail VALUES (73,55,2,1999); INSERT INTO tblAwardDetail VALUES (73,113,1,1999); INSERT INTO tblAwardDetail VALUES (73,114,1,1999); INSERT INTO tblAwardDetail VALUES (73,115,1,1999); INSERT INTO tblAwardDetail VALUES (73,116,1,1999); INSERT INTO tblAwardDetail VALUES (73,117,1,1999); INSERT INTO tblAwardDetail VALUES (73,118,2,1999); INSERT INTO tblAwardDetail VALUES (73,119,2,1999); INSERT INTO tblAwardDetail VALUES (73,120,2,1999); INSERT INTO tblAwardDetail VALUES (73,121,2,1999); INSERT INTO tblAwardDetail VALUES (73,122,2,1999); INSERT INTO tblAwardDetail VALUES (73,123,2,1999); PAUSE Award detail data created. Press [Enter] INSERT INTO tblKeywordDetail VALUES (36,11); INSERT INTO tblKeywordDetail VALUES (36,12); INSERT INTO tblKeywordDetail VALUES (36,13); INSERT INTO tblKeywordDetail VALUES (36,14); INSERT INTO tblKeywordDetail VALUES (41,1); INSERT INTO tblKeywordDetail VALUES (41,2); INSERT INTO tblKeywordDetail VALUES (41,3); INSERT INTO tblKeywordDetail VALUES (41,4); INSERT INTO tblKeywordDetail VALUES (41,5); INSERT INTO tblKeywordDetail VALUES (72,6); INSERT INTO tblKeywordDetail VALUES (72,7); INSERT INTO tblKeywordDetail VALUES (72,8); INSERT INTO tblKeywordDetail VALUES (72,9); INSERT INTO tblKeywordDetail VALUES (72,10); INSERT INTO tblKeywordDetail VALUES (73,8); INSERT INTO tblKeywordDetail VALUES (73,15); INSERT INTO tblKeywordDetail VALUES (73,16); INSERT INTO tblKeywordDetail VALUES (73,17); PAUSE Keyword detail data created. Press [Enter] COMMIT;