
drop table Faculty;
create table Faculty (
       FacID 	       INTEGER,
       Lname		VARCHAR(15),
       Fname		VARCHAR(15),
       Rank		VARCHAR(15),
       Sex		VARCHAR(1),
       Phone		INTEGER,
       Room		VARCHAR(5),
       Building		VARCHAR(13)
);

drop table Department;
create table Department (
       DNO   		INTEGER,
       Division		VARCHAR(2),
       DName		VARCHAR(25),
       Room		VARCHAR(5),
       Building		VARCHAR(13),
       DPhone		INTEGER
);

drop table Member_of;
create table Member_of (
       FacID 	       INTEGER,
       DNO	       INTEGER,
       Appt_Type       VARCHAR(15)
);

drop table Course;
create table Course (
       CID   	    	VARCHAR(7),
       CName		VARCHAR(40),
       Credits		INTEGER,
       Instructor	INTEGER,
       Days		VARCHAR(5),
       Hours		VARCHAR(11),
       DNO		INTEGER
);

drop table City;
create table City (
       city_code  	VARCHAR(3),
       city_name  	VARCHAR(25),
       state		VARCHAR(2),
       country		VARCHAR(25),
       latitude		FLOAT,
       longitude	FLOAT
);

drop table Student;
create table Student (
       StuID    	INTEGER,
       LName		VARCHAR(12),
       Fname		VARCHAR(12),
       Age		INTEGER,
       Sex		VARCHAR(1),
       Major		INTEGER,
       Advisor		INTEGER,
       city_code	VARCHAR(3)
);

drop table Minor_in;
create table Minor_in (
       StuID 	      INTEGER,
       DNO		INTEGER
);

drop table Enrolled_in;
create table Enrolled_in (
       StuID 		 INTEGER,
       CID		VARCHAR(7),
       Grade		VARCHAR(2)
);

drop table Gradeconversion;
create table Gradeconversion (
       lettergrade	     VARCHAR(2),
       gradepoint	     FLOAT
);

drop table Dorm;
create table Dorm (
       dormid		INTEGER,
       dorm_name	VARCHAR(20),
       student_capacity	INTEGER,
       gender			VARCHAR(1)
) ;

drop table Dorm_amenity;
create table Dorm_amenity (
       amenid			INTEGER,
       amenity_name		VARCHAR(25)
) ;

drop table Has_amenity;
create table Has_amenity (
       dormid			INTEGER,
       amenid				INTEGER
);

drop table Lives_in;
create table Lives_in (
       stuid 	      INTEGER,
       dormid		INTEGER,
       room_number	INTEGER
);

drop table Activity ;
create table Activity (
  actid INTEGER ,
  activity_name varchar(25)
);

drop table Participates_in ;
create table Participates_in (
  stuid INTEGER,
  actid INTEGER
);

drop table Faculty_Participates_in ;
create table Faculty_Participates_in (
  FacID INTEGER,
  actid INTEGER
);


drop table Direct_distance ;
create table Direct_distance (
  city1_code varchar(3) ,
  city2_code varchar(3) ,
  distance INTEGER
) ;


drop table Preferences;
create table Preferences (
       StuID 		 INTEGER,
       SleepHabits	 VARCHAR(20),
       MusicType	 VARCHAR(20),
       Smoking		VARCHAR(10)
);

drop table Loves;
create table Loves (
       WhoLoves	   INTEGER,
       WhoIsLoved  INTEGER
);

drop table Likes;
create table Likes (
       WhoLikes	   INTEGER,
       WhoIsLiked  INTEGER
);

drop table Has_Allergy;
create table Has_Allergy (
       StuID 		 INTEGER,
       Allergy 		 VARCHAR(20)
);

drop table Allergy_Type;
create table Allergy_Type (
       Allergy 		  VARCHAR(20),
       AllergyType 	  VARCHAR(20)
);



insert into Faculty  values ( 1082, 'Giuliano', 'Mark', 'Instructor', 'M', 2424, '224', 'NEB');
insert into Faculty  values ( 1121, 'Goodrich', 'Michael', 'Professor', 'M', 3593, '219', 'NEB');
insert into Faculty  values ( 1148, 'Masson', 'Gerald', 'Professor', 'M', 3402, '224B', 'NEB');
insert into Faculty  values ( 1193, 'Jones', 'Stacey', 'Instructor', 'F', 3550, '224', 'NEB');
insert into Faculty  values ( 2192, 'Yarowsky', 'David', 'AsstProf', 'M', 6587, '324', 'NEB');
insert into Faculty  values ( 3457, 'Smith', 'Scott', 'AssocProf', 'M', 1035, '318', 'NEB');
insert into Faculty  values ( 4230, 'Houlahan', 'Joanne', 'Instructor', 'F', 1260, '328', 'NEB');
insert into Faculty  values ( 6112, 'Beach', 'Louis', 'Instructor', 'M', 1838, '207', 'NEB');
insert into Faculty  values ( 7712, 'Awerbuch', 'Baruch', 'Professor', 'M', 2105, '220', 'NEB');
insert into Faculty  values ( 7792, 'Brill', 'Eric', 'AsstProf', 'M', 2303, '324B', 'NEB');
insert into Faculty  values ( 7723, 'Taylor', 'Russell', 'Professor', 'M', 2435, '317', 'NEB');
insert into Faculty  values ( 8114, 'Angelopoulou', 'Ellie', 'Instructor', 'F', 2152, '316', 'NEB');
insert into Faculty  values ( 8423, 'Kumar', 'Subodh', 'AsstProf', 'M', 2522, '218', 'NEB');
insert into Faculty  values ( 8721, 'Wolff', 'Lawrence', 'AssocProf', 'M', 2342, '316', 'NEB');
insert into Faculty  values ( 8741, 'Salzberg', 'Steven', 'AssocProf', 'M', 2641,   '324A', 'NEB');
insert into Faculty  values ( 8918, 'Amir', 'Yair', 'AsstProf', 'M', 2672, '308', 'NEB');
insert into Faculty  values ( 9172, 'Kosaraju', 'Rao', 'Professor', 'M', 2757, '319', 'NEB');
insert into Faculty  values ( 9826, 'Delcher', 'Arthur', 'Instructor', 'M', 2956, '329', 'NEB');
insert into Faculty  values ( 1172, 'Runolfsson', 'Thordur', 'AssocProf', 'M', 3121, '119', 'Barton');
insert into Faculty  values ( 1177, 'Naiman', 'Daniel', 'Professor', 'M', 3571, '288', 'Krieger');
insert into Faculty  values ( 1823, 'Davidson', 'Frederic', 'Professor', 'M', 5629, '119', 'Barton');
insert into Faculty  values ( 2028, 'Brody', 'William', 'Professor', 'M', 6073, '119', 'Barton');
insert into Faculty  values ( 2119, 'Meyer', 'Gerard', 'Professor', 'M', 6350, '119', 'Barton');
insert into Faculty  values ( 2291, 'Scheinerman', 'Edward', 'Professor', 'M', 6654, '288', 'Krieger');
insert into Faculty  values ( 2311, 'Priebe', 'Carey', 'AsstProf', 'M', 6953, '288', 'Krieger');
insert into Faculty  values ( 2738, 'Fill', 'James', 'Professor', 'M', 8209, '288', 'Krieger');
insert into Faculty  values ( 2881, 'Goldman', 'Alan', 'Professor', 'M', 8335, '288', 'Krieger');
insert into Faculty  values ( 4432, 'Burzio', 'Luigi', 'Professor', 'M', 1813, '288', 'Krieger');
insert into Faculty  values ( 5718, 'Frank', 'Robert', 'AsstProf', 'M', 1751, '288', 'Krieger');
insert into Faculty  values ( 6182, 'Cheng', 'Cheng', 'AsstProf', 'M', 1856, '288', 'Krieger');
insert into Faculty  values ( 6191, 'Kaplan', 'Alexander', 'Professor', 'M', 1825, '119', 'Barton');
insert into Faculty  values ( 6330, 'Byrne', 'William', 'Instructor', 'M', 1691, '119', 'Barton');
insert into Faculty  values ( 6541, 'Han', 'Shih-Ping', 'Professor', 'M', 1914, '288', 'Krieger');
insert into Faculty  values ( 6910, 'Smolensky', 'Paul', 'Professor', 'M', 2072, '288', 'Krieger');
insert into Faculty  values ( 6925, 'Iglesias', 'Pablo', 'AsstProf', 'M', 2021, '119', 'Barton');
insert into Faculty  values ( 7134, 'Goutsias', 'John', 'Professor', 'M', 2184, '119', 'Barton');
insert into Faculty  values ( 7231, 'Rugh', 'Wilson', 'Professor', 'M', 2191, '119', 'Barton');
insert into Faculty  values ( 7271, 'Jelinek', 'Frederick', 'Professor', 'M', 2890, '119', 'Barton');
insert into Faculty  values ( 7506, 'Westgate', 'Charles', 'Professor', 'M', 2932, '119', 'Barton');
insert into Faculty  values ( 8102, 'James', 'Lancelot', 'AsstProf', 'M', 2792, '288', 'Krieger');
insert into Faculty  values ( 8118, 'Weinert', 'Howard', 'Professor', 'M', 3272, '119', 'Barton');
insert into Faculty  values ( 8122, 'Wierman', 'John', 'Professor', 'M', 3392,'288', 'Krieger');
insert into Faculty  values ( 8722, 'Cauwenberghs', 'Gert', 'AsstProf', 'M', 1372, '119', 'Barton');
insert into Faculty  values ( 8723, 'Andreou', 'Andreas', 'Professor', 'M', 1402, '119', 'Barton');
insert into Faculty  values ( 8772, 'Cowen', 'Lenore', 'AsstProf', 'F', 2870, '288', 'Krieger');
insert into Faculty  values ( 8791, 'McCloskey', 'Michael', 'Professor', 'M', 3440, '288', 'Krieger');
insert into Faculty  values ( 8989, 'Brent', 'Michael', 'AsstProf', 'M', 9373, '288', 'Krieger');
insert into Faculty  values ( 9011, 'Rapp', 'Brenda', 'AsstProf', 'F', 2032, '288', 'Krieger');
insert into Faculty  values ( 9191, 'Collins', 'Oliver', 'AssocProf', 'M', 5427, '119', 'Barton');
insert into Faculty  values ( 9199, 'Hughes', 'Brian', 'AssocProf', 'M', 5666, '119', 'Barton');
insert into Faculty  values ( 9210, 'Joseph', 'Richard', 'Professor', 'M', 5996, '119', 'Barton');
insert into Faculty  values ( 9514, 'Prince', 'Jerry', 'AssocProf', 'M', 5106, '119', 'Barton');
insert into Faculty  values ( 9823, 'Pang', 'Jong-Shi', 'Professor', 'M', 4366, '288', 'Krieger');
insert into Faculty  values ( 9824, 'Glaser', 'Robert', 'Instructor', 'M', 4396, '119', 'Barton');
insert into Faculty  values ( 9811, 'Wu', 'Colin', 'AsstProf', 'M', 2906, '288', 'Krieger');
insert into Faculty  values ( 9643, 'Legendre', 'Geraldine', 'AssocProf', 'F', 8972, '288', 'Krieger');
insert into Faculty  values ( 9379, 'Khurgin', 'Jacob', 'Professor', 'M', 1060, '119', 'Barton');
insert into Faculty  values ( 9922, 'Hall', 'Leslie', 'AsstProf', 'F', 7332, '288', 'Krieger');


insert into Department  values ( 010, 'AS', 'History of Art', '268', 'Mergenthaler', 7117);
insert into Department  values ( 020, 'AS', 'Biology', '144', 'Mudd', 7330);
insert into Department  values ( 030, 'AS', 'Chemistry', '113', 'Remsen', 7429);
insert into Department  values ( 040, 'AS', 'Classics', '121', 'Gilman', 7556);
insert into Department  values ( 050, 'AS', 'Cognitive Science', '381', 'Krieger', 7119);
insert into Department  values ( 060, 'AS', 'English', '146', 'Gilman', 7544);
insert into Department  values ( 070, 'AS', 'Anthropology', '404B', 'Macaulay', 7272);
insert into Department  values ( 090, 'AS', 'German', '245', 'Gilman', 7508);
insert into Department  values ( 100, 'AS', 'History', '312', 'Gilman', 7575);
insert into Department  values ( 110, 'AS', 'Mathematics', '404', 'Krieger', 7399);
insert into Department  values ( 130, 'AS', 'Near Eastern Studies', '128', 'Gilman', 7499);
insert into Department  values ( 140, 'AS', 'History of Science', '234', 'Gilman', 7501);
insert into Department  values ( 150, 'AS', 'Philosophy', '347', 'Gilman', 7524);
insert into Department  values ( 170, 'AS', 'Physics and Astronomy', '366', 'Bloomberg', 7347);
insert into Department  values ( 180, 'AS', 'Economics', '440', 'Mergenthaler', 7601);
insert into Department  values ( 190, 'AS', 'Political Science', '338', 'Mergenthaler', 7540);
insert into Department  values ( 200, 'AS', 'Psychology', '223', 'Ames', 7055);
insert into Department  values ( 340, 'AS', 'French', '225', 'Gilman', 7227);
insert into Department  values ( 350, 'AS', 'Hispanic/Italian Studies', '221', 'Gilman', 7226);
insert into Department  values ( 520, 'EN', 'ECE', '105', 'Barton', 7033);
insert into Department  values ( 530, 'EN', 'Mechanical Engineering', '122', 'Latrobe', 7132);
insert into Department  values ( 540, 'EN', 'Chemical Engineering', '24', 'NEB', 7170);
insert into Department  values ( 550, 'EN', 'Mathematical Sciences', '221', 'Maryland', 7195);
insert into Department  values ( 560, 'EN', 'Civil Engineering', '206', 'Latrobe', 8680);
insert into Department  values ( 580, 'EN', 'Biomedical Engineering', '144', 'NEB', 8482);
insert into Department  values ( 600, 'EN', 'Computer Science', '224', 'NEB', 8577);


insert into Member_of values (7792,  600, 'Primary');
insert into Member_of values (9210,  520, 'Primary');
insert into Member_of values (9811,  550, 'Primary');
insert into Member_of values (9643,  050, 'Primary');
insert into Member_of values (9379,  520, 'Primary');
insert into Member_of values (8918,  600, 'Primary');
insert into Member_of values (7712,  600, 'Primary');
insert into Member_of values (1121,  600, 'Primary');
insert into Member_of values (9172,  600, 'Primary');
insert into Member_of values (8423,  600, 'Primary');
insert into Member_of values (1148,  600, 'Primary');
insert into Member_of values (8741,  600, 'Primary');
insert into Member_of values (3457,  600, 'Primary');
insert into Member_of values (7723,  600, 'Primary');
insert into Member_of values (8721,  600, 'Primary');
insert into Member_of values (2192,  600, 'Primary');
insert into Member_of values (8114,  600, 'Primary');
insert into Member_of values (6112,  600, 'Primary');
insert into Member_of values (9826,  600, 'Primary');
insert into Member_of values (1193,  600, 'Primary');
insert into Member_of values (1082,  600, 'Primary');
insert into Member_of values (4230,  600, 'Primary');
insert into Member_of values (8989,  600, 'Secondary');
insert into Member_of values (7271,  600, 'Secondary');
insert into Member_of values (8721,  520, 'Secondary');
insert into Member_of values (8741,  050, 'Secondary');
insert into Member_of values (7271,  050, 'Secondary');
insert into Member_of values (6182,  550, 'Primary');
insert into Member_of values (8772,  550, 'Primary');
insert into Member_of values (2738,  550, 'Primary');
insert into Member_of values (2881,  550, 'Primary');
insert into Member_of values (9922,  550, 'Primary');
insert into Member_of values (6541,  550, 'Primary');
insert into Member_of values (8102,  550, 'Primary');
insert into Member_of values (1177,  550, 'Primary');
insert into Member_of values (9823,  550, 'Primary');
insert into Member_of values (2311,  550, 'Primary');
insert into Member_of values (2291,  550, 'Primary');
insert into Member_of values (8122,  550, 'Primary');
insert into Member_of values (8989,  050, 'Primary');
insert into Member_of values (4432,  050, 'Primary');
insert into Member_of values (5718,  050, 'Primary');
insert into Member_of values (8791,  050, 'Primary');
insert into Member_of values (9011,  050, 'Primary');
insert into Member_of values (6910,  050, 'Primary');
insert into Member_of values (8723,  520, 'Primary');
insert into Member_of values (2028,  520, 'Primary');
insert into Member_of values (8722,  520, 'Primary');
insert into Member_of values (9191,  520, 'Primary');
insert into Member_of values (1823,  520, 'Primary');
insert into Member_of values (7134,  520, 'Primary');
insert into Member_of values (9199,  520, 'Primary');
insert into Member_of values (6925,  520, 'Primary');
insert into Member_of values (7271,  520, 'Primary');
insert into Member_of values (6191,  520, 'Primary');
insert into Member_of values (2119,  520, 'Primary');
insert into Member_of values (9514,  520, 'Primary');
insert into Member_of values (7231,  520, 'Primary');
insert into Member_of values (1172,  520, 'Primary');
insert into Member_of values (8118,  520, 'Primary');
insert into Member_of values (7506,  520, 'Primary');
insert into Member_of values (6330,  520, 'Primary');
insert into Member_of values (9824,  520, 'Primary');


insert into Course values ( '600.101', 'COMPUTER LITERACY', 3, 6112, 'MTW', '3',600);
insert into Course values ( '600.103', 'INTRODUCTION TO COMPUTER SCIENCE', 1, 4230, 'Th', '4',600);
insert into Course values ( '600.107', 'INTRO TO PROGRAMMING IN JAVA', 3, 1193, 'MTW', '3',600);
insert into Course values ( '600.109', 'INTRO TO PROGRAMMING IN C/C++', 3, 4230, 'MTW', '12',600);
insert into Course values ( '600.113', 'EXPLORING THE INTERNET', 3, 6112, 'MTW', '4',600);
insert into Course values ( '600.121', 'JAVA PROGRAMMING', 3, 6112, 'ThF', '10:30-12',600);
insert into Course values ( '600.211', 'UNIX SYSTEMS PROGRAMMING', 3, 6112, 'ThF', '1-2:15',600);
insert into Course values ( '600.227', 'DATA STRUCTURES in JAVA', 3, 1121, 'MTW', '9',600);
insert into Course values ( '600.232', 'MULTIMEDIA COMPUTING', 3, 9826, 'MW', '1-2:30',600);
insert into Course values ( '600.271', 'COMPUTATIONAL MODELS', 3, 9172, 'MTW', '1',600);
insert into Course values ( '600.303', 'SUPERCOMPUTING', 1, 9826, 'W', '4-6:20',600);
insert into Course values ( '600.315', 'DATABASE SYSTEMS', 3, 2192, 'ThF', '2:30-4',600);
insert into Course values ( '600.333', 'COMPUTER SYSTEM FUNDAMENTALS', 3, 1148, 'MTW', '8',600);
insert into Course values ( '600.337', 'DISTRIBUTED SYSTEMS', 3, 8918, 'M', '3',600);
insert into Course values ( '600.363', 'INTRODUCTION TO ALGORITHMS', 3, 7712, 'MTW', '9',600);
insert into Course values ( '600.415', 'DATABASE SYSTEMS', 3, 2192, 'ThF', '2:30-4',600);
insert into Course values ( '600.433', 'COMPUTER SYSTEMS', 3, 1148, 'MTW', '8',600);
insert into Course values ( '600.437', 'DISTRIBUTED SYSTEMS', 3, 8918, 'M', '3',600);
insert into Course values ( '600.445', 'QUANTITATIVE MEDICAL COMPUTING', 3, 7723, 'ThF', '1-2:15',600);
insert into Course values ( '600.461', 'COMPUTER VISION', 3, 8114, 'MTW', '1',600);
insert into Course values ( '600.463', 'ALGORITHMS I', 3, 7712, 'MTW', '9',600);
insert into Course values ( '600.465', 'INTRO TO NATURAL LANGUAGE PROCESSING', 3, 7792, 'MTW', '2',600);
insert into Course values ( '600.509', 'COMPUTER SCIENCE INTERNSHIP', 3, 1121, 'M', '1',600);
insert into Course values ( '600.601', 'COMPUTER SCIENCE SEMINAR', 1, 6191, 'ThF', '10:30-12',600);
insert into Course values ( '600.657', 'HIGH PERFORMANCE GRAPHICS AND MODELING', 3, 8423, 'M', '4-5:30',600);
insert into Course values ( '600.787', 'SEMINAR ON COMPUTATIONAL GEOMETRY', 3, 1121, 'Th', '2',600);
insert into Course values ( '550.111', 'STATISTICAL ANALYSIS', 4, 2311, 'MTW', '12',550);
insert into Course values ( '550.171', 'DISCRETE MATHEMATICS', 4, 8772, 'MTW', '11',550);
insert into Course values ( '500.203', 'ACCOUNTING I', 3, 9823, 'T', '6:15-8:45',550);
insert into Course values ( '500.204', 'ACCOUNTING II', 3, 9823, 'Th', '6:15-8:45',550);
insert into Course values ( '500.205', 'BUSINESS LAW I', 3, 8791, 'W', '6:15-8:45',550);
insert into Course values ( '500.206', 'BUSINESS LAW II', 3, 8791, 'M', '6:15-8:45',550);
insert into Course values ( '550.291', 'LINEAR ALGEBRA AND DIFFERENTIAL EQNS', 4, 6541, 'MTW', '9',550);
insert into Course values ( '550.310', 'PROBABILITY AND STATISTICS', 4, 8102, 'MTW', '10',550);
insert into Course values ( '550.361', 'INTRODUCTION TO OPTIMIZATION', 4, 2881, 'MTW', '2',550);
insert into Course values ( '550.413', 'APPLIED STATISTICS AND DATA ANALYSIS', 4, 1177, 'MTW', '11',550);
insert into Course values ( '550.420', 'INTRODUCTION TO PROBABILITY', 4, 2738, 'MTW', '1',550);
insert into Course values ( '550.471', 'COMBINATORIAL ANALYSIS', 4, 8772, 'MTW', '12',550);
insert into Course values ( '550.620', 'PROBABILITY THEORY I', 3, 2738, 'MTW', '2',550);
insert into Course values ( '550.626', 'STOCHASTIC PROCESSES II', 3, 8102, 'MTW', '1',550);
insert into Course values ( '550.631', 'STATISTICAL INFERENCE', 3, 6182, 'MTW', '3',550);
insert into Course values ( '550.661', 'FOUNDATIONS OF OPTIMIZATION', 3, 9823, 'MTW', '10',550);
insert into Course values ( '550.671', 'COMBINATORIAL ANALYSIS', 3, 8772, 'MTW', '12',550);
insert into Course values ( '550.681', 'NUMERICAL ANALYSIS', 3, 6541, 'MTW', '11',550);
insert into Course values ( '550.721', 'PERCOLATION THEORY', 3, 8122, 'MTW', '9',550);
insert into Course values ( '550.750', 'TOPICS IN OPERATIONS RESEARCH', 3, 9922, 'MW', '3-4:30',550);
insert into Course values ( '550.790', 'TOPICS IN APPLIED MATH', 2, 2881, 'MT', '4:30-6',550);
insert into Course values ( '520.137', 'INTRODUCTION TO ECE', 3, 8723, 'MTW', '11',520);
insert into Course values ( '520.213', 'CIRCUITS', 4, 9210, 'MTW', '2',520);
insert into Course values ( '520.219', 'FIELDS, MATTER AND WAVES', 3, 9210, 'MTW', '3',520);
insert into Course values ( '520.325', 'INTEGRATED ELECTRONICS', 3, 6191, 'MTW', '3',520);
insert into Course values ( '520.345', 'ECE LABORATORY', 3, 1823, 'W', '2',520);
insert into Course values ( '520.349', 'MICROPROCESSOR LAB I', 3, 9824, 'Th', '8',520);
insert into Course values ( '520.353', 'CONTROL SYSTEMS', 3, 6925, 'MTW', '10',520);
insert into Course values ( '520.401', 'BASIC COMMUNICATIONS', 3, 6191, 'MTW', '1',520);
insert into Course values ( '520.410', 'FIBER OPTICS AND PHOTONICS', 3, 6191, 'MTW', '1',520);
insert into Course values ( '520.419', 'ITERATIVE ALGORITHMS', 3, 2119, 'MT', '4-5:15',520);
insert into Course values ( '520.421', 'INTRODUCTION TO NON-LINEAR SYSTEMS', 3, 7231, 'MTW', '9',520);
insert into Course values ( '520.432', 'TOPICS IN MEDICAL IMAGING SYSTEMS', 3, 9514, 'TTh', '8:30-10',520);
insert into Course values ( '520.435', 'DIGITAL SIGNAL PROCESSING', 4, 8118, 'MTW', '11',520);
insert into Course values ( '520.475', 'PROCESSING AND RECOGNITION OF SPEECH', 3, 6330, 'TW', '2-3:30',520);
insert into Course values ( '520.490', 'ANALOG AND DIGITAL VLSI SYSTEMS', 3, 8722, 'ThF', '10:30-12',520);
insert into Course values ( '520.603', 'ELECTROMAGNETIC WAVES', 4, 9210, 'Th', '1-4:30',520);
insert into Course values ( '520.605', 'SOLID STATE PHYSICS', 3, 9379, 'Tu', '1-4',520);
insert into Course values ( '520.609', 'NONLINEAR TECHNICAL IMAGE PROCESSING', 3, 7134, 'Th', '1-4',520);
insert into Course values ( '520.651', 'RANDOM SIGNAL ANALYSIS', 3, 9514, 'ThF', '10:30-12',520);
insert into Course values ( '050.102', 'LANGUAGE AND MIND', 3, 4432, 'MTW', '10',050);
insert into Course values ( '050.109', 'MIND, BRAIN, COMPUTERS', 3, 6910, 'MW', '2-3:15',050);
insert into Course values ( '050.203', 'COGNITIVE NEUROSCIENCE', 4, 9011, 'MT', '3:30-4:45',050);
insert into Course values ( '050.325', 'SOUND STRUCTURES IN NATURAL LANGUAGE', 3, 4432, 'T', '10-12',050);
insert into Course values ( '050.370', 'FORMAL METHODS IN COGNITIVE SCIENCE', 3, 6910, 'MW', '11:30',050);
insert into Course values ( '050.381', 'LANGUAGE DEVELOPMENT', 3, 8989, 'T', '1-3',050);
insert into Course values ( '050.427', 'THE HISTORY OF ROMANCE LANGUAGES', 3, 4432, 'W', '1-3',050);
insert into Course values ( '050.670', 'FORMAL METHODS IN COGNITIVE SCIENCE', 3, 4432, 'MW', '11:30-12:45',050);
insert into Course values ( '050.802', 'RESEARCH SEMINAR IN COGNITIVE PROCESSES', 1, 9011, 'W', '1-3',050);
insert into Course values ( '050.821', 'COMP. MODELS OF SENTENCE PROCESSING', 3, 5718, 'M', '1-4',050);


insert into City values ( 'BAL' , 'Baltimore' , 'MD' , 'USA' , 39.288 , -76.617 ) ;
insert into City values ( 'PIT' , 'Pittsburgh' , 'PA' , 'USA' , 40.437 , -80.000 ) ;
insert into City values ( 'PHL' , 'Philadelphia' , 'PA' , 'USA' , 39.950 , -75.150 ) ;
insert into City values ( 'WAS' , 'Washington' , 'DC' , 'USA' , 38.892 , -77.017 ) ;
insert into City values ( 'NYC' , 'New York' , 'NY' , 'USA' , 40.849 , -73.867) ;
insert into City values ( 'ATL' , 'Atlanta' , 'GA' , 'USA' , 33.763 , -84.317 ) ;
insert into City values ( 'EWR' , 'Newark' , 'NJ' , 'USA' , 40.737 , -74.167 );
insert into City values ( 'FRE' , 'Frederick' , 'MD' , 'USA' , 39.415 , -77.417 ) ;
insert into City values ( 'NAR' , 'Newark' , 'DE' , 'USA' , 39.683 , -75.750 );
insert into City values ( 'SAN' , 'San Diego' , 'CA' , 'USA' , 32.713 , -117.150) ;
insert into City values ( 'LOS' , 'Los Angeles' , 'CA' , 'USA' , 34.058 ,-118.250) ;
insert into City values ( 'HON' , 'Honolulu' , 'HI' , 'USA' , 21.313 , -157.850 ) ;
insert into City values ( 'SFO' , 'San Francisco' , 'CA' , 'USA' , 37.775 ,-122.417) ;
insert into City values ( 'PVD' , 'Providence' , 'RI' , 'USA' , 41.817 , -71.400 ) ;
insert into City values ( 'BOS' , 'Boston' , 'MA' , 'USA' , 42.362 , -71.050 );
insert into City values ( 'DET' , 'Detroit' , 'MI' , 'USA' , 42.323 , -83.167 ) ;
insert into City values ( 'CHI' , 'Chicago' , 'IL' , 'USA' , 41.883 , -87.617 ) ;
insert into City values ( 'ROC' , 'Rochester' , 'NY' , 'USA' , 43.158 , -77.600 ) ;
insert into City values ( 'DAL' , 'Dallas' , 'TX' , 'USA' , 32.777 , -96.800 );
insert into City values ( 'HOU' , 'Houston' , 'TX' , 'USA' , 29.834 , -95.000 ) ;
insert into City values ( 'MIA' , 'Miami' , 'FL' , 'USA' , 25.465 , -80.150 ) ;
insert into City values ( 'CPK' , 'College Park' , 'MD' , 'USA' , 38.987 ,-76.933) ;
insert into City values ( 'YYZ' , 'Toronto' , 'ON' , 'CANADA' , 43.650 , -79.333 ) ;
insert into City values ( 'DEL' , 'Delhi' , 'DE' , 'INDIA' , 28.617 , 77.217 );
insert into City values ( 'PEK' , 'Beijing' , 'BE' , 'CHINA' , 39.917 ,116.417) ;
insert into City values ( 'HKG' , 'Hong Kong' , 'HK' , 'CHINA' , 22.250 ,114.167) ;
insert into City values ( 'TYO' , 'Tokyo' , 'XX' , 'JAPAN' , 35.700 , 139.767 ) ;
insert into City values ( 'LON' , 'London' , 'EN' , 'UK' , 51.500 , -0.167 ) ;
insert into City values ( 'PAR' , 'Paris' , 'XX' , 'FRANCE' , 48.867 , 2.333 );
insert into City values ( 'JNB' , 'Johannesburg' , 'XX' , 'SAFRICA' , -25.550 , 28.000 ) ;
insert into City values ( 'BKK' , 'Bangkok' , 'XX' , 'THAILAND' , 13.733 , 100.500 ) ;


insert into Student values ( 1001, 'Smith', 'Linda', 18, 'F', 600, 1121,'BAL');
insert into Student values ( 1002, 'Kim', 'Tracy', 19, 'F', 600, 7712,'HKG');
insert into Student values ( 1003, 'Jones', 'Shiela', 21, 'F', 600, 7792,'WAS');
insert into Student values ( 1004, 'Kumar', 'Dinesh', 20, 'M', 600, 8423,'CHI');
insert into Student values ( 1005, 'Gompers', 'Paul', 26, 'M', 600, 1121,'YYZ');
insert into Student values ( 1006, 'Schultz', 'Andy', 18, 'M', 600, 1148,'BAL');
insert into Student values ( 1007, 'Apap', 'Lisa', 18, 'F', 600, 8918,'PIT');
insert into Student values ( 1008, 'Nelson', 'Jandy', 20, 'F', 600, 9172,'BAL');
insert into Student values ( 1009, 'Tai', 'Eric', 19, 'M', 600, 2192,'YYZ');
insert into Student values ( 1010, 'Lee', 'Derek', 17, 'M', 600, 2192,'HOU');
insert into Student values ( 1011, 'Adams', 'David', 22, 'M', 600, 1148,'PHL');
insert into Student values ( 1012, 'Davis', 'Steven', 20, 'M', 600, 7723,'PIT');
insert into Student values ( 1014, 'Norris', 'Charles', 18, 'M', 600, 8741, 'DAL');
insert into Student values ( 1015, 'Lee', 'Susan', 16, 'F', 600, 8721,'HKG');
insert into Student values ( 1016, 'Schwartz', 'Mark', 17, 'M', 600, 2192,'DET');
insert into Student values ( 1017, 'Wilson', 'Bruce', 27, 'M', 600, 1148,'LON');
insert into Student values ( 1018, 'Leighton', 'Michael', 20, 'M', 600, 1121, 'PIT');
insert into Student values ( 1019, 'Pang', 'Arthur', 18, 'M', 600, 2192,'WAS');
insert into Student values ( 1020, 'Thornton', 'Ian', 22, 'M', 520, 7271,'NYC');
insert into Student values ( 1021, 'Andreou', 'George', 19, 'M', 520, 8722, 'NYC');
insert into Student values ( 1022, 'Woods', 'Michael', 17, 'M', 540, 8722,'PHL');
insert into Student values ( 1023, 'Shieber', 'David', 20, 'M', 520, 8722,'NYC');
insert into Student values ( 1024, 'Prater', 'Stacy', 18, 'F', 540, 7271,'BAL');
insert into Student values ( 1025, 'Goldman', 'Mark', 18, 'M', 520, 7134,'PIT');
insert into Student values ( 1026, 'Pang', 'Eric', 19, 'M', 520, 7134,'HKG');
insert into Student values ( 1027, 'Brody', 'Paul', 18, 'M', 520, 8723,'LOS');
insert into Student values ( 1028, 'Rugh', 'Eric', 20, 'M', 550, 2311,'ROC');
insert into Student values ( 1029, 'Han', 'Jun', 17, 'M', 100, 2311,'PEK');
insert into Student values ( 1030, 'Cheng', 'Lisa', 21, 'F', 550, 2311,'SFO');
insert into Student values ( 1031, 'Smith', 'Sarah', 20, 'F', 550, 8772,'PHL');
insert into Student values ( 1032, 'Brown', 'Eric', 20, 'M', 550, 8772,'ATL');
insert into Student values ( 1033, 'Simms', 'William', 18, 'M', 550, 8772,'NAR');
insert into Student values ( 1034, 'Epp', 'Eric', 18, 'M', 050, 5718,'BOS');
insert into Student values ( 1035, 'Schmidt', 'Sarah', 26, 'F', 050, 5718,'WAS');


insert into Minor_in values ( 1004, 520);
insert into Minor_in values ( 1005, 550);
insert into Minor_in values ( 1006, 050);
insert into Minor_in values ( 1007, 520);
insert into Minor_in values ( 1008, 550);
insert into Minor_in values ( 1014, 090);
insert into Minor_in values ( 1015, 140);
insert into Minor_in values ( 1016, 190);
insert into Minor_in values ( 1027, 530);
insert into Minor_in values ( 1031, 540);


insert into Enrolled_in values ( 1001, '550.681', 'A-');
insert into Enrolled_in values ( 1001, '600.303', 'B');
insert into Enrolled_in values ( 1001, '600.315', 'B+');
insert into Enrolled_in values ( 1001, '600.337', 'A');
insert into Enrolled_in values ( 1001, '600.461', 'B-');
insert into Enrolled_in values ( 1001, '600.465', 'B');
insert into Enrolled_in values ( 1002, '520.213', 'B+');
insert into Enrolled_in values ( 1002, '600.211', 'C');
insert into Enrolled_in values ( 1002, '600.303', 'C+');
insert into Enrolled_in values ( 1002, '600.337', 'A');
insert into Enrolled_in values ( 1002, '600.463', 'B');
insert into Enrolled_in values ( 1002, '600.465', 'B+');
insert into Enrolled_in values ( 1003, '600.333', 'B');
insert into Enrolled_in values ( 1003, '600.337', 'B');
insert into Enrolled_in values ( 1003, '600.415', 'B');
insert into Enrolled_in values ( 1003, '600.461', 'B+');
insert into Enrolled_in values ( 1003, '600.465', 'B');
insert into Enrolled_in values ( 1004, '600.303', 'C-');
insert into Enrolled_in values ( 1004, '600.415', 'C-');
insert into Enrolled_in values ( 1004, '600.437', 'C-');
insert into Enrolled_in values ( 1004, '600.445', 'A-');
insert into Enrolled_in values ( 1004, '600.461', 'C');
insert into Enrolled_in values ( 1004, '600.463', 'A+');
insert into Enrolled_in values ( 1004, '600.465', 'A');
insert into Enrolled_in values ( 1005, '600.103', 'A');
insert into Enrolled_in values ( 1005, '600.107', 'C+');
insert into Enrolled_in values ( 1005, '600.113', 'C');
insert into Enrolled_in values ( 1005, '600.227', 'A');
insert into Enrolled_in values ( 1005, '600.303', 'B');
insert into Enrolled_in values ( 1006, '550.420', 'B');
insert into Enrolled_in values ( 1006, '600.107', 'B+');
insert into Enrolled_in values ( 1006, '600.227', 'B-');
insert into Enrolled_in values ( 1006, '600.232', 'C-');
insert into Enrolled_in values ( 1006, '600.303', 'A-');
insert into Enrolled_in values ( 1006, '600.315', 'A');
insert into Enrolled_in values ( 1007, '550.420', 'A');
insert into Enrolled_in values ( 1007, '600.113', 'A-');
insert into Enrolled_in values ( 1007, '600.227', 'C+');
insert into Enrolled_in values ( 1007, '600.315', 'A');
insert into Enrolled_in values ( 1007, '600.333', 'A-');
insert into Enrolled_in values ( 1007, '600.337', 'C');
insert into Enrolled_in values ( 1008, '600.415', 'A+');
insert into Enrolled_in values ( 1008, '600.463', 'B');
insert into Enrolled_in values ( 1008, '600.465', 'B');
insert into Enrolled_in values ( 1008, '600.657', 'B');
insert into Enrolled_in values ( 1008, '600.787', 'B');
insert into Enrolled_in values ( 1009, '550.413', 'B+');
insert into Enrolled_in values ( 1009, '550.471', 'C');
insert into Enrolled_in values ( 1009, '550.620', 'A-');
insert into Enrolled_in values ( 1009, '550.626', 'B');
insert into Enrolled_in values ( 1009, '550.671', 'C');
insert into Enrolled_in values ( 1009, '550.681', 'A');
insert into Enrolled_in values ( 1009, '550.661', 'B-');
insert into Enrolled_in values ( 1009, '550.631', 'A-');
insert into Enrolled_in values ( 1010, '550.291', 'A');
insert into Enrolled_in values ( 1010, '550.310', 'A');
insert into Enrolled_in values ( 1010, '550.413', 'C+');
insert into Enrolled_in values ( 1010, '550.420', 'A');
insert into Enrolled_in values ( 1010, '550.471', 'A');
insert into Enrolled_in values ( 1010, '600.107', 'B+');
insert into Enrolled_in values ( 1011, '520.213', 'B');
insert into Enrolled_in values ( 1011, '520.345', 'B');
insert into Enrolled_in values ( 1011, '520.349', 'A');
insert into Enrolled_in values ( 1011, '520.353', 'A-');
insert into Enrolled_in values ( 1011, '550.420', 'B');
insert into Enrolled_in values ( 1011, '600.415', 'B+');
insert into Enrolled_in values ( 1012, '050.109', 'B-');
insert into Enrolled_in values ( 1012, '050.203', 'B-');
insert into Enrolled_in values ( 1012, '050.325', 'A-');
insert into Enrolled_in values ( 1012, '600.107', 'A');
insert into Enrolled_in values ( 1012, '600.315', 'B');
insert into Enrolled_in values ( 1014, '600.107', 'A');
insert into Enrolled_in values ( 1014, '600.227', 'A');
insert into Enrolled_in values ( 1014, '600.232', 'A');
insert into Enrolled_in values ( 1014, '600.315', 'A+');
insert into Enrolled_in values ( 1014, '600.445', 'B');
insert into Enrolled_in values ( 1014, '600.461', 'B');
insert into Enrolled_in values ( 1014, '600.463', 'B');
insert into Enrolled_in values ( 1015, '550.420', 'A');
insert into Enrolled_in values ( 1015, '600.227', 'A+');
insert into Enrolled_in values ( 1015, '600.303', 'A');
insert into Enrolled_in values ( 1015, '600.315', 'C-');
insert into Enrolled_in values ( 1015, '600.333', 'A');
insert into Enrolled_in values ( 1016, '050.109', 'B-');
insert into Enrolled_in values ( 1016, '050.203', 'D-');
insert into Enrolled_in values ( 1016, '050.325', 'A');
insert into Enrolled_in values ( 1016, '050.821', 'A');
insert into Enrolled_in values ( 1016, '550.420', 'A-');
insert into Enrolled_in values ( 1016, '600.107', 'B+');
insert into Enrolled_in values ( 1016, '600.315', 'B-');
insert into Enrolled_in values ( 1017, '050.427', 'B');
insert into Enrolled_in values ( 1017, '050.670', 'B');
insert into Enrolled_in values ( 1017, '050.802', 'C');
insert into Enrolled_in values ( 1017, '550.681', 'B');
insert into Enrolled_in values ( 1017, '600.109', 'A-');
insert into Enrolled_in values ( 1017, '600.461', 'A');
insert into Enrolled_in values ( 1017, '600.465', 'C');
insert into Enrolled_in values ( 1018, '520.213', 'A-');
insert into Enrolled_in values ( 1018, '600.211', 'A');
insert into Enrolled_in values ( 1018, '600.303', 'A');
insert into Enrolled_in values ( 1018, '600.337', 'C-');
insert into Enrolled_in values ( 1018, '600.463', 'B');
insert into Enrolled_in values ( 1018, '600.465', 'B');
insert into Enrolled_in values ( 1019, '600.103', 'B');
insert into Enrolled_in values ( 1019, '600.107', 'B');
insert into Enrolled_in values ( 1019, '600.113', 'D+');
insert into Enrolled_in values ( 1019, '600.227', 'A');
insert into Enrolled_in values ( 1019, '600.303', 'A');
insert into Enrolled_in values ( 1020, '600.333', 'A');
insert into Enrolled_in values ( 1020, '600.337', 'A');
insert into Enrolled_in values ( 1020, '600.415', 'A');
insert into Enrolled_in values ( 1020, '600.461', 'A');
insert into Enrolled_in values ( 1020, '600.465', 'A');
insert into Enrolled_in values ( 1021, '600.303', 'B-');
insert into Enrolled_in values ( 1021, '600.303', 'B');
insert into Enrolled_in values ( 1021, '600.415', 'B');
insert into Enrolled_in values ( 1021, '600.437', 'B');
insert into Enrolled_in values ( 1021, '600.437', 'B');
insert into Enrolled_in values ( 1021, '600.445', 'B-');
insert into Enrolled_in values ( 1021, '600.445', 'C');
insert into Enrolled_in values ( 1021, '600.463', 'A');
insert into Enrolled_in values ( 1021, '600.463', 'B');
insert into Enrolled_in values ( 1022, '550.420', 'B');
insert into Enrolled_in values ( 1022, '550.420', 'B+');
insert into Enrolled_in values ( 1022, '600.107', 'A');
insert into Enrolled_in values ( 1022, '600.227', 'A');
insert into Enrolled_in values ( 1022, '600.227', 'A');
insert into Enrolled_in values ( 1022, '600.232', 'B');
insert into Enrolled_in values ( 1022, '600.303', 'B');
insert into Enrolled_in values ( 1022, '600.315', 'D');
insert into Enrolled_in values ( 1022, '600.461', 'A');
insert into Enrolled_in values ( 1023, '600.113', 'A-');
insert into Enrolled_in values ( 1023, '600.315', 'B');
insert into Enrolled_in values ( 1023, '600.333', 'B');
insert into Enrolled_in values ( 1023, '600.337', 'B+');
insert into Enrolled_in values ( 1023, '600.463', 'A');
insert into Enrolled_in values ( 1023, '600.465', 'A');
insert into Enrolled_in values ( 1023, '600.657', 'B');
insert into Enrolled_in values ( 1023, '600.787', 'B');
insert into Enrolled_in values ( 1024, '550.291', 'B');
insert into Enrolled_in values ( 1024, '550.413', 'C');
insert into Enrolled_in values ( 1024, '550.471', 'A-');
insert into Enrolled_in values ( 1024, '550.620', 'A');
insert into Enrolled_in values ( 1024, '550.626', 'B');
insert into Enrolled_in values ( 1024, '550.671', 'B');
insert into Enrolled_in values ( 1024, '550.681', 'B');
insert into Enrolled_in values ( 1024, '600.415', 'B');
insert into Enrolled_in values ( 1025, '520.213', 'A');
insert into Enrolled_in values ( 1025, '520.345', 'A+');
insert into Enrolled_in values ( 1025, '550.310', 'A');
insert into Enrolled_in values ( 1025, '550.413', 'A');
insert into Enrolled_in values ( 1025, '550.420', 'C');
insert into Enrolled_in values ( 1025, '550.471', 'B');
insert into Enrolled_in values ( 1025, '600.107', 'B');
insert into Enrolled_in values ( 1026, '520.349', 'A');
insert into Enrolled_in values ( 1026, '520.353', 'A');
insert into Enrolled_in values ( 1026, '600.303', 'A');
insert into Enrolled_in values ( 1026, '600.437', 'A');
insert into Enrolled_in values ( 1026, '600.445', 'A');
insert into Enrolled_in values ( 1026, '600.463', 'B-');
insert into Enrolled_in values ( 1027, '600.107', 'B');
insert into Enrolled_in values ( 1027, '600.227', 'B');
insert into Enrolled_in values ( 1027, '600.232', 'B');
insert into Enrolled_in values ( 1027, '600.303', 'B');
insert into Enrolled_in values ( 1027, '600.315', 'B-');
insert into Enrolled_in values ( 1027, '600.461', 'B-');
insert into Enrolled_in values ( 1027, '600.463', 'B');
insert into Enrolled_in values ( 1028, '550.420', 'B+');
insert into Enrolled_in values ( 1028, '600.227', 'A');
insert into Enrolled_in values ( 1028, '600.315', 'A+');
insert into Enrolled_in values ( 1028, '600.333', 'A');
insert into Enrolled_in values ( 1028, '600.337', 'A+');
insert into Enrolled_in values ( 1029, '550.413', 'C-');
insert into Enrolled_in values ( 1029, '550.471', 'A');
insert into Enrolled_in values ( 1029, '550.620', 'B-');
insert into Enrolled_in values ( 1029, '550.671', 'A-');
insert into Enrolled_in values ( 1029, '600.113', 'B-');
insert into Enrolled_in values ( 1029, '600.463', 'A+');
insert into Enrolled_in values ( 1030, '520.345', 'B');
insert into Enrolled_in values ( 1030, '550.291', 'B');
insert into Enrolled_in values ( 1030, '550.310', 'B-');
insert into Enrolled_in values ( 1030, '550.413', 'B-');
insert into Enrolled_in values ( 1030, '550.420', 'B');
insert into Enrolled_in values ( 1030, '550.471', 'B+');
insert into Enrolled_in values ( 1030, '600.107', 'B');
insert into Enrolled_in values ( 1031, '520.213', 'B+');
insert into Enrolled_in values ( 1031, '520.349', 'B');
insert into Enrolled_in values ( 1031, '520.353', 'C');
insert into Enrolled_in values ( 1031, '600.437', 'A+');
insert into Enrolled_in values ( 1032, '550.420', 'A-');
insert into Enrolled_in values ( 1032, '550.420', 'D-');
insert into Enrolled_in values ( 1032, '600.232', 'A-');
insert into Enrolled_in values ( 1032, '600.303', 'A');
insert into Enrolled_in values ( 1032, '600.315', 'A');
insert into Enrolled_in values ( 1033, '600.113', 'A');
insert into Enrolled_in values ( 1033, '600.227', 'A');
insert into Enrolled_in values ( 1033, '600.315', 'A');
insert into Enrolled_in values ( 1033, '600.333', 'A');
insert into Enrolled_in values ( 1033, '600.337', 'B');
insert into Enrolled_in values ( 1034, '050.109', 'B+');
insert into Enrolled_in values ( 1034, '050.203', 'B');
insert into Enrolled_in values ( 1034, '050.325', 'B');
insert into Enrolled_in values ( 1034, '600.107', 'B+');
insert into Enrolled_in values ( 1034, '600.315', 'B');
insert into Enrolled_in values ( 1035, '050.381', 'B-');
insert into Enrolled_in values ( 1035, '050.427', 'A-');
insert into Enrolled_in values ( 1035, '050.670', 'B');
insert into Enrolled_in values ( 1035, '050.802', 'D');
insert into Enrolled_in values ( 1035, '050.821', 'A');
insert into Enrolled_in values ( 1035, '600.109', 'B-');


insert into Gradeconversion values ('A+', 4.0);
insert into Gradeconversion values ('A',  4.0);
insert into Gradeconversion values ('A-', 3.7);
insert into Gradeconversion values ('B+', 3.3);
insert into Gradeconversion values ('B',  3.0);
insert into Gradeconversion values ('B-', 2.7);
insert into Gradeconversion values ('C+', 2.3);
insert into Gradeconversion values ('C',  2.0);
insert into Gradeconversion values ('C-', 1.7);
insert into Gradeconversion values ('D+', 1.3);
insert into Gradeconversion values ('D',  1.0);
insert into Gradeconversion values ('D-', 0.7);
insert into Gradeconversion values ('F',  0.0);


insert into Dorm values (100,'Smith Hall',85,'X');
insert into Dorm values (110,'Bud Jones Hall',116,'M');
insert into Dorm values (140,'Fawlty Towers',355,'X');
insert into Dorm values (160,'Dorm-plex 2000',400,'X');
insert into Dorm values (109,'Anonymous Donor Hall',128,'F');
insert into Dorm values (117,'University Hovels',40,'X');
insert into Dorm values (104,'Grad Student Asylum',256,'X');


insert into Dorm_amenity values ( 900 , 'TV Lounge' ) ;
insert into Dorm_amenity values ( 901 , 'Study Room' ) ;
insert into Dorm_amenity values ( 902 , 'Pub in Basement' ) ;
insert into Dorm_amenity values ( 903 , 'Carpeted Rooms' ) ;
insert into Dorm_amenity values ( 904 , '4 Walls' ) ;
insert into Dorm_amenity values ( 930 , 'Roof' ) ;
insert into Dorm_amenity values ( 931 , 'Ethernet Ports' ) ;
insert into Dorm_amenity values ( 932 , 'Air Conditioning' ) ;
insert into Dorm_amenity values ( 922 , 'Heat' ) ;
insert into Dorm_amenity values ( 950 , 'Working Fireplaces' ) ;
insert into Dorm_amenity values ( 955 , 'Kitchen in Every Room' ) ;
insert into Dorm_amenity values ( 909 , 'Allows Pets' ) ;


insert into Has_amenity values ( 109 ,  900) ;
insert into Has_amenity values ( 109 ,  901) ;
insert into Has_amenity values ( 109 ,  903) ;
insert into Has_amenity values ( 109 ,  904 ) ;
insert into Has_amenity values ( 109 ,  930 ) ;
insert into Has_amenity values ( 109 ,  931) ;
insert into Has_amenity values ( 109 ,  932) ;
insert into Has_amenity values ( 109 ,  922) ;
insert into Has_amenity values ( 104 ,  901) ;
insert into Has_amenity values ( 104 ,  904) ;
insert into Has_amenity values ( 104 ,  930 ) ;
insert into Has_amenity values ( 160 , 900 ) ;
insert into Has_amenity values ( 160 , 901 ) ;
insert into Has_amenity values ( 160 , 902 ) ;
insert into Has_amenity values ( 160 , 903 ) ;
insert into Has_amenity values ( 160 , 931 ) ;
insert into Has_amenity values ( 160 ,  904) ;
insert into Has_amenity values ( 160 ,  930 ) ;
insert into Has_amenity values ( 160 ,  922 ) ;
insert into Has_amenity values ( 160 , 932 ) ;
insert into Has_amenity values ( 160 , 950 ) ;
insert into Has_amenity values ( 160 , 955 ) ;
insert into Has_amenity values ( 160 , 909 ) ;
insert into Has_amenity values ( 100 ,  901) ;
insert into Has_amenity values ( 100 ,  903) ;
insert into Has_amenity values ( 100 ,  904) ;
insert into Has_amenity values ( 100 ,  930 ) ;
insert into Has_amenity values ( 100 ,  922 ) ;
insert into Has_amenity values ( 117 ,  930 ) ;
insert into Has_amenity values ( 110 ,  901) ;
insert into Has_amenity values ( 110 ,  903) ;
insert into Has_amenity values ( 110 ,  904) ;
insert into Has_amenity values ( 110 ,  930 ) ;
insert into Has_amenity values ( 110 ,  922 ) ;
insert into Has_amenity values ( 140 ,  909 ) ;
insert into Has_amenity values ( 140 ,  900) ;
insert into Has_amenity values ( 140 ,  902) ;
insert into Has_amenity values ( 140 ,  904) ;
insert into Has_amenity values ( 140 ,  930 ) ;
insert into Has_amenity values ( 140 ,  932 ) ;


insert into Lives_in values ( 1001  , 109  , 105  ) ;
insert into Lives_in values ( 1002  , 100  , 112  ) ;
insert into Lives_in values ( 1003  , 100  , 124  ) ;
insert into Lives_in values ( 1004  , 140  , 215  ) ;
insert into Lives_in values ( 1005  , 160  , 333  ) ;
insert into Lives_in values ( 1007  , 140  , 113  ) ;
insert into Lives_in values ( 1008  , 160  , 334  ) ;
insert into Lives_in values ( 1009  , 140  , 332  ) ;
insert into Lives_in values ( 1010  , 160  , 443  ) ;
insert into Lives_in values ( 1011  , 140  , 102  ) ;
insert into Lives_in values ( 1012  , 160  , 333  ) ;
insert into Lives_in values ( 1014  , 104  , 211  ) ;
insert into Lives_in values ( 1015  , 160  , 443  ) ;
insert into Lives_in values ( 1016  , 140  , 301  ) ;
insert into Lives_in values ( 1017  , 140  , 319  ) ;
insert into Lives_in values ( 1018  , 140  , 225  ) ;
insert into Lives_in values ( 1020  , 160  , 405  ) ;
insert into Lives_in values ( 1021  , 160  , 405  ) ;
insert into Lives_in values ( 1022  , 100  , 153  ) ;
insert into Lives_in values ( 1023  , 160  , 317  ) ;
insert into Lives_in values ( 1024  , 100  , 151  ) ;
insert into Lives_in values ( 1025  , 160  , 317  ) ;
insert into Lives_in values ( 1027  , 140  , 208  ) ;
insert into Lives_in values ( 1028  , 110  , 48  ) ;
insert into Lives_in values ( 1029  , 140  , 418  ) ;
insert into Lives_in values ( 1030  , 109  , 211  ) ;
insert into Lives_in values ( 1031  , 100  , 112  ) ;
insert into Lives_in values ( 1032  , 109  , 105  ) ;
insert into Lives_in values ( 1033  , 117  , 3  ) ;
insert into Lives_in values ( 1034  , 160  , 105  ) ;
insert into Lives_in values ( 1035  , 100  , 124  ) ;


insert into Preferences values ( 1001, 'LateNighter', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1002, 'LateNighter', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1003, 'MidRange', 'StudiesWith', 'no' );
insert into Preferences values ( 1004, 'EarlyRiser', 'StudiesWithout', 'no' );
insert into Preferences values ( 1005, 'MidRange', 'StudiesWithout', 'no-accept' );
insert into Preferences values ( 1006, 'LateNighter', 'StudiesWith', 'no-accept' );
insert into Preferences values ( 1007, 'EarlyRiser', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1008, 'LateNighter', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1009, 'EarlyRiser', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1010, 'MidRange', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1011, 'LateNighter', 'StudiesWithout', 'no' );
insert into Preferences values ( 1012, 'LateNighter', 'StudiesWith', 'no' );
insert into Preferences values ( 1014, 'EarlyRiser', 'StudiesWithout', 'no' );
insert into Preferences values ( 1015, 'MidRange', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1016, 'MidRange', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1017, 'EarlyRiser', 'StudiesWithout', 'no' );
insert into Preferences values ( 1018, 'MidRange', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1019, 'LateNighter', 'StudiesWithout', 'no' );
insert into Preferences values ( 1020, 'LateNighter', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1021, 'EarlyRiser', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1022, 'MidRange', 'StudiesWithout', 'no-accept' );
insert into Preferences values ( 1023, 'MidRange', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1024, 'EarlyRiser', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1025, 'LateNighter', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1026, 'LateNighter', 'StudiesWith','no-accept' );
insert into Preferences values ( 1027, 'LateNighter', 'StudiesWith', 'Yes' );
insert into Preferences values ( 1028, 'EarlyRiser', 'StudiesWithout', 'no' );
insert into Preferences values ( 1029, 'MidRange', 'StudiesWith', 'no' );
insert into Preferences values ( 1030, 'LateNighter', 'StudiesWithout', 'Yes' );
insert into Preferences values ( 1031, 'EarlyRiser', 'StudiesWith', 'no' );
insert into Preferences values ( 1032, 'LateNighter', 'StudiesWithout', 'no' );
insert into Preferences values ( 1033, 'LateNighter', 'StudiesWith', 'no' );
insert into Preferences values ( 1034, 'EarlyRiser', 'StudiesWith', 'no' );
insert into Preferences values ( 1035, 'LateNighter', 'StudiesWith', 'no' );

insert into Has_Allergy values ( 1001, 'Cat' );
insert into Has_Allergy values ( 1002, 'Shellfish' );
insert into Has_Allergy values ( 1002, 'Tree Pollen' );
insert into Has_Allergy values ( 1003, 'Dog' );
insert into Has_Allergy values ( 1004, 'Nuts' );
insert into Has_Allergy values ( 1005, 'Nuts' );
insert into Has_Allergy values ( 1005, 'Tree Pollen' );
insert into Has_Allergy values ( 1006, 'Nuts' );
insert into Has_Allergy values ( 1007, 'Ragweed' );
insert into Has_Allergy values ( 1007, 'Tree Pollen' );
insert into Has_Allergy values ( 1007, 'Grass Pollen' );
insert into Has_Allergy values ( 1007, 'Eggs' );
insert into Has_Allergy values ( 1007, 'Milk' );
insert into Has_Allergy values ( 1007, 'Shellfish' );
insert into Has_Allergy values ( 1007, 'Anchovies' );
insert into Has_Allergy values ( 1007, 'Cat' );
insert into Has_Allergy values ( 1007, 'Dog' );
insert into Has_Allergy values ( 1009, 'Tree Pollen' );
insert into Has_Allergy values ( 1010, 'Ragweed' );
insert into Has_Allergy values ( 1010, 'Tree Pollen' );
insert into Has_Allergy values ( 1010, 'Grass Pollen' );
insert into Has_Allergy values ( 1010, 'Eggs' );
insert into Has_Allergy values ( 1010, 'Milk' );
insert into Has_Allergy values ( 1010, 'Shellfish' );
insert into Has_Allergy values ( 1010, 'Anchovies' );
insert into Has_Allergy values ( 1010, 'Cat' );
insert into Has_Allergy values ( 1010, 'Dog' );
insert into Has_Allergy values ( 1011, 'Ragweed' );
insert into Has_Allergy values ( 1012, 'Ragweed' );
insert into Has_Allergy values ( 1013, 'Ragweed' );
insert into Has_Allergy values ( 1014, 'Nuts' );
insert into Has_Allergy values ( 1015, 'Nuts' );
insert into Has_Allergy values ( 1015, 'Soy' );
insert into Has_Allergy values ( 1016, 'Nuts' );
insert into Has_Allergy values ( 1016, 'Milk' );
insert into Has_Allergy values ( 1017, 'Tree Pollen' );
insert into Has_Allergy values ( 1018, 'Nuts'  );
insert into Has_Allergy values ( 1018, 'Soy'  );
insert into Has_Allergy values ( 1019, 'Tree Pollen' );
insert into Has_Allergy values ( 1020, 'Tree Pollen' );
insert into Has_Allergy values ( 1021, 'Tree Pollen' );
insert into Has_Allergy values ( 1022, 'Nuts'  );
insert into Has_Allergy values ( 1022, 'Anchovies'  );
insert into Has_Allergy values ( 1023, 'Rodent'  );
insert into Has_Allergy values ( 1023, 'Cat'  );
insert into Has_Allergy values ( 1023, 'Nuts'  );
insert into Has_Allergy values ( 1024, 'Ragweed' );
insert into Has_Allergy values ( 1024, 'Tree Pollen' );
insert into Has_Allergy values ( 1025, 'Tree Pollen' );
insert into Has_Allergy values ( 1026, 'Grass Pollen' );
insert into Has_Allergy values ( 1027, 'Tree Pollen' );
insert into Has_Allergy values ( 1028, 'Tree Pollen' );
insert into Has_Allergy values ( 1029, 'Soy'  );
insert into Has_Allergy values ( 1029, 'Nuts'  );
insert into Has_Allergy values ( 1029, 'Eggs'  );
insert into Has_Allergy values ( 1030, 'Grass Pollen' );
insert into Has_Allergy values ( 1031, 'Nuts' );
insert into Has_Allergy values ( 1031, 'Shellfish' );
insert into Has_Allergy values ( 1031, 'Soy' );

insert into Allergy_Type values ( 'Eggs', 'food' );
insert into Allergy_Type values ( 'Nuts', 'food' );
insert into Allergy_Type values ( 'Milk', 'food' );
insert into Allergy_Type values ( 'Shellfish', 'food' );
insert into Allergy_Type values ( 'Anchovies', 'food' );
insert into Allergy_Type values ( 'Wheat', 'food' );
insert into Allergy_Type values ( 'Soy', 'food' );
insert into Allergy_Type values ( 'Ragweed', 'environmental' );
insert into Allergy_Type values ( 'Tree Pollen', 'environmental' );
insert into Allergy_Type values ( 'Grass Pollen', 'environmental' );
insert into Allergy_Type values ( 'Cat', 'animal' );
insert into Allergy_Type values ( 'Dog', 'animal' );
insert into Allergy_Type values ( 'Rodent', 'animal' );
insert into Allergy_Type values ( 'Bee Stings', 'animal' );


insert into Loves values (1001, 1014);
insert into Loves values (1001, 1027);
insert into Loves values (1002, 1005);
insert into Loves values (1003, 1009);
insert into Loves values (1005, 1035);
insert into Loves values (1006, 1008);
insert into Loves values (1006, 1024);
insert into Loves values (1007, 1011);
insert into Loves values (1008, 1006);
insert into Loves values (1009, 1030);
insert into Loves values (1010, 1015);
insert into Loves values (1012, 1024);
insert into Loves values (1014, 1001);
insert into Loves values (1015, 1010);
insert into Loves values (1016, 1017);
insert into Loves values (1017, 1016);
insert into Loves values (1019, 1015);
insert into Loves values (1020, 1031);
insert into Loves values (1021, 1031);
insert into Loves values (1022, 1031);
insert into Loves values (1023, 1031);
insert into Loves values (1024, 1012);
insert into Loves values (1024, 1005);
insert into Loves values (1025, 1031);
insert into Loves values (1026, 1015);
insert into Loves values (1028, 1024);
insert into Loves values (1029, 1030);
insert into Loves values (1031, 1002);
insert into Loves values (1032, 1001);
insert into Loves values (1032, 1002);
insert into Loves values (1032, 1003);
insert into Loves values (1032, 1008);
insert into Loves values (1032, 1030);
insert into Loves values (1032, 1031);
insert into Loves values (1032, 1035);
insert into Loves values (1033, 1031);
insert into Loves values (1034, 1031);


insert into Likes values (1001, 1006);
insert into Likes values (1001, 1012);
insert into Likes values (1001, 1014);
insert into Likes values (1001, 1016);
insert into Likes values (1001, 1022);
insert into Likes values (1001, 1027);
insert into Likes values (1002, 1001);
insert into Likes values (1002, 1002);
insert into Likes values (1002, 1005);
insert into Likes values (1002, 1019);
insert into Likes values (1002, 1020);
insert into Likes values (1002, 1022);
insert into Likes values (1002, 1026);
insert into Likes values (1002, 1028);
insert into Likes values (1003, 1002);
insert into Likes values (1003, 1003);
insert into Likes values (1003, 1005);
insert into Likes values (1003, 1009);
insert into Likes values (1003, 1028);
insert into Likes values (1003, 1030);
insert into Likes values (1004, 1004);
insert into Likes values (1004, 1005);
insert into Likes values (1004, 1007);
insert into Likes values (1004, 1009);
insert into Likes values (1004, 1011);
insert into Likes values (1005, 1001);
insert into Likes values (1005, 1005);
insert into Likes values (1005, 1006);
insert into Likes values (1005, 1008);
insert into Likes values (1005, 1010);
insert into Likes values (1005, 1022);
insert into Likes values (1005, 1026);
insert into Likes values (1005, 1027);
insert into Likes values (1005, 1029);
insert into Likes values (1006, 1006);
insert into Likes values (1006, 1008);
insert into Likes values (1006, 1017);
insert into Likes values (1006, 1019);
insert into Likes values (1006, 1021);
insert into Likes values (1006, 1024);
insert into Likes values (1006, 1030);
insert into Likes values (1006, 1032);
insert into Likes values (1006, 1033);
insert into Likes values (1006, 1034);
insert into Likes values (1006, 1035);
insert into Likes values (1007, 1001);
insert into Likes values (1007, 1003);
insert into Likes values (1007, 1005);
insert into Likes values (1007, 1008);
insert into Likes values (1007, 1011);
insert into Likes values (1007, 1021);
insert into Likes values (1007, 1023);
insert into Likes values (1007, 1034);
insert into Likes values (1008, 1001);
insert into Likes values (1008, 1003);
insert into Likes values (1008, 1004);
insert into Likes values (1008, 1005);
insert into Likes values (1008, 1006);
insert into Likes values (1008, 1008);
insert into Likes values (1008, 1009);
insert into Likes values (1008, 1011);
insert into Likes values (1008, 1014);
insert into Likes values (1008, 1016);
insert into Likes values (1008, 1017);
insert into Likes values (1008, 1018);
insert into Likes values (1008, 1020);
insert into Likes values (1008, 1021);
insert into Likes values (1008, 1023);
insert into Likes values (1008, 1024);
insert into Likes values (1008, 1026);
insert into Likes values (1008, 1027);
insert into Likes values (1008, 1032);
insert into Likes values (1008, 1033);
insert into Likes values (1009, 1005);
insert into Likes values (1009, 1006);
insert into Likes values (1009, 1008);
insert into Likes values (1009, 1010);
insert into Likes values (1009, 1014);
insert into Likes values (1009, 1015);
insert into Likes values (1009, 1030);
insert into Likes values (1010, 1001);
insert into Likes values (1010, 1009);
insert into Likes values (1010, 1011);
insert into Likes values (1010, 1012);
insert into Likes values (1010, 1014);
insert into Likes values (1010, 1015);
insert into Likes values (1010, 1016);
insert into Likes values (1010, 1017);
insert into Likes values (1010, 1030);
insert into Likes values (1011, 1011);
insert into Likes values (1011, 1020);
insert into Likes values (1011, 1021);
insert into Likes values (1011, 1023);
insert into Likes values (1011, 1025);
insert into Likes values (1011, 1027);
insert into Likes values (1011, 1028);
insert into Likes values (1011, 1031);
insert into Likes values (1012, 1001);
insert into Likes values (1012, 1002);
insert into Likes values (1012, 1004);
insert into Likes values (1012, 1006);
insert into Likes values (1012, 1008);
insert into Likes values (1012, 1011);
insert into Likes values (1012, 1012);
insert into Likes values (1012, 1014);
insert into Likes values (1012, 1015);
insert into Likes values (1012, 1023);
insert into Likes values (1012, 1024);
insert into Likes values (1012, 1026);
insert into Likes values (1012, 1029);
insert into Likes values (1012, 1030);
insert into Likes values (1014, 1001);
insert into Likes values (1015, 1008);
insert into Likes values (1015, 1009);
insert into Likes values (1015, 1010);
insert into Likes values (1015, 1011);
insert into Likes values (1015, 1012);
insert into Likes values (1015, 1014);
insert into Likes values (1015, 1015);
insert into Likes values (1015, 1016);
insert into Likes values (1015, 1017);
insert into Likes values (1015, 1030);
insert into Likes values (1016, 1001);
insert into Likes values (1016, 1002);
insert into Likes values (1016, 1003);
insert into Likes values (1016, 1004);
insert into Likes values (1016, 1008);
insert into Likes values (1016, 1016);
insert into Likes values (1016, 1017);
insert into Likes values (1016, 1025);
insert into Likes values (1016, 1027);
insert into Likes values (1016, 1030);
insert into Likes values (1017, 1001);
insert into Likes values (1017, 1002);
insert into Likes values (1017, 1003);
insert into Likes values (1017, 1004);
insert into Likes values (1017, 1016);
insert into Likes values (1017, 1017);
insert into Likes values (1017, 1025);
insert into Likes values (1017, 1027);
insert into Likes values (1017, 1030);
insert into Likes values (1019, 1008);
insert into Likes values (1019, 1015);
insert into Likes values (1019, 1019);
insert into Likes values (1019, 1025);
insert into Likes values (1019, 1026);
insert into Likes values (1019, 1028);
insert into Likes values (1019, 1030);
insert into Likes values (1019, 1034);
insert into Likes values (1019, 1035);
insert into Likes values (1020, 1001);
insert into Likes values (1020, 1004);
insert into Likes values (1020, 1006);
insert into Likes values (1020, 1008);
insert into Likes values (1020, 1009);
insert into Likes values (1020, 1012);
insert into Likes values (1020, 1015);
insert into Likes values (1020, 1017);
insert into Likes values (1020, 1019);
insert into Likes values (1020, 1020);
insert into Likes values (1020, 1021);
insert into Likes values (1020, 1022);
insert into Likes values (1020, 1023);
insert into Likes values (1020, 1025);
insert into Likes values (1020, 1026);
insert into Likes values (1020, 1027);
insert into Likes values (1020, 1031);
insert into Likes values (1021, 1008);
insert into Likes values (1021, 1009);
insert into Likes values (1021, 1012);
insert into Likes values (1021, 1021);
insert into Likes values (1021, 1030);
insert into Likes values (1021, 1031);
insert into Likes values (1022, 1001);
insert into Likes values (1022, 1004);
insert into Likes values (1022, 1006);
insert into Likes values (1022, 1008);
insert into Likes values (1022, 1031);
insert into Likes values (1023, 1019);
insert into Likes values (1023, 1020);
insert into Likes values (1023, 1023);
insert into Likes values (1023, 1025);
insert into Likes values (1023, 1031);
insert into Likes values (1024, 1005);
insert into Likes values (1024, 1006);
insert into Likes values (1024, 1007);
insert into Likes values (1024, 1008);
insert into Likes values (1024, 1009);
insert into Likes values (1024, 1012);
insert into Likes values (1024, 1015);
insert into Likes values (1024, 1016);
insert into Likes values (1024, 1024);
insert into Likes values (1024, 1030);
insert into Likes values (1024, 1031);
insert into Likes values (1024, 1032);
insert into Likes values (1024, 1033);
insert into Likes values (1025, 1001);
insert into Likes values (1025, 1003);
insert into Likes values (1025, 1022);
insert into Likes values (1025, 1024);
insert into Likes values (1025, 1031);
insert into Likes values (1026, 1014);
insert into Likes values (1026, 1015);
insert into Likes values (1026, 1018);
insert into Likes values (1026, 1021);
insert into Likes values (1027, 1008);
insert into Likes values (1027, 1009);
insert into Likes values (1027, 1010);
insert into Likes values (1027, 1011);
insert into Likes values (1027, 1012);
insert into Likes values (1027, 1020);
insert into Likes values (1027, 1021);
insert into Likes values (1027, 1023);
insert into Likes values (1027, 1025);
insert into Likes values (1027, 1026);
insert into Likes values (1027, 1027);
insert into Likes values (1027, 1028);
insert into Likes values (1028, 1003);
insert into Likes values (1028, 1004);
insert into Likes values (1028, 1008);
insert into Likes values (1028, 1018);
insert into Likes values (1028, 1020);
insert into Likes values (1028, 1024);
insert into Likes values (1028, 1031);
insert into Likes values (1028, 1033);
insert into Likes values (1028, 1034);
insert into Likes values (1029, 1015);
insert into Likes values (1029, 1018);
insert into Likes values (1029, 1029);
insert into Likes values (1029, 1030);
insert into Likes values (1030, 1025);
insert into Likes values (1030, 1026);
insert into Likes values (1030, 1027);
insert into Likes values (1030, 1030);
insert into Likes values (1031, 1002);
insert into Likes values (1031, 1016);
insert into Likes values (1031, 1019);
insert into Likes values (1031, 1021);
insert into Likes values (1031, 1022);
insert into Likes values (1031, 1031);
insert into Likes values (1032, 1001);
insert into Likes values (1032, 1002);
insert into Likes values (1032, 1003);
insert into Likes values (1032, 1008);
insert into Likes values (1032, 1024);
insert into Likes values (1032, 1025);
insert into Likes values (1032, 1026);
insert into Likes values (1032, 1027);
insert into Likes values (1032, 1028);
insert into Likes values (1032, 1029);
insert into Likes values (1032, 1030);
insert into Likes values (1032, 1031);
insert into Likes values (1032, 1032);
insert into Likes values (1032, 1033);
insert into Likes values (1032, 1034);
insert into Likes values (1032, 1035);
insert into Likes values (1033, 1001);
insert into Likes values (1033, 1002);
insert into Likes values (1033, 1003);
insert into Likes values (1033, 1004);
insert into Likes values (1033, 1005);
insert into Likes values (1033, 1006);
insert into Likes values (1033, 1007);
insert into Likes values (1033, 1008);
insert into Likes values (1033, 1009);
insert into Likes values (1033, 1010);
insert into Likes values (1033, 1011);
insert into Likes values (1033, 1012);
insert into Likes values (1033, 1014);
insert into Likes values (1033, 1015);
insert into Likes values (1033, 1016);
insert into Likes values (1033, 1017);
insert into Likes values (1033, 1018);
insert into Likes values (1033, 1019);
insert into Likes values (1033, 1020);
insert into Likes values (1033, 1021);
insert into Likes values (1033, 1022);
insert into Likes values (1033, 1023);
insert into Likes values (1033, 1024);
insert into Likes values (1033, 1025);
insert into Likes values (1033, 1026);
insert into Likes values (1033, 1027);
insert into Likes values (1033, 1028);
insert into Likes values (1033, 1029);
insert into Likes values (1033, 1030);
insert into Likes values (1033, 1031);
insert into Likes values (1033, 1032);
insert into Likes values (1033, 1033);
insert into Likes values (1033, 1034);
insert into Likes values (1033, 1035);
insert into Likes values (1034, 1008);
insert into Likes values (1034, 1019);
insert into Likes values (1034, 1020);
insert into Likes values (1034, 1021);
insert into Likes values (1034, 1023);
insert into Likes values (1034, 1025);
insert into Likes values (1034, 1027);
insert into Likes values (1034, 1031);
insert into Likes values (1034, 1032);
insert into Likes values (1034, 1034);
insert into Likes values (1034, 1035);
insert into Likes values (1035, 1008);
insert into Likes values (1035, 1023);
insert into Likes values (1035, 1024);
insert into Likes values (1035, 1025);
insert into Likes values (1035, 1026);
insert into Likes values (1035, 1027);
insert into Likes values (1035, 1031);
insert into Likes values (1035, 1035);


insert into Activity values ( 770  ,   'Mountain Climbing'  ) ;
insert into Activity values ( 771  ,   'Canoeing'  ) ;
insert into Activity values ( 772  ,   'Kayaking'  ) ;
insert into Activity values ( 773  ,   'Spelunking'  ) ;
insert into Activity values ( 777  ,   'Soccer'  ) ;
insert into Activity values ( 778  ,   'Baseball'  ) ;
insert into Activity values ( 780  ,   'Football'  ) ;
insert into Activity values ( 782  ,   'Volleyball'  ) ;
insert into Activity values ( 799  ,   'Bungee Jumping' ) ;
insert into Activity values ( 779  ,   'Accordion Ensemble' ) ;
insert into Activity values ( 784  ,   'Canasta'  ) ;
insert into Activity values ( 785  ,   'Chess'  ) ;
insert into Activity values ( 776  ,   'Extreme Canasta' ) ;
insert into Activity values ( 790  ,   'Crossword Puzzles'  ) ;
insert into Activity values ( 791  ,   'Proselytizing'  ) ;
insert into Activity values ( 796  ,   'Square Dancing' ) ;




insert into Participates_in values (1001  ,  770) ;
insert into Participates_in values (1001  ,  771) ;
insert into Participates_in values (1001  ,  777) ;

insert into Participates_in values (1002  ,  772) ;
insert into Participates_in values (1002  ,  771) ;

insert into Participates_in values (1003  ,  778) ;


insert into Participates_in values (1004  ,  780) ;
insert into Participates_in values (1004  ,  782) ;
insert into Participates_in values (1004  ,  778) ;
insert into Participates_in values (1004  ,  777) ;

insert into Participates_in values (1005  ,  770) ;


insert into Participates_in values (1006  ,  773) ;


insert into Participates_in values (1007  ,  773) ;
insert into Participates_in values (1007  ,  784) ;

insert into Participates_in values (1008  ,  785) ;
insert into Participates_in values (1008  ,  773) ;
insert into Participates_in values (1008  ,  780) ;
insert into Participates_in values (1008  ,  790) ;

insert into Participates_in values (1009  ,  778) ;
insert into Participates_in values (1009  ,  777) ;
insert into Participates_in values (1009  ,  782) ;

insert into Participates_in values (1010  ,  780) ;


insert into Participates_in values (1011  ,  780) ;


insert into Participates_in values (1012  ,  780) ;


insert into Participates_in values (1014  ,  780) ;
insert into Participates_in values (1014  ,  777) ;
insert into Participates_in values (1014  ,  778) ;
insert into Participates_in values (1014  ,  782) ;
insert into Participates_in values (1014  ,  770) ;
insert into Participates_in values (1014  ,  772) ;

insert into Participates_in values (1015  ,  785) ;


insert into Participates_in values (1016  ,  791) ;
insert into Participates_in values (1016  ,  772) ;

insert into Participates_in values (1017  ,  791) ;
insert into Participates_in values (1017  ,  771) ;
insert into Participates_in values (1017  ,  770) ;

insert into Participates_in values (1018  ,  790) ;
insert into Participates_in values (1018  ,  785) ;
insert into Participates_in values (1018  ,  784) ;
insert into Participates_in values (1018  ,  777) ;
insert into Participates_in values (1018  ,  772) ;
insert into Participates_in values (1018  ,  770) ;

insert into Participates_in values (1019  ,  785) ;
insert into Participates_in values (1019  ,  790) ;

insert into Participates_in values (1020  ,  780) ;


insert into Participates_in values (1021  ,  780) ;
insert into Participates_in values (1021  ,  776) ;

insert into Participates_in values (1022  ,  782) ;
insert into Participates_in values (1022  ,  790) ;

insert into Participates_in values (1023  ,  790) ;
insert into Participates_in values (1023  ,  776) ;

insert into Participates_in values (1024  ,  778) ;
insert into Participates_in values (1024  ,  777) ;
insert into Participates_in values (1024  ,  780) ;

insert into Participates_in values (1025  ,  780) ;
insert into Participates_in values (1025  ,  777) ;
insert into Participates_in values (1025  ,  770) ;

insert into Participates_in values (1028  ,  785) ;


insert into Participates_in values (1029  ,  785) ;
insert into Participates_in values (1029  ,  790) ;

insert into Participates_in values (1030  ,  780) ;
insert into Participates_in values (1030  ,  790) ;

insert into Participates_in values (1033  ,  780) ;

insert into Participates_in values (1034  ,  780) ;
insert into Participates_in values (1034  ,  777) ;
insert into Participates_in values (1034  ,  772) ;
insert into Participates_in values (1034  ,  771) ;

insert into Participates_in values (1035  ,  777) ;
insert into Participates_in values (1035  ,  780) ;
insert into Participates_in values (1035  ,  784) ;






insert into Faculty_Participates_in values ( 1082, 784) ;
insert into Faculty_Participates_in values ( 1082, 785) ;
insert into Faculty_Participates_in values ( 1082, 790) ;

insert into Faculty_Participates_in values ( 1121, 771) ;
insert into Faculty_Participates_in values ( 1121, 777) ;
insert into Faculty_Participates_in values ( 1121, 770) ;

insert into Faculty_Participates_in values ( 1193, 790) ;
insert into Faculty_Participates_in values ( 1193, 796) ;
insert into Faculty_Participates_in values ( 1193, 773) ;

insert into Faculty_Participates_in values ( 2192, 773) ;
insert into Faculty_Participates_in values ( 2192, 790) ;
insert into Faculty_Participates_in values ( 2192, 778) ;

insert into Faculty_Participates_in values ( 3457, 782) ;
insert into Faculty_Participates_in values ( 3457, 771) ;
insert into Faculty_Participates_in values ( 3457, 784) ;

insert into Faculty_Participates_in values ( 4230, 790) ;
insert into Faculty_Participates_in values ( 4230, 785) ;

insert into Faculty_Participates_in values ( 6112, 785) ;
insert into Faculty_Participates_in values ( 6112, 772) ;

insert into Faculty_Participates_in values ( 7723, 785) ;
insert into Faculty_Participates_in values ( 7723, 770) ;

insert into Faculty_Participates_in values ( 8114, 776) ;

insert into Faculty_Participates_in values ( 8721, 770) ;
insert into Faculty_Participates_in values ( 8721, 780) ;

insert into Faculty_Participates_in values ( 8741, 780) ;
insert into Faculty_Participates_in values ( 8741, 790) ;

insert into Faculty_Participates_in values ( 8918, 780) ;
insert into Faculty_Participates_in values ( 8918, 782) ;
insert into Faculty_Participates_in values ( 8918, 771) ;

insert into Faculty_Participates_in values ( 2881, 790) ;
insert into Faculty_Participates_in values ( 2881, 784) ;

insert into Faculty_Participates_in values ( 4432, 770) ;
insert into Faculty_Participates_in values ( 4432, 771) ;

insert into Faculty_Participates_in values ( 5718, 776) ;


insert into Faculty_Participates_in values ( 6182, 776) ;
insert into Faculty_Participates_in values ( 6182, 785) ;

insert into Faculty_Participates_in values ( 1177, 790) ;
insert into Faculty_Participates_in values ( 1177, 770) ;
insert into Faculty_Participates_in values ( 1177, 770) ;

insert into Faculty_Participates_in values ( 9922, 796) ;



insert into City values ( 'BAL' , 'Baltimore' , 'MD' , 'USA' , 39.288 , -76.617 ) ;
insert into City values ( 'PIT' , 'Pittsburgh' , 'PA' , 'USA' , 40.437 , -80.000 ) ;
insert into City values ( 'PHL' , 'Philadelphia' , 'PA' , 'USA' , 39.950 , -75.150 ) ;
insert into City values ( 'WAS' , 'Washington' , 'DC' , 'USA' , 38.892 , -77.017 ) ;
insert into City values ( 'NYC' , 'New York' , 'NY' , 'USA' , 40.849 , -73.867) ;
insert into City values ( 'ATL' , 'Atlanta' , 'GA' , 'USA' , 33.763 , -84.317 ) ;
insert into City values ( 'EWR' , 'Newark' , 'NJ' , 'USA' , 40.737 , -74.167 ) ;
insert into City values ( 'FRE' , 'Frederick' , 'MD' , 'USA' , 39.415 , -77.417 ) ;
insert into City values ( 'NAR' , 'Newark' , 'DE' , 'USA' , 39.683 , -75.750 ) ;
insert into City values ( 'SAN' , 'San Diego' , 'CA' , 'USA' , 32.713 , -117.150) ;
insert into City values ( 'LOS' , 'Los Angeles' , 'CA' , 'USA' , 34.058 ,-118.250) ;
insert into City values ( 'HON' , 'Honolulu' , 'HI' , 'USA' , 21.313 , -157.850 ) ;
insert into City values ( 'SFO' , 'San Francisco' , 'CA' , 'USA' , 37.775 ,-122.417) ;
insert into City values ( 'PVD' , 'Providence' , 'RI' , 'USA' , 41.817 , -71.400 ) ;
insert into City values ( 'BOS' , 'Boston' , 'MA' , 'USA' , 42.362 , -71.050 ) ;
insert into City values ( 'DET' , 'Detroit' , 'MI' , 'USA' , 42.323 , -83.167 ) ;
insert into City values ( 'CHI' , 'Chicago' , 'IL' , 'USA' , 41.883 , -87.617 ) ;
insert into City values ( 'ROC' , 'Rochester' , 'NY' , 'USA' , 43.158 , -77.600 ) ;
insert into City values ( 'DAL' , 'Dallas' , 'TX' , 'USA' , 32.777 , -96.800 ) ;
insert into City values ( 'HOU' , 'Houston' , 'TX' , 'USA' , 29.834 , -95.000 ) ;
insert into City values ( 'MIA' , 'Miami' , 'FL' , 'USA' , 25.465 , -80.150 ) ;
insert into City values ( 'CPK' , 'College Park' , 'MD' , 'USA' , 38.987 ,-76.933) ;
insert into City values ( 'YYZ' , 'Toronto' , 'ON' , 'CANADA' , 43.650 , -79.333 ) ;
insert into City values ( 'DEL' , 'Delhi' , 'DE' , 'INDIA' , 28.617 , 77.217 ) ;
insert into City values ( 'PEK' , 'Beijing' , 'BE' , 'CHINA' , 39.917 , 116.417 ) ;
insert into City values ( 'HKG' , 'Hong Kong' , 'HK' , 'CHINA' , 22.250 ,114.167) ;
insert into City values ( 'TYO' , 'Tokyo' , 'XX' , 'JAPAN' , 35.700 , 139.767 ) ;
insert into City values ( 'LON' , 'London' , 'EN' , 'UK' , 51.500 , -0.167 ) ;
insert into City values ( 'PAR' , 'Paris' , 'XX' , 'FRANCE' , 48.867 , 2.333 ) ;
insert into City values ( 'JNB' , 'Johannesburg' , 'XX' , 'SAFRICA' , -25.550 , 28.000 ) ;
insert into City values ( 'BKK' , 'Bangkok' , 'XX' , 'THAILAND' , 13.733 , 100.500 ) ;


insert into Direct_distance values ( 'BAL' , 'ATL' , 576 ) ;
insert into Direct_distance values ( 'BAL' , 'BAL' , 0 ) ;
insert into Direct_distance values ( 'BAL' , 'BKK' , 9631 ) ;
insert into Direct_distance values ( 'BAL' , 'BOS' , 370 ) ;
insert into Direct_distance values ( 'BAL' , 'CHI' , 621 ) ;
insert into Direct_distance values ( 'BAL' , 'CPK' , 21 ) ;
insert into Direct_distance values ( 'BAL' , 'DAL' , 1217 ) ;
insert into Direct_distance values ( 'BAL' , 'DEL' , 7469 ) ;
insert into Direct_distance values ( 'BAL' , 'DET' , 408 ) ;
insert into Direct_distance values ( 'BAL' , 'EWR' , 169 ) ;
insert into Direct_distance values ( 'BAL' , 'FRE' , 35 ) ;
insert into Direct_distance values ( 'BAL' , 'HKG' , 8409 ) ;
insert into Direct_distance values ( 'BAL' , 'HON' , 4832 ) ;
insert into Direct_distance values ( 'BAL' , 'HOU' , 1240 ) ;
insert into Direct_distance values ( 'BAL' , 'JNB' , 7850 ) ;
insert into Direct_distance values ( 'BAL' , 'LON' , 3652 ) ;
insert into Direct_distance values ( 'BAL' , 'LOS' , 2329 ) ;
insert into Direct_distance values ( 'BAL' , 'MIA' , 946 ) ;
insert into Direct_distance values ( 'BAL' , 'NAR' , 71 ) ;
insert into Direct_distance values ( 'BAL' , 'NYC' , 185 ) ;
insert into Direct_distance values ( 'BAL' , 'PAR' , 3800 ) ;
insert into Direct_distance values ( 'BAL' , 'PEK' , 8041 ) ;
insert into Direct_distance values ( 'BAL' , 'PHL' , 105 ) ;
insert into Direct_distance values ( 'BAL' , 'PIT' , 210 ) ;
insert into Direct_distance values ( 'BAL' , 'PVD' , 328 ) ;
insert into Direct_distance values ( 'BAL' , 'ROC' , 277 ) ;
insert into Direct_distance values ( 'BAL' , 'SAN' , 2295 ) ;
insert into Direct_distance values ( 'BAL' , 'SFO' , 2457 ) ;
insert into Direct_distance values ( 'BAL' , 'TYO' , 6740 ) ;
insert into Direct_distance values ( 'BAL' , 'WAS' , 35 ) ;
insert into Direct_distance values ( 'BAL' , 'YYZ' , 347 ) ;
insert into Direct_distance values ( 'ATL' , 'BAL' , 576 ) ;
insert into Direct_distance values ( 'ATL' , 'PHL' , 665 ) ;
insert into Direct_distance values ( 'BKK' , 'BAL' , 9631 ) ;
insert into Direct_distance values ( 'BOS' , 'BAL' , 370 ) ;
insert into Direct_distance values ( 'BOS' , 'EWR' , 200 ) ;
insert into Direct_distance values ( 'BOS' , 'PAR' , 3448 ) ;
insert into Direct_distance values ( 'BOS' , 'PHL' , 280 ) ;
insert into Direct_distance values ( 'CHI' , 'BAL' , 621 ) ;
insert into Direct_distance values ( 'CHI' , 'PHL' , 678 ) ;
insert into Direct_distance values ( 'CPK' , 'BAL' , 21 ) ;
insert into Direct_distance values ( 'DAL' , 'BAL' , 1217 ) ;
insert into Direct_distance values ( 'DEL' , 'BAL' , 7469 ) ;
insert into Direct_distance values ( 'DET' , 'BAL' , 408 ) ;
insert into Direct_distance values ( 'DET' , 'EWR' , 488 ) ;
insert into Direct_distance values ( 'DET' , 'PHL' , 453 ) ;
insert into Direct_distance values ( 'EWR' , 'BAL' , 169 ) ;
insert into Direct_distance values ( 'EWR' , 'BOS' , 200 ) ;
insert into Direct_distance values ( 'EWR' , 'DET' , 488 ) ;
insert into Direct_distance values ( 'EWR' , 'LON' , 3458 ) ;
insert into Direct_distance values ( 'EWR' , 'LOS' , 2454 ) ;
insert into Direct_distance values ( 'EWR' , 'LOS' , 2454 ) ;
insert into Direct_distance values ( 'EWR' , 'PHL' , 89 ) ;
insert into Direct_distance values ( 'EWR' , 'SAN' , 2425 ) ;
insert into Direct_distance values ( 'EWR' , 'WAS' , 199 ) ;
insert into Direct_distance values ( 'FRE' , 'BAL' , 35 ) ;
insert into Direct_distance values ( 'HKG' , 'BAL' , 8409 ) ;
insert into Direct_distance values ( 'HON' , 'BAL' , 4832 ) ;
insert into Direct_distance values ( 'HOU' , 'BAL' , 1240 ) ;
insert into Direct_distance values ( 'HOU' , 'LOS' , 1385 ) ;
insert into Direct_distance values ( 'HOU' , 'PHL' , 1324 ) ;
insert into Direct_distance values ( 'HOU' , 'SAN' , 1270 ) ;
insert into Direct_distance values ( 'HOU' , 'SFO' , 1635 ) ;
insert into Direct_distance values ( 'JNB' , 'BAL' , 7850 ) ;
insert into Direct_distance values ( 'LON' , 'BAL' , 3652 ) ;
insert into Direct_distance values ( 'LON' , 'EWR' , 3458 ) ;
insert into Direct_distance values ( 'LON' , 'NYC' , 3452 ) ;
insert into Direct_distance values ( 'LON' , 'PHL' , 3546 ) ;
insert into Direct_distance values ( 'LON' , 'TYO' , 5975 ) ;
insert into Direct_distance values ( 'LON' , 'WAS' , 3650 ) ;
insert into Direct_distance values ( 'LOS' , 'BAL' , 2329 ) ;
insert into Direct_distance values ( 'LOS' , 'EWR' , 2454 ) ;
insert into Direct_distance values ( 'LOS' , 'EWR' , 2454 ) ;
insert into Direct_distance values ( 'LOS' , 'HOU' , 1385 ) ;
insert into Direct_distance values ( 'LOS' , 'PHL' , 2401 ) ;
insert into Direct_distance values ( 'LOS' , 'SAN' , 109 ) ;
insert into Direct_distance values ( 'MIA' , 'BAL' , 946 ) ;
insert into Direct_distance values ( 'NAR' , 'BAL' , 71 ) ;
insert into Direct_distance values ( 'NYC' , 'BAL' , 185 ) ;
insert into Direct_distance values ( 'NYC' , 'LON' , 3452 ) ;
insert into Direct_distance values ( 'PAR' , 'BAL' , 3800 ) ;
insert into Direct_distance values ( 'PAR' , 'BOS' , 3448 ) ;
insert into Direct_distance values ( 'PEK' , 'BAL' , 8041 ) ;
insert into Direct_distance values ( 'PHL' , 'ATL' , 665 ) ;
insert into Direct_distance values ( 'PHL' , 'BAL' , 105 ) ;
insert into Direct_distance values ( 'PHL' , 'BOS' , 280 ) ;
insert into Direct_distance values ( 'PHL' , 'CHI' , 678 ) ;
insert into Direct_distance values ( 'PHL' , 'DET' , 453 ) ;
insert into Direct_distance values ( 'PHL' , 'EWR' , 89 ) ;
insert into Direct_distance values ( 'PHL' , 'HOU' , 1324 ) ;
insert into Direct_distance values ( 'PHL' , 'LON' , 3546 ) ;
insert into Direct_distance values ( 'PHL' , 'LOS' , 2401 ) ;
insert into Direct_distance values ( 'PHL' , 'PIT' , 267 ) ;
insert into Direct_distance values ( 'PHL' , 'SAN' , 2369 ) ;
insert into Direct_distance values ( 'PHL' , 'SFO' , 2521 ) ;
insert into Direct_distance values ( 'PHL' , 'WAS' , 119 ) ;
insert into Direct_distance values ( 'PIT' , 'BAL' , 210 ) ;
insert into Direct_distance values ( 'PIT' , 'PHL' , 267 ) ;
insert into Direct_distance values ( 'PIT' , 'SAN' , 2106 ) ;
insert into Direct_distance values ( 'PVD' , 'BAL' , 328 ) ;
insert into Direct_distance values ( 'ROC' , 'BAL' , 277 ) ;
insert into Direct_distance values ( 'ROC' , 'WAS' , 296 ) ;
insert into Direct_distance values ( 'SAN' , 'BAL' , 2295 ) ;
insert into Direct_distance values ( 'SAN' , 'EWR' , 2425 ) ;
insert into Direct_distance values ( 'SAN' , 'HOU' , 1270 ) ;
insert into Direct_distance values ( 'SAN' , 'LOS' , 109 ) ;
insert into Direct_distance values ( 'SAN' , 'PHL' , 2369 ) ;
insert into Direct_distance values ( 'SAN' , 'PIT' , 2106 ) ;
insert into Direct_distance values ( 'SFO' , 'BAL' , 2457 ) ;
insert into Direct_distance values ( 'SFO' , 'HOU' , 1635 ) ;
insert into Direct_distance values ( 'SFO' , 'PHL' , 2521 ) ;
insert into Direct_distance values ( 'TYO' , 'BAL' , 6740 ) ;
insert into Direct_distance values ( 'TYO' , 'LON' , 5975 ) ;
insert into Direct_distance values ( 'WAS' , 'BAL' , 35 ) ;
insert into Direct_distance values ( 'WAS' , 'EWR' , 199 ) ;
insert into Direct_distance values ( 'WAS' , 'LON' , 3650 ) ;
insert into Direct_distance values ( 'WAS' , 'PHL' , 119 ) ;
insert into Direct_distance values ( 'WAS' , 'ROC' , 296 ) ;
insert into Direct_distance values ( 'YYZ' , 'BAL' , 347 ) ;

drop table Video_Games;
create table Video_Games (
       GameID           INTEGER,
       GName            VARCHAR(40),
       GType            VARCHAR(40)
);

drop table Plays_Games;
create table Plays_Games (
       StuID                INTEGER,
       GameID            INTEGER,
       Hours_Played      INTEGER
);

insert into Video_Games values ( 1, 'RNG Stone', 'Collectible card game');
insert into Video_Games values ( 2, 'The Vanishing of Eric Calder', 'Walking Simulator');
insert into Video_Games values ( 3, 'Grand Term Assignment', 'Role-playing game');
insert into Video_Games values ( 4, 'Europe is the Universe', 'Grand strategy');
insert into Video_Games values ( 5, 'Call of Destiny', 'Frist-person shooter');
insert into Video_Games values ( 6, 'Works of Widenius', 'Massively multiplayer online game');

insert into Plays_Games values ( 1001, 1, 35);
insert into Plays_Games values ( 1001, 2, 15);
insert into Plays_Games values ( 1001, 5, 1);
insert into Plays_Games values ( 1007, 4, 1000);
insert into Plays_Games values ( 1008, 5, 50);
insert into Plays_Games values ( 1008, 3, 50);
insert into Plays_Games values ( 1010, 6, 1337);
insert into Plays_Games values ( 1032, 1, 47);
insert into Plays_Games values ( 1032, 2, 10);
insert into Plays_Games values ( 1032, 3, 100);

drop table SportsInfo;
create table SportsInfo (
  StuID INTEGER,
  SportName VARCHAR(32),
  HoursPerWeek INTEGER,
  GamesPlayed INTEGER,
  OnScholarship VARCHAR(1)
);

INSERT INTO SportsInfo VALUES (1001, "Athletics", 2, 5, "N");
INSERT INTO SportsInfo VALUES (1002, "Football", 7, 20, "Y");
INSERT INTO SportsInfo VALUES (1003, "Football", 45, 18, "Y");
INSERT INTO SportsInfo VALUES (1005, "Lacrosse", 35, 16, "N");
INSERT INTO SportsInfo VALUES (1015, "Lacrosse", 25, 41, "Y");
INSERT INTO SportsInfo VALUES (1018, "Lacrosse", 39, 25, "N");
INSERT INTO SportsInfo VALUES (1019, "Swimming", 8, 16, "Y");
INSERT INTO SportsInfo VALUES (1019, "Tennis", 19, 62, "N");
INSERT INTO SportsInfo VALUES (1022, "Baseball", 29, 31, "N");
INSERT INTO SportsInfo VALUES (1023, "Basketball", 14, 8, "Y");
INSERT INTO SportsInfo VALUES (1023, "Tennis", 1, 56, "Y");
INSERT INTO SportsInfo VALUES (1026, "Cricket", 23, 37, "Y");
INSERT INTO SportsInfo VALUES (1033, "Soccer", 45, 45, "Y");
INSERT INTO SportsInfo VALUES (1035, "Curling", 50, 94, "N");

drop table Club;
create table Club (
       ClubID           INTEGER,
       ClubName         VARCHAR(40),
       ClubDesc         VARCHAR(1024)
);

drop table Member_of_club;
create table Member_of_club (
       StuID            INTEGER,
       ClubID           INTEGER,
       Position     VARCHAR(40)
);

insert into Club values ( 1, 'Bootup Baltimore', 'Refurbish computers; teach kids and adults about computer basics.');
insert into Club values ( 2, 'Hopkins Student Enterprises', 'Venture capital fund for student business.');
insert into Club values ( 3, 'Pen and Paper Gaming', 'Play pen and paper games on campus.');
insert into Club values ( 4, 'Tennis Club', 'A competitive tennis club.');

insert into Member_of_club values ( 1001, 1, 'President');
insert into Member_of_club values ( 1007, 4, 'Vice-President');
insert into Member_of_club values ( 1008, 2, 'CTO');
insert into Member_of_club values ( 1010, 1, 'Teaching Coordinator');

drop table Voting_record;
create table Voting_record (
       StuID    	INTEGER,
       Registration_Date		VARCHAR(12),
       Election_Cycle		VARCHAR(12),
       President_Vote		INTEGER,
       Vice_President_Vote		INTEGER,
       Secretary_Vote		INTEGER,
       Treasurer_Vote		INTEGER,
       Class_President_Vote		INTEGER,
       Class_Senator_Vote		INTEGER
);

insert into Voting_record values (1001, "08/30/2015", "Spring", 1004, 1007, 1010, 1035, 1001, 1028);
insert into Voting_record values (1002, "08/30/2014", "Spring", 1014, 1007, 1020, 1025, 1021, 1028);
insert into Voting_record values (1003, "08/30/2013", "Spring", 1004, 1017, 1030, 1035, 1031, 1028);
insert into Voting_record values (1004, "08/30/2013", "Spring", 1024, 1017, 1020, 1035, 1011, 1028);
insert into Voting_record values (1005, "08/30/2012", "Spring", 1024, 1017, 1010, 1035, 1021, 1028);
insert into Voting_record values (1001, "08/30/2015", "Fall", 1004, 1007, 1010, 1035, 1021, 1028);
insert into Voting_record values (1002, "08/30/2014", "Fall", 1004, 1007, 1020, 1035, 1021, 1028);
insert into Voting_record values (1003, "08/30/2013", "Fall", 1004, 1017, 1020, 1035, 1031, 1028);
insert into Voting_record values (1004, "08/30/2013", "Fall", 1024, 1017, 1020, 1035, 1011, 1018);
insert into Voting_record values (1005, "08/30/2012", "Fall", 1024, 1017, 1010, 1035, 1021, 1028);


drop table Restaurant;
create table Restaurant (
       ResID       INTEGER,
       ResName     VARCHAR(100),
       Address     VARCHAR(100)
);

drop table Type_Of_Restaurant;
create table Type_Of_Restaurant (
       ResID       INTEGER,
       ResTypeID   INTEGER
);

drop table Restaurant_Type;
create table Restaurant_Type (
       ResTypeID            INTEGER,
       ResTypeName          VARCHAR(40),
       ResTypeDescription   VARCHAR(100)
);

drop table Visits_Restaurant;
create table Visits_Restaurant (
       StuID      INTEGER,
       ResID      INTEGER,
       Time       TIMESTAMP,
       Spent      FLOAT
);

insert into Restaurant values ( 1, 'Subway', '3233 St Paul St, Baltimore, MD 21218');
insert into Restaurant values ( 2, 'Honeygrow', '3212 St Paul St, Baltimore, MD 21218');

insert into Restaurant_Type values ( 1, 'Sandwich', 'Simplest there is.');
insert into Restaurant_Type values ( 2, 'Stir-fry', 'Classic Chinese cooking.');

insert into Type_Of_Restaurant values (1, 1);
insert into Type_Of_Restaurant values (2, 2);

insert into Visits_Restaurant values (1001, 1, '2017-10-09 18:15:00', 6.53);
insert into Visits_Restaurant values (1032, 2, '2017-10-08 13:00:30', 13.2);



drop table Publications;
create table Publications (
       PID              INT,
       PTITLE           VARCHAR(180),
       published_on     DATE,
       published_at     VARCHAR(60)
);

drop table FacultyAuthor;
create table FacultyAuthor (
       PID              INT,
       FacID            INTEGER
);

drop table StudentAuthor;
create table StudentAuthor (
       PID              INT,
       StuID            INTEGER
);



insert into Publications  values ( 1001, 'Saliency-driven Word Alignment Interpretation for Neural Machine Translation', '2019-11-11', 'ACL 2019 conference');
insert into Publications  values ( 1002, 'End to end speaker recognition', '2011-03-10', 'NTU conference on upcoming Technologies');
insert into Publications  values ( 1003, 'Reports from the Annual Austin conference on data science', '2017-11-11', 'Advancement in Computer Science Journal');
insert into Publications  values ( 1001, 'Saliency-driven Word Alignment Interpretation for Neural Machine Translation', '2019-11-11', 'ACL 2019 conference');

insert into FacultyAuthor values (1001, 9514);
insert into FacultyAuthor values (1002, 9514);
insert into FacultyAuthor values (1003, 9514);
insert into FacultyAuthor values (1004, 9514);

insert into StudentAuthor values (1001, 1001);
insert into StudentAuthor values (1002, 1001);
insert into StudentAuthor values (1003, 1002);
insert into StudentAuthor values (1003, 1003);
insert into StudentAuthor values (1004, 1004);
insert into StudentAuthor values (1004, 1006);
insert into StudentAuthor values (1004, 1007);
insert into StudentAuthor values (1004, 1011);
insert into StudentAuthor values (1004, 1012);

drop table Course_CA;
create table Course_CA (
        StuID           INTEGER,
        CID             VARCHAR(7),
        Office_Hours_Days               VARCHAR(5),
        Office_Hours_Time               VARCHAR(11)
);


insert into Course_CA values (1016, '050.821', 'M', '1:15-3:15');
insert into Course_CA values (1032, '550.631', 'ThF', '3:00-4:00');
insert into Course_CA values (1006, '550.661', 'TuF', '10:00-11:00');
insert into Course_CA values (1033, '550.790', 'MW', '4:00-5:00');
insert into Course_CA values (1012, '600.415', 'T', '6:30-8:30');
insert into Course_CA values (1014, '600.415', 'Th', '2:30-4:30');
insert into Course_CA values (1003, '600.109', 'WTh', '2:00-3:00');


drop table Competition;
create table Competition (
        CompetitionID   INTEGER,
        CompetitionName VARCHAR(30),
        CompetitionDeadline DATE
);

insert into Competition values (1, "HopHacks", '2020-03-17');
insert into Competition values (2, "MedHacks", '2019-11-11');


drop table Competition_Participant;
create table Competition_Participant (
        StuID           INTEGER,
        TeamID          VARCHAR(30),
        CompetitionID   INTEGER
);

insert into Competition_Participant values (1003, "Rocking Sisters", 1);
insert into Competition_Participant values (1004, "Rocking Sisters", 1);
insert into Competition_Participant values (1005, "Rocking Sisters", 1);
insert into Competition_Participant values (1006, "Cruel Hackers", 1);
insert into Competition_Participant values (1007, "Cruel Hackers", 1);
insert into Competition_Participant values (1008, "Cruel Hackers", 1);
insert into Competition_Participant values (1003, "Rocking Sisters", 2);
insert into Competition_Participant values (1004, "Rocking Sisters", 2);
insert into Competition_Participant values (1005, "Rocking Sisters", 2);
insert into Competition_Participant values (1006, "Nice Hackers", 2);
insert into Competition_Participant values (1008, "Nice Hackers", 2);
insert into Competition_Participant values (1007, "Solo Hacker", 2);


drop table Car ;
CREATE TABLE Car (
  CarID VARCHAR(5),
  CarManufacturer varchar(255),
  CarModel varchar(255),
  miles_per_gallon INTEGER
);
insert into Car  values ( 'C1001', 'Nissan', 'Sentra', 35);
insert into Car  values ( 'C1002', 'Nissan', 'Altima', 25);
insert into Car  values ( 'C1003', 'Nissan', 'Maxima', 21);
insert into Car  values ( 'C1004', 'Tesla', 'Roadster', 100);
insert into Car  values ( 'C1005', 'Porsche', '911', 7);
insert into Car  values ( 'C1005', 'Porsche', 'Taycan', 12);
insert into Car  values ( 'C1006', 'Porsche', 'Cayenne', 19);
insert into Car  values ( 'C1007', 'BMW', '230i', 25);
insert into Car  values ( 'C1008', 'BMW', 'M240i', 21);

drop table Car_Ownership ;
CREATE TABLE Car_Ownership (
  StuID INTEGER,
  CarID VARCHAR(5)
);
insert into Car_Ownership  values ( 1001, 'C1003'); 
insert into Car_Ownership  values ( 1005, 'C1009');
insert into Car_Ownership  values ( 1007, 'C1005');
insert into Car_Ownership  values ( 1009, 'C1006');
insert into Car_Ownership  values ( 1012, 'C1007');
insert into Car_Ownership  values ( 1023, 'C1002');
insert into Car_Ownership  values ( 1019, 'C1003');
insert into Car_Ownership  values ( 1014, 'C1007');
insert into Car_Ownership  values ( 1012, 'C1001');
insert into Car_Ownership  values ( 1012, 'C1004');
insert into Car_Ownership  values ( 1010, 'C1008');
insert into Car_Ownership  values ( 1011, 'C1001');
insert into Car_Ownership  values ( 1017, 'C1001');
insert into Car_Ownership  values ( 1017, 'C1002');
insert into Car_Ownership  values ( 1017, 'C1003');


drop table CovidDiagnosis;
create table CovidDiagnosis (
        StuID           INTEGER,
        TestDate        DATE,
        TestType        VARCHAR(10),
        TestResult      VARCHAR(10)
);

insert into CovidDiagnosis values ( 1001, '2020-09-20', 'Rapid', 'Negative');
insert into CovidDiagnosis values ( 1001, '2020-09-23', 'Rapid', 'Negative');
insert into CovidDiagnosis values ( 1001, '2020-09-25', 'Rapid', 'Positive');
insert into CovidDiagnosis values ( 1001, '2020-09-29', 'Rapid', 'Positive');
insert into CovidDiagnosis values ( 1003, '2020-06-20', 'Rapid', 'Negative');
insert into CovidDiagnosis values ( 1007, '2020-07-16', 'Rapid', 'Positive');
insert into CovidDiagnosis values ( 1017, '2020-08-14', 'Rapid', 'Positive');
insert into CovidDiagnosis values ( 1022, '2020-08-28', 'Rapid', 'Positive');
insert into CovidDiagnosis values ( 1022, '2020-08-31', 'Rapid', 'Positive');

drop table ConductViolation;
create table ConductViolation (
        StuID           INTEGER,
        Dormid          INTEGER,
        Reason          VARCHAR(20),
        Date            DATE 
);

drop table Lockouts;
create table Lockouts (
        StuID           INTEGER,
        Dormid          INTEGER,
        Date            DATE 
);

insert into ConductViolation values ( 1001, 100, 'ALCOHOL', '2020-09-20');
insert into ConductViolation values ( 1024, 160, 'NOISE', '2020-09-22');
insert into ConductViolation values ( 1029, 109, 'VANDALISM', '2020-09-28');
insert into ConductViolation values ( 1007, 160, 'ALCOHOL', '2020-09-28');
insert into ConductViolation values ( 1016, 140, 'PROHIBITED_ITEM', '2020-09-29');

insert into Lockouts values ( 1002, 100, '2020-09-20');
insert into Lockouts values ( 1005, 140, '2020-09-21');
insert into Lockouts values ( 1017, 160, '2020-09-21');
insert into Lockouts values ( 1021, 100, '2020-09-22');

drop table Worked_at;
create table Worked_at (
        StuID INTEGER,
        Company VARCHAR(20),
        Position VARCHAR(20),
        Start_Date DATE,
        End_Date DATE
);

drop table Studied_Abroad;
create table Studied_Abroad (
        StuID INTEGER,
        Location VARCHAR(20),
        Start_Date DATE,
        End_Date DATE
);



insert into Worked_at values (1001, "Starbucks", "Barista", "2018-05-20", "2018-08-10");
insert into Worked_at values (1003, "Microsoft", "Software Intern", "2019-05-01", "2019-07-20");
insert into Worked_at values (1007, "McDonald's", "Crew Member", "2015-10-20", "2017-04-20");
insert into Worked_at values (1010, "Apple", "HR Intern", "2019-04-10", "2019-08-10");
insert into Worked_at values (1011, "McDonald's", "Cash Register", "2015-11-20", "2015-11-30");


insert into Studied_Abroad values (1012, "Costa Rica", "2018-09-20", "2018-12-10");
insert into Studied_Abroad values (1014, "France", "2018-09-10", "2018-11-30");
insert into Studied_Abroad values (1015, "China", "2017-02-01", "2017-05-25");
insert into Studied_Abroad values (1015, "Italy", "2019-10-01", "2020-03-10");
insert into Studied_Abroad values (1020, "Brazil", "2019-05-20", "2019-08-10");


drop table Has_Pet;
create table Has_Pet (
       StuID            INTEGER,
       PetID            VARCHAR(5)
);

insert into Has_Pet values ( 1001, 'P1001' );
insert into Has_Pet values ( 1014, 'P1003' );
insert into Has_Pet values ( 1027, 'P1003' );
insert into Has_Pet values ( 1027, 'P1004' );
insert into Has_Pet values ( 1030, 'P1002' );
 
drop table Pet;
create table Pet (
       PetID            VARCHAR(5),
       PetName          VARCHAR(12),
       PetType          VARCHAR(12),
       PetAge           INTEGER,
       PetSex           VARCHAR(1)
);

insert into Pet values ( 'P1001', 'Tom', 'Cat', 4, 'M');
insert into Pet values ( 'P1002', 'Bruno', 'Dog', 2, 'F');
insert into Pet values ( 'P1003', 'Mike', 'Dog', 2, 'M');
insert into Pet values ( 'P1004', 'Snoopy', 'Parrot', 1, 'M');


drop table USCandidate;
create table USCandidate (
       CandidateId     INTEGER,
       CandidateName   VARCHAR(40),
       Party           VARCHAR(20)
);

drop table USCandidateFor;
create table USCandidateFor (
       CandidateId     INTEGER,
       Office          VARCHAR(20),
       District        VARCHAR(3),
       Year            INTEGER
);



drop table VotedForElectioninUS;
create table VotedForElectioninUS (
        StuID           INTEGER,
        CandidateID     INTEGER,
        Year            INTEGER
);


insert into USCandidate values (6666, 'Donald Trump',     'Republican');
insert into USCandidate values (6667, 'Joe Biden',        'Democrat');
insert into USCandidate values (6668, 'Mitch McConnell',  'Republican');
insert into USCandidate values (6669, 'Amy McGrath',      'Democrat');
insert into USCandidate values (6670, 'Susan Collins',    'Republican');
insert into USCandidate values (6671, 'Sara Gideon',      'Democrat');
insert into USCandidate values (6672, 'Lindsey Graham',    'Republican');
insert into USCandidate values (6673, 'Jamie Harrison',    'Democrat');
insert into USCandidate values (6674, 'John James',        'Republican');
insert into USCandidate values (6675, 'Gary Peters',       'Democrat');
insert into USCandidate values (6676, 'Kevin OConnor',     'Republican');
insert into USCandidate values (6677, 'Ed Markey',         'Democrat');
insert into USCandidate values (6678, 'Hillary Clinton',   'Democrat');
insert into USCandidate values (6679, 'Barak Obama',       'Democrat');
insert into USCandidate values (6680, 'Mitt Romney',       'Republican');

insert into USCandidateFor values (6666, 'President', 'USA', 2020);
insert into USCandidateFor values (6666, 'President', 'USA', 2016);
insert into USCandidateFor values (6667, 'President', 'USA', 2020);
insert into USCandidateFor values (6678, 'President', 'USA', 2016);
insert into USCandidateFor values (6668, 'Senator', 'KY', 2020);
insert into USCandidateFor values (6669, 'Senator', 'KY', 2020);
insert into USCandidateFor values (6670, 'Senator', 'ME', 2020);
insert into USCandidateFor values (6671, 'Senator', 'ME', 2020);
insert into USCandidateFor values (6672, 'Senator', 'SC', 2020);
insert into USCandidateFor values (6673, 'Senator', 'SC', 2020);
insert into USCandidateFor values (6674, 'Senator', 'MI', 2020);
insert into USCandidateFor values (6675, 'Senator', 'MI', 2020);
insert into USCandidateFor values (6676, 'Senator', 'MA', 2020);
insert into USCandidateFor values (6677, 'Senator', 'MA', 2020);



insert into VotedForElectioninUS values (1001, 6678, 2016);
insert into VotedForElectioninUS values (1001, 6667, 2020);
insert into VotedForElectioninUS values (1016, 6680, 2012);
insert into VotedForElectioninUS values (1016, 6666, 2016);
insert into VotedForElectioninUS values (1016, 6666, 2020);
insert into VotedForElectioninUS values (1023, 6679, 2012);
insert into VotedForElectioninUS values (1023, 6666, 2016);
insert into VotedForElectioninUS values (1023, 6667, 2020);
insert into VotedForElectioninUS values (1024, 6678, 2016);
insert into VotedForElectioninUS values (1024, 6666, 2020);


drop table Slept_In_Class;
create table Slept_In_Class (
		StuID    		INTEGER,
		CID 			VARCHAR(7),
		DateOfSleep 	VARCHAR(12)
);


insert into Slept_In_Class values (1001, '600.109', "2021-09-04");
insert into Slept_In_Class values (1007, '600.303', "2020-08-20");
insert into Slept_In_Class values (1017, '600.227', "2020-08-04");
insert into Slept_In_Class values (1022, '600.103', "2020-10-25");
insert into Slept_In_Class values (1002, '600.271', "2020-08-10");
insert into Slept_In_Class values (1010, '600.271', "2021-11-12");
insert into Slept_In_Class values (1011, '600.315', "2021-11-09");


drop table Close_Contact;
create table Close_Contact (
		StuID1 			INTEGER,
		StuID2			INTEGER,
		DateOfContact	VARCHAR(12),
		MinDuration		INTEGER
);

insert into Close_Contact values (1001, 1002, "2021-08-30", 40);
insert into Close_Contact values (1005, 1010, "2020-07-30", 20);
insert into Close_Contact values (1003, 1011, "2021-01-10", 25);
insert into Close_Contact values (1008, 1020, "2021-02-11", 120);
insert into Close_Contact values (1020, 1001, "2021-02-12", 30);
insert into Close_Contact values (1021, 1014, "2021-09-15", 35);
insert into Close_Contact values (1002, 1010, "2021-08-28", 36);	



drop table Researches;
create table Researches (
       stuid          INTEGER,
       research_area    VARCHAR(40),
       FacMentorID      INTEGER
);

insert into Researches values ( 1001, 'Theoretical Computer Science', 7792);
insert into Researches values ( 1034, 'Neuropsychology', 8989);
insert into Researches values ( 1020, 'Signal Processing', 9210);
insert into Researches values ( 1001, 'Theoretical Computer Science', 9210);




