-- Database Table Creation -- -- This file will create the tables for use with the book -- Database Management Systems by Raghu Ramakrishnan and Johannes Gehrke. -- -- Version 0.1.0.0 2002/04/05 by: David Warden. -- Copyright (C) 2002 McGraw-Hill Companies Inc. All Rights Reserved. -- -- Modified by Brad Hemminger, 2004/08/05 to work with MySQL for -- INLS 157 class. changes were number -> numeric, and varchar2 -- -> varchar. -- -- -- First drop any existing tables. Any errors are ignored. -- drop table student ; drop table faculty ; drop table class ; drop table enrolled ; drop table emp ; drop table works ; drop table dept ; drop table flights ; drop table aircraft ; drop table certified ; drop table employees ; drop table suppliers ; drop table parts ; drop table catalog ; drop table sailors ; -- -- Now, add each table. -- create table student( snum int(9) primary key, sname varchar(30), major varchar(25), standing varchar(2), age numeric(3,0) ); create table faculty( fid numeric(9,0) primary key, fname varchar(30), deptid numeric(2,0) ); create table class( name varchar(40) primary key, meets_at varchar(20), room varchar(10), fid numeric(9,0), foreign key(fid) references faculty ); create table enrolled( snum numeric(9,0), cname varchar(40), primary key(snum,cname), foreign key(snum) references student, foreign key(cname) references class(name) ); create table emp( eid numeric(9,0) primary key, ename varchar(30), age numeric(3,0), salary numeric(10,2) ); create table dept( did numeric(2,0) primary key, dname varchar(20), budget numeric(10,2), managerid numeric(9,0), foreign key(managerid) references emp(eid) ); create table works( eid numeric(9,0), did numeric(2,0), pct_time numeric(3,0), primary key(eid,did), foreign key(eid) references emp, foreign key(did) references dept ); create table flights( flno numeric(4,0) primary key, origin varchar(20), destination varchar(20), distance numeric(6,0), departs datetime, arrives datetime, price numeric(7,2) ); create table aircraft( aid numeric(9,0) primary key, aname varchar(30), cruisingrange numeric(6,0) ); create table employees( eid numeric(9,0) primary key, ename varchar(30), salary numeric(10,2) ); create table certified( eid numeric(9,0), aid numeric(9,0), primary key(eid,aid), foreign key(eid) references employees, foreign key(aid) references aircraft ); create table suppliers( sid numeric(9,0) primary key, sname varchar(30), address varchar(40) ); create table parts( pid numeric(9,0) primary key, pname varchar(40), color varchar(15) ); create table catalog( sid numeric(9,0), pid numeric(9,0), cost numeric(10,2), primary key(sid,pid), foreign key(sid) references suppliers, foreign key(pid) references parts ); create table sailors( sid numeric(9,0) primary key, sname varchar(30), rating numeric(2,0), age numeric(4,1) ); INSERT INTO aircraft () VALUES (1,"Boeing 747-400",8430); INSERT INTO aircraft () VALUES (2,"Boeing 737-800",3383); INSERT INTO aircraft () VALUES (3,"Airbus A340-300",7120); INSERT INTO aircraft () VALUES (4,"British Aerospace Jetstream 41",1502); INSERT INTO aircraft () VALUES (5,"Embraer ERJ-145",1530); INSERT INTO aircraft () VALUES (6,"SAAB 340",2128); INSERT INTO aircraft () VALUES (7,"Piper Archer III",520); INSERT INTO aircraft () VALUES (8,"Tupolev 154",4103); INSERT INTO aircraft () VALUES (9,"Lockheed L1011",6900); INSERT INTO aircraft () VALUES (10,"Boeing 757-300",4010); INSERT INTO aircraft () VALUES (11,"Boeing 777-300",6441); INSERT INTO aircraft () VALUES (12,"Boeing 767-400ER",6475); INSERT INTO aircraft () VALUES (13,"Airbus A320",2605); INSERT INTO aircraft () VALUES (14,"Airbus A319",1805); INSERT INTO aircraft () VALUES (15,"Boeing 727",1504); INSERT INTO aircraft () VALUES (16,"Schwitzer 2-33",30); INSERT INTO aircraft () VALUES (17,"Boeing 727",40000); INSERT INTO catalog () VALUES (1,3,0.50); INSERT INTO catalog () VALUES (1,4,0.50); INSERT INTO catalog () VALUES (1,8,11.70); INSERT INTO catalog () VALUES (2,3,0.55); INSERT INTO catalog () VALUES (2,8,7.95); INSERT INTO catalog () VALUES (2,1,16.50); INSERT INTO catalog () VALUES (3,8,12.50); INSERT INTO catalog () VALUES (3,9,1.00); INSERT INTO catalog () VALUES (4,5,2.20); INSERT INTO catalog () VALUES (4,6,1247548.23); INSERT INTO catalog () VALUES (4,7,1247548.23); INSERT INTO catalog () VALUES (3,3,0.55); INSERT INTO certified () VALUES (567354612,1); INSERT INTO certified () VALUES (567354612,2); INSERT INTO certified () VALUES (567354612,10); INSERT INTO certified () VALUES (567354612,11); INSERT INTO certified () VALUES (567354612,12); INSERT INTO certified () VALUES (567354612,15); INSERT INTO certified () VALUES (567354612,7); INSERT INTO certified () VALUES (567354612,9); INSERT INTO certified () VALUES (567354612,3); INSERT INTO certified () VALUES (567354612,4); INSERT INTO certified () VALUES (567354612,5); INSERT INTO certified () VALUES (552455318,2); INSERT INTO certified () VALUES (552455318,14); INSERT INTO certified () VALUES (550156548,1); INSERT INTO certified () VALUES (550156548,12); INSERT INTO certified () VALUES (390487451,3); INSERT INTO certified () VALUES (390487451,13); INSERT INTO certified () VALUES (390487451,14); INSERT INTO certified () VALUES (274878974,10); INSERT INTO certified () VALUES (274878974,12); INSERT INTO certified () VALUES (355548984,8); INSERT INTO certified () VALUES (355548984,9); INSERT INTO certified () VALUES (310454876,8); INSERT INTO certified () VALUES (310454876,9); INSERT INTO certified () VALUES (548977562,7); INSERT INTO certified () VALUES (142519864,1); INSERT INTO certified () VALUES (142519864,11); INSERT INTO certified () VALUES (142519864,12); INSERT INTO certified () VALUES (142519864,10); INSERT INTO certified () VALUES (142519864,3); INSERT INTO certified () VALUES (142519864,2); INSERT INTO certified () VALUES (142519864,13); INSERT INTO certified () VALUES (142519864,7); INSERT INTO certified () VALUES (269734834,1); INSERT INTO certified () VALUES (269734834,2); INSERT INTO certified () VALUES (269734834,3); INSERT INTO certified () VALUES (269734834,4); INSERT INTO certified () VALUES (269734834,5); INSERT INTO certified () VALUES (269734834,6); INSERT INTO certified () VALUES (269734834,7); INSERT INTO certified () VALUES (269734834,8); INSERT INTO certified () VALUES (269734834,9); INSERT INTO certified () VALUES (269734834,10); INSERT INTO certified () VALUES (269734834,11); INSERT INTO certified () VALUES (269734834,12); INSERT INTO certified () VALUES (269734834,13); INSERT INTO certified () VALUES (269734834,14); INSERT INTO certified () VALUES (269734834,15); INSERT INTO certified () VALUES (552455318,7); INSERT INTO certified () VALUES (556784565,5); INSERT INTO certified () VALUES (556784565,2); INSERT INTO certified () VALUES (556784565,3); INSERT INTO certified () VALUES (573284895,3); INSERT INTO certified () VALUES (573284895,4); INSERT INTO certified () VALUES (573284895,5); INSERT INTO certified () VALUES (574489456,8); INSERT INTO certified () VALUES (574489456,6); INSERT INTO certified () VALUES (574489457,7); INSERT INTO certified () VALUES (242518965,2); INSERT INTO certified () VALUES (242518965,10); INSERT INTO certified () VALUES (141582651,2); INSERT INTO certified () VALUES (141582651,10); INSERT INTO certified () VALUES (141582651,12); INSERT INTO certified () VALUES (011564812,2); INSERT INTO certified () VALUES (011564812,10); INSERT INTO certified () VALUES (356187925,6); INSERT INTO certified () VALUES (159542516,5); INSERT INTO certified () VALUES (159542516,7); INSERT INTO certified () VALUES (090873519,6); INSERT INTO certified () VALUES (142519864,17); insert into class () values ("Data Structures", "MWF 10", "R128", 489456522); insert into class () values ("Database Systems", "MWF 12:30-1:45", "1320 DCL", 142519864); insert into class () values ("Operating System Design", "TuTh 12-1:20", "20 AVW", 489456522); insert into class () values ("Archaeology of the Incas", "MWF 3-4:15", "R128", 248965255); insert into class () values ("Aviation Accident Investigation", "TuTh 1-2:50", "Q3", 011564812); insert into class () values ("Air Quality Engineering", "TuTh 10:30-11:45", "R15", 011564812); insert into class () values ("Introductory Latin", "MWF 3-4:15", "R12", 248965255); insert into class () values ("American Political Parties", "TuTh 2-3:15", "20 AVW", 619023588); insert into class () values ("Social Cognition", "Tu 6:30-8:40", "R15", 159542516); insert into class () values ("Perception", "MTuWTh 3", "Q3", 489221823); insert into class () values ("Multivariate Analysis", "TuTh 2-3:15", "R15", 090873519); insert into class () values ("Patent Law", "F 1-2:50", "R128", 090873519); insert into class () values ("Urban Economics", "MWF 11", "20 AVW", 489221823); insert into class () values ("Organic Chemistry", "TuTh 12:30-1:45","R12", 489221823); insert into class () values ("Marketing Research", "MW 10-11:15", "1320 DCL", 489221823); insert into class () values ("Seminar in American Art", "M 4", "R15", 489221823); insert into class () values ("Orbital Mechanics", "MWF 8", "1320 DCL", 011564812); insert into class () values ("Dairy Herd Management", "TuTh 12:30-1:45", "R128", 356187925); insert into class () values ("Communication Networks", "MW 9:30-10:45", "20 AVW", 141582651); insert into class () values ("Optical Electronics", "TuTh 12:30-1:45", "R15", 254099823); insert into class () values ("Intoduction to Math", "TuTh 8-9:30", "R128", 489221823); INSERT INTO dept() VALUES (1,'Hardware',1048572.12,141582651); INSERT INTO dept() VALUES (2,'Operations',12099101.00,287321212); INSERT INTO dept() VALUES (3,'Legal',222988.13,248965255); INSERT INTO dept() VALUES (4,'Marketing',538099.54,548977562); INSERT INTO dept() VALUES (5,'Software',400011.12,141582651); INSERT INTO dept() VALUES (6,'Production',12099101.00,578875478); INSERT INTO dept() VALUES (7,'Shipping',5.00,489456522); INSERT INTO emp () VALUES (142519864,"Susan Martin",39,56990); INSERT INTO emp () VALUES (242518965,"James Smith",68,27099); INSERT INTO emp () VALUES (141582651,"Mary Johnson",44,94011); INSERT INTO emp () VALUES (011564812,"John Williams",35,74098); INSERT INTO emp () VALUES (254099823,"Patricia Jones",28,42783); INSERT INTO emp () VALUES (356187925,"Robert Brown",28,35431); INSERT INTO emp () VALUES (489456522,"Linda Davis",26,25971); INSERT INTO emp () VALUES (287321212,"Michael Miller",62,131072); INSERT INTO emp () VALUES (248965255,"Barbara Wilson",48,95021); INSERT INTO emp () VALUES (159542516,"Matt Nelson",33,48990); INSERT INTO emp () VALUES (090873519,"Elizabeth Taylor",27,33055); INSERT INTO emp () VALUES (486512566,"David Anderson",20,25199); INSERT INTO emp () VALUES (619023588,"Jennifer Thomas",24,34654); INSERT INTO emp () VALUES (112348546,"Joseph Thompson",26,24998); INSERT INTO emp () VALUES (115987938,"Christopher Garcia",60,24998); INSERT INTO emp () VALUES (132977562,"Angela Martinez",31,24998); INSERT INTO emp () VALUES (269734834,"Rick Carter",38,24998); INSERT INTO emp () VALUES (280158572,"Margaret Clark",40,24998); INSERT INTO emp () VALUES (301221823,"Juan Rodriguez",30,32175); INSERT INTO emp () VALUES (318548912,"Ann Mitchell",23,32175); INSERT INTO emp () VALUES (320874981,"Daniel Lee",23,32175); INSERT INTO emp () VALUES (322654189,"Lisa Walker",38,32175); INSERT INTO emp () VALUES (348121549,"Trey Phillips",69,32175); INSERT INTO emp () VALUES (351565322,"Nancy Allen",30,39910); INSERT INTO emp () VALUES (451519864,"Mark Young",34,39910); INSERT INTO emp () VALUES (455798411,"Luis Hernandez",44,39910); INSERT INTO emp () VALUES (550156548,"George Wright",42,41008); INSERT INTO emp () VALUES (552455318,"Ana Lopez",35,41008); INSERT INTO emp () VALUES (556784565,"Kenneth Hill",81,41008); INSERT INTO emp () VALUES (567354612,"Karen Scott",70,39910); INSERT INTO emp () VALUES (573284895,"Steven Green",29,39910); INSERT INTO emp () VALUES (574489456,"Betty Adams",39,39910); INSERT INTO emp () VALUES (015645489,"Daniel Evans",25,40312); INSERT INTO emp () VALUES (015487874,"Gene Edwards",51,41008); INSERT INTO emp () VALUES (054879887,"Dorthy Lewis",33,41008); INSERT INTO emp () VALUES (098784544,"Eric Collins",23,41008); INSERT INTO emp () VALUES (074454898,"Scott Bell",23,70100); INSERT INTO emp () VALUES (156489494,"Gil Richardson",32,70100); INSERT INTO emp () VALUES (179887498,"Dorthy Howard",28,40312); INSERT INTO emp () VALUES (156465461,"Eric Cooper",26,24998); INSERT INTO emp () VALUES (128778823,"William Ward",33,24998); INSERT INTO emp () VALUES (178949844,"Chad Stewart",29,24998); INSERT INTO emp () VALUES (298489484,"Lisa Gray",31,24998); INSERT INTO emp () VALUES (274878974,"Harry Watson",30,24998); INSERT INTO emp () VALUES (267894232,"Paul Hall",25,24998); INSERT INTO emp () VALUES (254898318,"Gim Rogers",25,32175); INSERT INTO emp () VALUES (489221823,"Richard Jackson",33,32996); INSERT INTO emp () VALUES (548977562,"Donald King",43,92048); INSERT INTO emp () VALUES (289562686,"Thomas Robinson",34,32175); INSERT INTO emp () VALUES (291795563,"Haywood Kelly",36,32175); INSERT INTO emp () VALUES (578875478,"Edward Baker",50,101071); INSERT INTO emp () VALUES (051135593,"Maria White",22,24998); INSERT INTO emp () VALUES (060839453,"Charles Harris",24,24998); INSERT INTO emp () VALUES (334568786,"William Moore",32,32175); INSERT INTO emp () VALUES (355548984,"Tom Murphy",41,32175); INSERT INTO emp () VALUES (310454876,"Milo Brooks",22,39910); INSERT INTO emp () VALUES (390487451,"Mark Coleman",42,39910); INSERT INTO emp () VALUES (454565232,"Louis Jenkins",20,39910); INSERT INTO emp () VALUES (141582657,"Stanley Browne",23,14093); INSERT INTO emp () VALUES (2377657,"Roger Rabbit",34,10000000); INSERT INTO employees () VALUES (242518965,"James Smith",120433); INSERT INTO employees () VALUES (141582651,"Mary Johnson",178345); INSERT INTO employees () VALUES (011564812,"John Williams",153972); INSERT INTO employees () VALUES (567354612,"Lisa Walker",256481); INSERT INTO employees () VALUES (552455318,"Larry West",101745); INSERT INTO employees () VALUES (550156548,"Karen Scott",205187); INSERT INTO employees () VALUES (390487451,"Lawrence Sperry",212156); INSERT INTO employees () VALUES (274878974,"Michael Miller",99890); INSERT INTO employees () VALUES (254099823,"Patricia Jones",24450); INSERT INTO employees () VALUES (356187925,"Robert Brown",44740); INSERT INTO employees () VALUES (355548984,"Angela Martinez",212156); INSERT INTO employees () VALUES (310454876,"Joseph Thompson",212156); INSERT INTO employees () VALUES (489456522,"Linda Davis",127984); INSERT INTO employees () VALUES (489221823,"Richard Jackson",23980); INSERT INTO employees () VALUES (548977562,"William Ward",84476); INSERT INTO employees () VALUES (310454877,"Chad Stewart",33546); INSERT INTO employees () VALUES (142519864,"Betty Adams",227489); INSERT INTO employees () VALUES (269734834,"George Wright",289950); INSERT INTO employees () VALUES (287321212,"Michael Miller",48090); INSERT INTO employees () VALUES (552455348,"Dorthy Lewis",92013); INSERT INTO employees () VALUES (248965255,"Barbara Wilson",43723); INSERT INTO employees () VALUES (159542516,"William Moore",48250); INSERT INTO employees () VALUES (348121549,"Haywood Kelly",32899); INSERT INTO employees () VALUES (090873519,"Elizabeth Taylor",32021); INSERT INTO employees () VALUES (486512566,"David Anderson",743001); INSERT INTO employees () VALUES (619023588,"Jennifer Thomas",54921); INSERT INTO employees () VALUES (015645489,"Donald King",18050); INSERT INTO employees () VALUES (556784565,"Mark Young",205187); INSERT INTO employees () VALUES (573284895,"Eric Cooper",114323); INSERT INTO employees () VALUES (574489456,"William Jones",105743); INSERT INTO employees () VALUES (574489457,"Milo Brooks",20); INSERT INTO enrolled () VALUES (112348546,"Database Systems"); INSERT INTO enrolled () VALUES (115987938,"Database Systems"); INSERT INTO enrolled () VALUES (348121549,"Database Systems"); INSERT INTO enrolled () VALUES (322654189,"Database Systems"); INSERT INTO enrolled () VALUES (552455318,"Database Systems"); INSERT INTO enrolled () VALUES (455798411,"Operating System Design"); INSERT INTO enrolled () VALUES (552455318,"Operating System Design"); INSERT INTO enrolled () VALUES (567354612,"Operating System Design"); INSERT INTO enrolled () VALUES (112348546,"Operating System Design"); INSERT INTO enrolled () VALUES (115987938,"Operating System Design"); INSERT INTO enrolled () VALUES (322654189,"Operating System Design"); INSERT INTO enrolled () VALUES (567354612,"Data Structures"); INSERT INTO enrolled () VALUES (552455318,"Communication Networks"); INSERT INTO enrolled () VALUES (455798411,"Optical Electronics"); INSERT INTO enrolled () VALUES (301221823,"Perception"); INSERT INTO enrolled () VALUES (301221823,"Social Cognition"); INSERT INTO enrolled () VALUES (301221823,"American Political Parties"); INSERT INTO enrolled () VALUES (556784565,"Air Quality Engineering"); INSERT INTO enrolled () VALUES (099354543,"Patent Law"); INSERT INTO enrolled () VALUES (574489456,"Urban Economics"); INSERT INTO faculty() VALUES (142519864,"Ivana Teach",20); INSERT INTO faculty() VALUES (242518965,"James Smith",68); INSERT INTO faculty() VALUES (141582651,"Mary Johnson",20); INSERT INTO faculty() VALUES (011564812,"John Williams",68); INSERT INTO faculty() VALUES (254099823,"Patricia Jones",68); INSERT INTO faculty() VALUES (356187925,"Robert Brown",12); INSERT INTO faculty() VALUES (489456522,"Linda Davis",20); INSERT INTO faculty() VALUES (287321212,"Michael Miller",12); INSERT INTO faculty() VALUES (248965255,"Barbara Wilson",12); INSERT INTO faculty() VALUES (159542516,"William Moore",33); INSERT INTO faculty() VALUES (090873519,"Elizabeth Taylor",11); INSERT INTO faculty() VALUES (486512566,"David Anderson",20); INSERT INTO faculty() VALUES (619023588,"Jennifer Thomas",11); INSERT INTO faculty() VALUES (489221823,"Richard Jackson",33); INSERT INTO faculty() VALUES (548977562,"Ulysses Teach",20); INSERT INTO flights () VALUES (99,"Los Angeles","Washington D.C.",2308,'2005/04/12 09:30','2005/04/12 21:40',235.98);INSERT INTO flights () VALUES (13,"Los Angeles","Chicago",1749,'2005/04/12 08:45','2005/04/12 20:45',220.98); INSERT INTO flights () VALUES (346,"Los Angeles","Dallas",1251,'2005/04/12 11:50','2005/04/12 19:05',225.43); INSERT INTO flights () VALUES (387,"Los Angeles","Boston",2606,'2005/04/12 07:03','2005/04/12 17:03',261.56); INSERT INTO flights () VALUES (7,"Los Angeles","Sydney",7487,'2005/04/12 22:30','2005/04/14 6:10',1278.56); INSERT INTO flights () VALUES (2,"Los Angeles","Tokyo",5478,'2005/04/12 12:30','2005/04/13 15:55',780.99); INSERT INTO flights () VALUES (33,"Los Angeles","Honolulu",2551,'2005/04/12 09:15','2005/04/12 11:15',375.23); INSERT INTO flights () VALUES (34,"Los Angeles","Honolulu",2551,'2005/04/12 12:45','2005/04/12 15:18',425.98); INSERT INTO flights () VALUES (76,"Chicago","Los Angeles",1749,'2005/04/12 08:32','2005/04/12 10:03',220.98); INSERT INTO flights () VALUES (68,"Chicago","New York",802,'2005/04/12 09:00','2005/04/12 12:02',202.45); INSERT INTO flights () VALUES (7789,"Madison","Detroit",319,'2005/04/12 06:15','2005/04/12 08:19',120.33); INSERT INTO flights () VALUES (701,"Detroit","New York",470,'2005/04/12 08:55','2005/04/12 10:26',180.56); INSERT INTO flights () VALUES (702,"Madison","New York",789,'2005/04/12 07:05','2005/04/12 10:12',202.34); INSERT INTO flights () VALUES (4884,"Madison","Chicago",84,'2005/04/12 22:12','2005/04/12 23:02',112.45); INSERT INTO flights () VALUES (2223,"Madison","Pittsburgh",517,'2005/04/12 08:02','2005/04/12 10:01',189.98); INSERT INTO flights () VALUES (5694,"Madison","Minneapolis",247,'2005/04/12 08:32','2005/04/12 09:33',120.11); INSERT INTO flights () VALUES (304,"Minneapolis","New York",991,'2005/04/12 10:00','2005/04/13 1:39',101.56); INSERT INTO flights () VALUES (149,"Pittsburgh","New York",303,'2005/04/12 09:42','2005/04/12 12:09',116.50); INSERT INTO flights () VALUES (143,"Madison","Philadelphia",911,'2005/04/12 09:00','2005/04/12 12:00',120.00); INSERT INTO flights () VALUES (144,"Philadelphia","Newark",912,'2005/04/12 13:00','2005/04/12 14:00',150.00); INSERT INTO flights () VALUES (145,"Newark","New York",915,'2005/04/12 14:30','2005/04/12 15:50',110.00); INSERT INTO flights () VALUES (146,"Madison","Los Angeles",914,'2005/04/12 17:05','2005/04/12 19:20',220.00); INSERT INTO flights () VALUES (147,"Los Angeles","New York",916,'2005/04/12 20:25','2005/04/13 2:08',200.00); INSERT INTO flights () VALUES (142,"Pittsburgh","Los Angeles",1700,'2005/04/12 09:42','2005/04/12 11:46',116.50); INSERT INTO flights () VALUES (141,"Los Angeles","New York",1900,'2005/04/12 12:17','2005/04/12 17:59',400.00); INSERT INTO flights () VALUES (2224,"Madison","Pittsburgh",517,'2005/04/12 06:02','2005/04/12 8:01',199.98); INSERT INTO parts () VALUES (1,"Left Handed Bacon Stretcher Cover","Red"); INSERT INTO parts () VALUES (2,"Smoke Shifter End","Black"); INSERT INTO parts () VALUES (3,"Acme Widget Washer","Red"); INSERT INTO parts () VALUES (4,"Acme Widget Washer","Silver"); INSERT INTO parts () VALUES (5,"I Brake for Crop Circles Sticker","Translucent"); INSERT INTO parts () VALUES (6,"Anti-Gravity Turbine Generator","Cyan"); INSERT INTO parts () VALUES (7,"Anti-Gravity Turbine Generator","Magenta"); INSERT INTO parts () VALUES (8,"Fire Hydrant Cap","Red"); INSERT INTO parts () VALUES (9,"7 Segment Display","Green"); INSERT INTO sailors () VALUES (18, "jones", 3, 30.0); INSERT INTO sailors () VALUES (41, 'jonah', 6, 56.0); INSERT INTO sailors () VALUES (22, 'ahab', 7, 44.0); INSERT INTO sailors () VALUES (63, 'moby', NULL, 15.0); INSERT INTO sailors () VALUES (72, 'jones', 6, 55.0); INSERT INTO sailors () VALUES (71, 'jonas', 6, 56.0); insert into student () values (051135593, "Maria White", "English", "SR", 21); insert into student () values (060839453, "Charles Harris", "Architecture", "SR", 22); insert into student () values (099354543, "Susan Martin", "Law", "JR", 20); insert into student () values (112348546, "Joseph Thompson", "Computer Science", "SO", 19); insert into student () values (115987938, "Christopher Garcia", "Computer Science", "JR", 20); insert into student () values (132977562, "Angela Martinez", "History", "SR", 20); insert into student () values (269734834, "Thomas Robinson", "Psychology", "SO", 18); insert into student () values (280158572, "Margaret Clark", "Animal Science", "FR", 18); insert into student () values (301221823, "Juan Rodriguez", "Psychology", "JR", 20); insert into student () values (318548912, "Dorthy Lewis", "Finance","FR", 18); insert into student () values (320874981, "Daniel Lee", "Electrical Engineering", "FR", 17); insert into student () values (322654189, "Lisa Walker", "Computer Science", "SO", 17); insert into student () values (348121549, "Paul Hall", "Computer Science", "JR", 18); insert into student () values (351565322, "Nancy Allen", "Accounting", "JR", 19); insert into student () values (451519864, "Mark Young", "Finance", "FR", 18); insert into student () values (455798411, "Luis Hernandez", "Electrical Engineering", "FR", 17); insert into student () values (462156489, "Donald King", "Mechanical Engineering", "SO", 19); insert into student () values (550156548, "George Wright", "Education", "SR", 21); insert into student () values (552455318, "Ana Lopez", "Computer Engineering", "SR", 19); insert into student () values (556784565, "Kenneth Hill", "Civil Engineering", "SR", 21); insert into student () values (567354612, "Karen Scott", "Computer Engineering", "FR", 18); insert into student () values (573284895, "Steven Green", "Kinesiology", "SO", 19); insert into student () values (574489456, "Betty Adams","Economics", "JR", 20); insert into student () values (578875478, "Edward Baker", "Veterinary Medicine", "SR", 21); INSERT INTO suppliers () VALUES (1,"Acme Widget Suppliers","1 Grub St., Potemkin Village, IL 61801"); INSERT INTO suppliers () VALUES (2,"Big Red Tool and Die","4 My Way, Bermuda Shorts, OR 90305"); INSERT INTO suppliers () VALUES (3,"Perfunctory Parts","99999 Short Pier, Terra Del Fuego, TX 41299"); INSERT INTO suppliers () VALUES (4,"Alien Aircaft Inc.","2 Groom Lake,Rachel, NV 51902"); INSERT INTO `works` () VALUES (142519864, 2, 100); INSERT INTO `works` () VALUES (242518965, 1, 100); INSERT INTO `works` () VALUES (141582651, 1, 50); INSERT INTO `works` () VALUES (141582651, 5, 50); INSERT INTO `works` () VALUES (141582657, 1, 25); INSERT INTO `works` () VALUES (141582657, 5, 75); INSERT INTO `works` () VALUES (011564812, 3, 100); INSERT INTO `works` () VALUES (254099823, 3, 100); INSERT INTO `works` () VALUES (356187925, 2, 100); INSERT INTO `works` () VALUES (489456522, 7, 90); INSERT INTO `works` () VALUES (287321212, 2, 100); INSERT INTO `works` () VALUES (248965255, 3, 100); INSERT INTO `works` () VALUES (159542516, 4, 100); INSERT INTO `works` () VALUES (090873519, 2, 100); INSERT INTO `works` () VALUES (486512566, 4, 100); INSERT INTO `works` () VALUES (619023588, 1, 100); INSERT INTO `works` () VALUES (489221823, 2, 100); INSERT INTO `works` () VALUES (548977562, 4, 100); INSERT INTO `works` () VALUES (578875478, 6, 100); INSERT INTO `works` () VALUES (051135593, 2, 100); INSERT INTO `works` () VALUES (060839453, 2, 100); INSERT INTO `works` () VALUES (112348546, 2, 100); INSERT INTO `works` () VALUES (115987938, 2, 100); INSERT INTO `works` () VALUES (132977562, 2, 100); INSERT INTO `works` () VALUES (269734834, 2, 100); INSERT INTO `works` () VALUES (280158572, 2, 100); INSERT INTO `works` () VALUES (301221823, 2, 100); INSERT INTO `works` () VALUES (318548912, 2, 100); INSERT INTO `works` () VALUES (320874981, 2, 100); INSERT INTO `works` () VALUES (322654189, 2, 100); INSERT INTO `works` () VALUES (348121549, 2, 100); INSERT INTO `works` () VALUES (351565322, 2, 100); INSERT INTO `works` () VALUES (451519864, 2, 100); INSERT INTO `works` () VALUES (455798411, 2, 100); INSERT INTO `works` () VALUES (550156548, 2, 50); INSERT INTO `works` () VALUES (552455318, 2, 25); INSERT INTO `works` () VALUES (556784565, 2, 25); INSERT INTO `works` () VALUES (567354612, 2, 75); INSERT INTO `works` () VALUES (573284895, 2, 50); INSERT INTO `works` () VALUES (574489456, 2, 50); INSERT INTO `works` () VALUES (015645489, 6, 100); INSERT INTO `works` () VALUES (015487874, 6, 100); INSERT INTO `works` () VALUES (054879887, 6, 100); INSERT INTO `works` () VALUES (098784544, 6, 100); INSERT INTO `works` () VALUES (074454898, 6, 100); INSERT INTO `works` () VALUES (156489494, 6, 100); INSERT INTO `works` () VALUES (179887498, 6, 100); INSERT INTO `works` () VALUES (156465461, 6, 100); INSERT INTO `works` () VALUES (128778823, 6, 100); INSERT INTO `works` () VALUES (178949844, 6, 100); INSERT INTO `works` () VALUES (298489484, 6, 100); INSERT INTO `works` () VALUES (274878974, 6, 100); INSERT INTO `works` () VALUES (267894232, 6, 100); INSERT INTO `works` () VALUES (254898318, 6, 100); INSERT INTO `works` () VALUES (289562686, 6, 100); INSERT INTO `works` () VALUES (291795563, 6, 100); INSERT INTO `works` () VALUES (334568786, 6, 100); INSERT INTO `works` () VALUES (355548984, 6, 100); INSERT INTO `works` () VALUES (310454876, 6, 100); INSERT INTO `works` () VALUES (390487451, 6, 100); INSERT INTO `works` () VALUES (454565232, 6, 50); INSERT INTO `works` () VALUES (2377657, 1, 20); INSERT INTO `works` () VALUES (489456522, 6, 10);