-- --------------------------------------------------------------- -- Ingrid Alin Nilsson 27/3-07 -- Data is inserted into database company -- Updated 28/3 2018 (supplier) -- --------------------------------------------------------------- -- --------------------------------------------------------------- INSERT INTO employee VALUES (199, 'Bullock, J.D.', 27000, null, 1920, 1920); INSERT INTO employee VALUES (11, 'Ross, Stuart', 12067, null, 1931, 1932); INSERT INTO employee VALUES (10, 'Ross, Stanley', 15908, 199, 1927, 1945); INSERT INTO employee VALUES (33, 'Hayes, Evelyn', 10100, 199, 1931, 1963); INSERT INTO employee VALUES (32, 'Smythe, Carol', 9050, 199, 1929, 1967); INSERT INTO employee VALUES (157, 'Jones, Tim', 12000, 199, 1940, 1960); INSERT INTO employee VALUES (1110, 'Smith, Paul', 6000, 33, 1952, 1973); INSERT INTO employee VALUES (35, 'Evans, Michael', 5000, 32, 1952, 1974); INSERT INTO employee VALUES (129, 'Thomas, Tom', 10000, 199, 1941, 1962); INSERT INTO employee VALUES (13, 'Edwards, Peter', 9000, 199, 1928, 1958); INSERT INTO employee VALUES (215, 'Collins, Joanne', 7000, 10, 1950, 1971); INSERT INTO employee VALUES (55, 'James, Mary', 12000, 199, 1920, 1969); INSERT INTO employee VALUES (26, 'Thompson, Bob', 13000, 199, 1930, 1970); INSERT INTO employee VALUES (98, 'Williams, Judy', 9000, 199, 1935, 1969); INSERT INTO employee VALUES (4901, 'Bailey, Chas M.', 8377, 32, 1956, 1975); INSERT INTO employee VALUES (843, 'Schmidt, Herman', 11204, 26, 1936, 1956); INSERT INTO employee VALUES (2398, 'Wallace, Maggie J.', 7880, 26, 1940, 1959); INSERT INTO employee VALUES (1639, 'Choy, Wanda', 11160, 55, 1947, 1970); INSERT INTO employee VALUES (5119, 'Bono, Sonny', 13621, 55, 1939, 1963); INSERT INTO employee VALUES (37, 'Raveen, Lemont', 11985, 26, 1950, 1974); INSERT INTO employee VALUES (5219, 'Schwarz, Jason B.', 13374, 33, 1944, 1959); INSERT INTO employee VALUES (1523, 'Zugnoni, Arthur A.', 19868, 129, 1928, 1949); INSERT INTO employee VALUES (430, 'Brunet, Paul C.', 17674, 129, 1938, 1959); INSERT INTO employee VALUES (994, 'Iwano, Masahiro', 15641, 129, 1944, 1970); INSERT INTO employee VALUES (1330, 'Onstad, Richard', 8779, 13, 1952, 1971); COMMIT; -- --------------------------------------------------------------- -- city -- --------------------------------------------------------------- INSERT INTO city VALUES ('Los Angeles', 'Calif'); INSERT INTO city VALUES ('Oakland', 'Calif'); INSERT INTO city VALUES ('El Cerrito', 'Calif'); INSERT INTO city VALUES ('Atlanta', 'Ga'); INSERT INTO city VALUES ('San Francisco', 'Calif'); INSERT INTO city VALUES ('Boston', 'Mass'); INSERT INTO city VALUES ('Dallas', 'Tex'); INSERT INTO city VALUES ('Denver', 'Colo'); INSERT INTO city VALUES ('White Plains', 'Neb'); INSERT INTO city VALUES ('Amherst', 'Mass'); INSERT INTO city VALUES ('Seattle', 'Wash'); INSERT INTO city VALUES ('Paxton', 'Ill'); INSERT INTO city VALUES ('New York', 'NY'); INSERT INTO city VALUES ('San Diego', 'Calif'); INSERT INTO city VALUES ('Hickville', 'Okla'); INSERT INTO city VALUES ('Salt Lake City', 'Utah'); INSERT INTO city VALUES ('Madison', 'Wisc'); COMMIT; -- --------------------------------------------------------------- -- store -- --------------------------------------------------------------- INSERT INTO store VALUES (5, 'San Francisco'); INSERT INTO store VALUES (7, 'Oakland'); INSERT INTO store VALUES (8, 'El Cerrito'); INSERT INTO store VALUES (9, 'San Francisco'); COMMIT; -- --------------------------------------------------------------- -- dept -- --------------------------------------------------------------- INSERT INTO dept VALUES (35, 'Book', 5, 1, 55); INSERT INTO dept VALUES (10, 'Candy', 5, 1, 13); INSERT INTO dept VALUES (19, 'Furniture', 7, 4, 26); INSERT INTO dept VALUES (20, 'Major Appliances', 7, 4, 26); INSERT INTO dept VALUES (14, 'Jewelry', 8, 1, 33); INSERT INTO dept VALUES (43, 'Children''s', 8, 2, 32); INSERT INTO dept VALUES (65, 'Junior''s', 7, 3, 37); INSERT INTO dept VALUES (58, 'Men''s', 7, 2, 129); INSERT INTO dept VALUES (60, 'Sportswear', 5, 1, 10); INSERT INTO dept VALUES (99, 'Giftwrap', 5, 1, 98); INSERT INTO dept VALUES (1, 'Bargain', 5, 0, 37); INSERT INTO dept VALUES (26, 'Linens', 7, 3, 157); INSERT INTO dept VALUES (63, 'Women''s', 7, 3, 32); INSERT INTO dept VALUES (49, 'Toys', 8, 2, 35); INSERT INTO dept VALUES (70, 'Women''s', 5, 1, 10); INSERT INTO dept VALUES (73, 'Children''s', 5, 1, 10); INSERT INTO dept VALUES (34, 'Stationary', 5, 1, 33); INSERT INTO dept VALUES (47, 'Junior Miss', 7, 2, 129); INSERT INTO dept VALUES (28, 'Women''s', 8, 2, 32); COMMIT; -- --------------------------------------------------------------- -- supplier -- --------------------------------------------------------------- INSERT INTO supplier VALUES (199, 'Koret', 'Los Angeles'); INSERT INTO supplier VALUES (213,'Cannon', 'Atlanta'); INSERT INTO supplier VALUES (33, 'Levi-Strauss', 'San Francisco'); INSERT INTO supplier VALUES (89, 'Fisher-Price', 'Boston'); INSERT INTO supplier VALUES (125, 'Playskool', 'Dallas'); INSERT INTO supplier VALUES (42, 'Whitman''s', 'Denver'); INSERT INTO supplier VALUES (15, 'White Stag', 'White Plains'); INSERT INTO supplier VALUES (475, 'DEC', 'Amherst'); INSERT INTO supplier VALUES (122, 'White Paper', 'Seattle'); INSERT INTO supplier VALUES (440, 'Spooley', 'Paxton'); INSERT INTO supplier VALUES (241, 'IBM', 'New York'); INSERT INTO supplier VALUES (62, 'Data General', 'Atlanta'); INSERT INTO supplier VALUES (5, 'Amdahl', 'San Diego'); INSERT INTO supplier VALUES (20, 'Wormley', 'Hickville'); INSERT INTO supplier VALUES (67, 'Edger', 'Salt Lake City'); INSERT INTO supplier VALUES (999, 'A E Neumann', 'Madison'); INSERT INTO supplier VALUES (3, 'Debenhams', 'Oakland' ); COMMIT; -- --------------------------------------------------------------- -- item -- --------------------------------------------------------------- INSERT INTO item VALUES (26, 'Earrings', 14, 1000, 20, 199); INSERT INTO item VALUES (118, 'Towels, Bath', 26, 250, 1000, 213); INSERT INTO item VALUES (43, 'Maze', 49, 325, 200, 89); INSERT INTO item VALUES (106, 'Clock Book', 49, 198, 150, 125); INSERT INTO item VALUES (23, '1 lb Box', 10, 215, 100, 42); INSERT INTO item VALUES (52, 'Jacket', 60, 3295, 300, 15); INSERT INTO item VALUES (165, 'Jean', 65, 825, 500, 33); INSERT INTO item VALUES (258, 'Shirt', 58, 650, 1200, 33); INSERT INTO item VALUES (120, 'Twin Sheet',26, 800, 750, 213); INSERT INTO item VALUES (301, 'Boy''s Jean Suit', 43, 1250, 500, 33); INSERT INTO item VALUES (121, 'Queen Sheet', 26, 1375, 600, 213); INSERT INTO item VALUES (101, 'Slacks', 63, 1600, 325, 15); INSERT INTO item VALUES (115, 'Gold Ring', 14, 4995, 10, 199); INSERT INTO item VALUES (25, '2 lb Box, Mix', 10, 450, 75, 42); INSERT INTO item VALUES (119, 'Squeeze Ball', 49, 250, 400, 89); INSERT INTO item VALUES (11, 'Wash Cloth', 1, 75, 575, 213); INSERT INTO item VALUES (19, 'Bellbottoms', 43, 450, 600, 33); INSERT INTO item VALUES ( 21, 'ABC Blocks', 1, 198, 405, 125); INSERT INTO item VALUES (107, 'The ''Feel'' Book', 35, 225, 225, 89); INSERT INTO item VALUES (127, 'Ski Jumpsuit', 65, 4350, 125, 15); COMMIT; -- --------------------------------------------------------------- -- parts -- --------------------------------------------------------------- INSERT INTO parts VALUES (1, 'central processor', 'pink', 10, 1); INSERT INTO parts VALUES (2, 'memory', 'gray', 20, 32); INSERT INTO parts VALUES (3, 'disk drive', 'black', 685, 2); INSERT INTO parts VALUES (4, 'tape drive', 'black', 450, 4); INSERT INTO parts VALUES (5, 'tapes', 'gray', 1, 250); INSERT INTO parts VALUES (6, 'line printer', 'yellow', 578, 3); INSERT INTO parts VALUES (7, 'l-p paper', 'white', 15, 95); INSERT INTO parts VALUES (8, 'terminals', 'blue', 19, 15); INSERT INTO parts VALUES (13, 'paper tape reader', 'black', 107, 0); INSERT INTO parts VALUES (14, 'paper tape punch', 'black', 147, 0); INSERT INTO parts VALUES (9, 'terminal paper', 'white', 2, 350); INSERT INTO parts VALUES (10, 'byte-soap', 'clear', 0, 143); INSERT INTO parts VALUES (11, 'card reader', 'gray', 327, 0); INSERT INTO parts VALUES (12, 'card punch', 'gray', 427, 0); COMMIT; -- --------------------------------------------------------------- -- supply -- --------------------------------------------------------------- INSERT INTO supply VALUES (475, 1, '1993-12-31', 1); INSERT INTO supply VALUES (475, 2, '1994-05-31', 32); INSERT INTO supply VALUES (475, 3, '1993-12-31', 2); INSERT INTO supply VALUES (475, 4, '1994-05-31', 1); INSERT INTO supply VALUES (122, 7, '1995-02-01', 144); INSERT INTO supply VALUES (122, 7, '1995-02-02', 48); INSERT INTO supply VALUES (122, 9, '1995-02-01', 144); INSERT INTO supply VALUES (440, 6, '1994-10-10', 2); INSERT INTO supply VALUES (241, 4, '1993-12-31', 1); INSERT INTO supply VALUES (62, 3, '1994-06-18', 3); INSERT INTO supply VALUES (475, 2, '1993-12-31', 32); INSERT INTO supply VALUES (475, 1, '1994-07-01', 1); INSERT INTO supply VALUES (5, 4, '1994-11-15', 3); INSERT INTO supply VALUES (5, 4, '1995-01-22', 6); INSERT INTO supply VALUES (20, 5, '1995-01-10', 20); INSERT INTO supply VALUES (20, 5, '1995-01-11', 75); INSERT INTO supply VALUES (241, 1, '1995-06-01', 1); INSERT INTO supply VALUES (241, 2, '1995-06-01', 32); INSERT INTO supply VALUES (241, 3, '1995-06-01', 1); INSERT INTO supply VALUES (67, 4, '1995-07-01', 1); INSERT INTO supply VALUES (999, 10, '1996-01-01', 144); INSERT INTO supply VALUES (241, 8, '1995-07-01', 1); INSERT INTO supply VALUES (241, 9, '1995-07-01', 144); INSERT INTO supply VALUES (89, 3, '1995-07-04', 1000); INSERT INTO supply VALUES (89, 4, '1995-07-04', 1000); COMMIT; -- --------------------------------------------------------------- -- debit -- --------------------------------------------------------------- INSERT INTO debit VALUES (100581, '1995-01-15', 157, 10000000); INSERT INTO debit VALUES (100582, '1995-01-15', 1110, 14356540); INSERT INTO debit VALUES (100586, '1995-01-16', 35, 14096831); INSERT INTO debit VALUES (100592, '1995-01-17', 129, 10000000); INSERT INTO debit VALUES (100593, '1995-01-18', 35, 11652133); INSERT INTO debit VALUES (100594, '1995-01-18', 215, 12591815); COMMIT; -- --------------------------------------------------------------- -- sale -- --------------------------------------------------------------- INSERT INTO sale VALUES (100581, 118, 5); INSERT INTO sale VALUES (100581, 120, 1); INSERT INTO sale VALUES (100582, 26, 1); INSERT INTO sale VALUES (100586, 127, 3); INSERT INTO sale VALUES (100586, 106, 2); INSERT INTO sale VALUES (100592, 258, 1); INSERT INTO sale VALUES (100593, 23, 2); INSERT INTO sale VALUES (100594, 52, 1); COMMIT; -- SELECT * FROM employee; -- SELECT * FROM dept; -- SELECT * FROM item; -- SELECT * FROM parts; -- SELECT * FROM sale; -- SELECT * FROM debit; -- SELECT * FROM city; -- SELECT * FROM store; -- SELECT * FROM supply; -- SELECT * FROM supplier;