text: --
  -- CS630: Database Management Systems
  -- Copyright 2014 Pejman Ghorbanzade <pejman@ghorbanzade.com>
  -- Creative Commons Attribution-ShareAlike 4.0 International License
  -- More info: https://github.com/ghorbanzade/beacon
  --
  
  INSERT INTO Employee (eid, ename, age, salary) VALUES (1, 'abby', 20, 200000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (2, 'bill', 40, 150000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (3, 'carlos', 25, 250000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (4, 'dustin', 23, 340000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (5, 'eric', 36, 50000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (6, 'frank', 21, 125000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (7, 'george', 17, 120000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (8, 'hanse', 14, 125000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (9, 'iman', 25, 200000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (10, 'jack', 43, 220000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (11, 'kelly', 52, 260000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (12, 'leon', 45, 270000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (13, 'mary', 35, 280000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (14, 'nicole', 28, 120000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (15, 'orson', 29, 150000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (16, 'patrick', 22, 160000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (17, 'quynh', 26, 180000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (18, 'rashid', 21, 120000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (19, 'samuel', 24, 100000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (20, 'ting', 29, 20000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (21, 'ula', 31, 120000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (22, 'victor', 62, 40000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (23, 'wei', 36, 70000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (24, 'xing', 26, 150000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (25, 'yi', 27, 320000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (26, 'zahra', 21, 1600000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (27, 'abed', 26, 70000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (28, 'benjamin', 28, 120000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (29, 'charlotte', 43, 70000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (30, 'derek', 26, 200000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (31, 'elias', 13, 126000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (32, 'france', 34, 127000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (33, 'gilbert', 53, 160000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (34, 'hamphry', 57, 400000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (35, 'iris', 23, 640000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (36, 'john', 16, 300000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (37, 'kamala', 43, 20000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (38, 'leonardo', 70, 210000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (39, 'marjan', 24, 206000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (40, 'nasrin', 34, 300000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (41, 'oliver', 65, 306000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (42, 'pejman', 45, 346700);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (43, 'quentin', 37, 90000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (44, 'ramon', 36, 110000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (45, 'sara', 35, 130000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (46, 'theodore', 26, 160000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (47, 'ulrik', 40, 150000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (48, 'victoria', 20, 21000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (49, 'wade', 60, 620000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (50, 'xman', 20, 205000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (51, 'yasmin', 19, 20000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (52, 'zeydan', 25, 250000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (53, 'Mgr1', 25, 250000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (54, 'Mgr2', 30, 150000);
  INSERT INTO Employee (eid, ename, age, salary) VALUES (55, 'Mgr3', 40, 100000);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (1, 'Agriculture', 500000, 1);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (2, 'Commerce', 1500000, 1);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (3, 'Defense', 5500000, 3);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (4, 'Education', 2000000, 4);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (5, 'Energy', 1500000, 5);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (6, 'Health', 260000, 6);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (7, 'Security', 1600000, 7);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (8, 'Housing', 1500000, 8);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (9, 'Justice', 400000, 9);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (10, 'Labor', 600000, 10);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (11, 'State', 700000, 11);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (12, 'Interior', 100000, 12);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (13, 'Transportation', 1500000, 13);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (14, 'Treasury', 2200000, 14);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (15, 'Veterans Affair', 60000, 15);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (16, 'Economy', 160000, 16);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (17, 'Marketting', 630000, 17);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (18, 'Government Ethics', 160000, 18);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (19, 'Science', 2500000, 19);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (20, 'Sport and Youth', 500000, 20);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (21, 'Disability', 700000, 21);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (22, 'Drug Control', 150000, 22);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (23, 'Catering', 50000, 23);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (24, 'Technology', 5500000, 24);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (25, 'Civil', 600000, 25);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (26, 'Sales', 360000, 53);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (27, 'Sales', 2600000, 54);
  INSERT INTO Department (did, dname, budget, managerid) VALUES (28, 'Sales', 160000, 55);
  INSERT INTO Works (eid, did, pct_time) VALUES (1, 1, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (1, 2, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (2, 2, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (3, 3, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (4, 4, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (5, 5, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (6, 6, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (7, 7, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (8, 8, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (9, 9, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (10, 10, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (11, 11, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (12, 12, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (13, 13, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (14, 14, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (15, 15, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (16, 16, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (17, 17, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (18, 18, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (19, 19, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (20, 20, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (21, 21, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (22, 22, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (23, 23, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (24, 24, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (25, 25, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (26, 1, 60.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (26, 4, 40.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (27, 13, 30.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (27, 14, 10.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (27, 15, 40.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (27, 3, 20.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (28, 16, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (28, 14, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (29, 2, 60.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (29, 7, 40.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (30, 3, 70.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (30, 12, 30.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (31, 4, 90.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (31, 24, 10.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (32, 6, 20.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (32, 7, 80.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (33, 25, 25.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (33, 12, 75.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (34, 13, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (34, 3, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (35, 13, 60.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (35, 23, 40.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (36, 3, 70.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (36, 5, 30.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (37, 7, 90.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (37, 12, 10.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (38, 11, 20.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (38, 14, 80.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (39, 24, 25.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (39, 16, 75.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (40, 20, 70.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (40, 25, 30.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (41, 4, 90.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (41, 24, 10.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (42, 6, 20.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (42, 7, 80.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (43, 12, 25.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (43, 16, 75.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (44, 13, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (44, 3, 50.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (45, 13, 60.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (45, 23, 40.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (46, 3, 70.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (46, 5, 30.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (47, 7, 80.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (47, 12, 15.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (47, 23, 5.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (48, 11, 20.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (48, 9, 80.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (49, 24, 25.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (49, 8, 75.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (50, 7, 25.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (50, 5, 75.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (51, 23, 12.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (51, 22, 88.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (52, 3, 20.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (52, 19, 15.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (52, 24, 65.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (53, 26, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (54, 27, 100.00);
  INSERT INTO Works (eid, did, pct_time) VALUES (55, 28, 100.00);
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (1, 'Tom Hanks', 'US');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (2, 'Brad Pitt', 'US');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (3, 'Penelope Cruz', 'Spain');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (4, 'Javier Bardem', 'Spain');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (5, 'Ben Affleck', 'US');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (6, 'Jean Reno', 'France');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (7, 'Marion Cotillard', 'France');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (8, 'Alain Delon', 'France');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (9, 'Golshifteh Farahani', 'Iran');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (10, 'Parviz Parastui', 'Iran');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (11, 'Christian Bale', 'UK');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (12, 'Ben Kingsley', 'UK');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (13, 'Johnny Depp','US');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (14, 'Venessa Paradis','France');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (15, 'Homayoun Ershadi','Iran');
  INSERT INTO ACTORS (actor_id, name, nationality) VALUES (16, 'Leonardo DiCaprio','US');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (1, 'The Kite Runner', 2007, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (2, 'Taste of Cherry', 1997, 'Paramount');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (3, 'Body of Lies', 2008, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (4, 'My Sweet Pepper Land', 2013, 'Paramount');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (5, 'The Lone Ranger', 2013, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (6, 'Cafe de Flore', 2011, 'Paramount');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (7, 'Se7en', 1995, 'Warner Bros');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (8, 'La Piscine', 1969, 'Warner Bros');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (9, 'La Vie en Rose', 2007, 'Warner Bros');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (10, 'Biutiful', 2010, 'Paramount');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (11, 'Volver', 2006, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (12, 'The Willow Tree', 2005, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (13, 'Forrest Gump', 1994, 'Paramount');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (14, 'Gone Girl', 2014, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (15, 'Leon', 1994, 'Warner Bros');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (16, 'The Dark Knight', 2008, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (17, 'Gandhi', 1982, 'Warner Bros');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (18, 'Tree of Life', 2011, 'Universal');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (19, 'Argo', 2012, 'Warner Bros');
  INSERT INTO MOVIES (movie_id, title, year, studio) VALUES (20, 'Fight Club', 1999, 'Paramount');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (15,1,'AaA');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (15,2,'BbB');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (9,3,'CcC');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (9,4,'DdD');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (13,5,'EeE');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (14,6,'FfF');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (2,7,'GgG');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (8,8,'GHhGh');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (7,9,'GI');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (4,10,'JjJ');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (3,11,'KkK');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (10,12,'LlL');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (1,13,'MmM');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (5,14,'NnN');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (6,15,'OoO');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (11,16,'PpP');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (12,17,'QqQ');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (2,18,'RrR');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (5,19,'SsS');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (2,20,'TtT');
  INSERT INTO STARSIN (actor_id, movie_id, character) VALUES (2,14,'WwW');
  