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 ( 601, 'EN', 'Computer Science', '224', 'NEB', 8577); insert into Member_of values (7792, 601, '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, 601, 'Primary'); insert into Member_of values (7712, 601, 'Primary'); insert into Member_of values (1121, 601, 'Primary'); insert into Member_of values (9172, 601, 'Primary'); insert into Member_of values (8423, 601, 'Primary'); insert into Member_of values (1148, 601, 'Primary'); insert into Member_of values (8741, 601, 'Primary'); insert into Member_of values (3457, 601, 'Primary'); insert into Member_of values (7723, 601, 'Primary'); insert into Member_of values (8721, 601, 'Primary'); insert into Member_of values (2192, 601, 'Primary'); insert into Member_of values (8114, 601, 'Primary'); insert into Member_of values (6112, 601, 'Primary'); insert into Member_of values (9826, 601, 'Primary'); insert into Member_of values (1193, 601, 'Primary'); insert into Member_of values (1082, 601, 'Primary'); insert into Member_of values (4230, 601, 'Primary'); insert into Member_of values (8989, 601, 'Secondary'); insert into Member_of values (7271, 601, '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 ( '601.101', 'COMPUTER LITERACY', 3, 6112, 'MTW', '3',601); insert into Course values ( '601.103', 'INTRODUCTION TO COMPUTER SCIENCE', 1, 4230, 'Th', '4',601); insert into Course values ( '601.107', 'INTRO TO PROGRAMMING IN JAVA', 3, 1193, 'MTW', '3',601); insert into Course values ( '601.109', 'INTRO TO PROGRAMMING IN C/C++', 3, 4230, 'MTW', '12',601); insert into Course values ( '601.113', 'EXPLORING THE INTERNET', 3, 6112, 'MTW', '4',601); insert into Course values ( '601.121', 'JAVA PROGRAMMING', 3, 6112, 'ThF', '10:30-12',601); insert into Course values ( '601.211', 'UNIX SYSTEMS PROGRAMMING', 3, 6112, 'ThF', '1-2:15',601); insert into Course values ( '601.227', 'DATA STRUCTURES in JAVA', 3, 1121, 'MTW', '9',601); insert into Course values ( '601.232', 'MULTIMEDIA COMPUTING', 3, 9826, 'MW', '1-2:30',601); insert into Course values ( '601.271', 'COMPUTATIONAL MODELS', 3, 9172, 'MTW', '1',601); insert into Course values ( '601.303', 'SUPERCOMPUTING', 1, 9826, 'W', '4-6:20',601); insert into Course values ( '601.315', 'DATABASE SYSTEMS', 3, 2192, 'ThF', '2:30-4',601); insert into Course values ( '601.333', 'COMPUTER SYSTEM FUNDAMENTALS', 3, 1148, 'MTW', '8',601); insert into Course values ( '601.337', 'DISTRIBUTED SYSTEMS', 3, 8918, 'M', '3',601); insert into Course values ( '601.363', 'INTRODUCTION TO ALGORITHMS', 3, 7712, 'MTW', '9',601); insert into Course values ( '601.389', 'SPORTS AND COMPUTING APPLICATIONS', 3, 9956, 'TTh', '12-1:15', 601); insert into Course values ( '601.415', 'DATABASE SYSTEMS', 3, 2192, 'ThF', '2:30-4',601); insert into Course values ( '601.433', 'COMPUTER SYSTEMS', 3, 1148, 'MTW', '8',601); insert into Course values ( '601.437', 'DISTRIBUTED SYSTEMS', 3, 8918, 'M', '3',601); insert into Course values ( '601.445', 'QUANTITATIVE MEDICAL COMPUTING', 3, 7723, 'ThF', '1-2:15',601); insert into Course values ( '601.461', 'COMPUTER VISION', 3, 8114, 'MTW', '1',601); insert into Course values ( '601.463', 'ALGORITHMS I', 3, 7712, 'MTW', '9',601); insert into Course values ( '601.465', 'INTRO TO NATURAL LANGUAGE PROCESSING', 3, 7792, 'MTW', '2',601); insert into Course values ( '601.509', 'COMPUTER SCIENCE INTERNSHIP', 3, 1121, 'M', '1',601); insert into Course values ( '601.601', 'COMPUTER SCIENCE SEMINAR', 1, 6191, 'ThF', '10:30-12',601); insert into Course values ( '601.657', 'HIGH PERFORMANCE GRAPHICS AND MODELING', 3, 8423, 'M', '4-5:30',601); insert into Course values ( '601.787', 'SEMINAR ON COMPUTATIONAL GEOMETRY', 3, 1121, 'Th', '2',601); 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.601 ) ; 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', 601, 1121,'BAL'); insert into Student values ( 1002, 'Kim', 'Tracy', 19, 'F', 601, 7712,'HKG'); insert into Student values ( 1003, 'Jones', 'Shiela', 21, 'F', 601, 7792,'WAS'); insert into Student values ( 1004, 'Kumar', 'Dinesh', 20, 'M', 601, 8423,'CHI'); insert into Student values ( 1005, 'Gompers', 'Paul', 26, 'M', 601, 1121,'YYZ'); insert into Student values ( 1006, 'Schultz', 'Andy', 18, 'M', 601, 1148,'BAL'); insert into Student values ( 1007, 'Apap', 'Lisa', 18, 'F', 601, 8918,'PIT'); insert into Student values ( 1008, 'Nelson', 'Jandy', 20, 'F', 601, 9172,'BAL'); insert into Student values ( 1009, 'Tai', 'Eric', 19, 'M', 601, 2192,'YYZ'); insert into Student values ( 1010, 'Lee', 'Derek', 17, 'M', 601, 2192,'HOU'); insert into Student values ( 1011, 'Adams', 'David', 22, 'M', 601, 1148,'PHL'); insert into Student values ( 1012, 'Davis', 'Steven', 20, 'M', 601, 7723,'PIT'); insert into Student values ( 1014, 'Norris', 'Charles', 18, 'M', 601, 8741, 'DAL'); insert into Student values ( 1015, 'Lee', 'Susan', 16, 'F', 601, 8721,'HKG'); insert into Student values ( 1016, 'Schwartz', 'Mark', 17, 'M', 601, 2192,'DET'); insert into Student values ( 1017, 'Wilson', 'Bruce', 27, 'M', 601, 1148,'LON'); insert into Student values ( 1018, 'Leighton', 'Michael', 20, 'M', 601, 1121, 'PIT'); insert into Student values ( 1019, 'Pang', 'Arthur', 18, 'M', 601, 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, '601.303', 'B'); insert into Enrolled_in values ( 1001, '601.315', 'B+'); insert into Enrolled_in values ( 1001, '601.337', 'A'); insert into Enrolled_in values ( 1001, '601.461', 'B-'); insert into Enrolled_in values ( 1001, '601.465', 'B'); insert into Enrolled_in values ( 1002, '520.213', 'B+'); insert into Enrolled_in values ( 1002, '601.211', 'C'); insert into Enrolled_in values ( 1002, '601.303', 'C+'); insert into Enrolled_in values ( 1002, '601.337', 'A'); insert into Enrolled_in values ( 1002, '601.463', 'B'); insert into Enrolled_in values ( 1002, '601.465', 'B+'); insert into Enrolled_in values ( 1003, '601.333', 'B'); insert into Enrolled_in values ( 1003, '601.337', 'B'); insert into Enrolled_in values ( 1003, '601.415', 'B'); insert into Enrolled_in values ( 1003, '601.461', 'B+'); insert into Enrolled_in values ( 1003, '601.465', 'B'); insert into Enrolled_in values ( 1004, '601.303', 'C-'); insert into Enrolled_in values ( 1004, '601.415', 'C-'); insert into Enrolled_in values ( 1004, '601.437', 'C-'); insert into Enrolled_in values ( 1004, '601.445', 'A-'); insert into Enrolled_in values ( 1004, '601.461', 'C'); insert into Enrolled_in values ( 1004, '601.463', 'A+'); insert into Enrolled_in values ( 1004, '601.465', 'A'); insert into Enrolled_in values ( 1005, '601.103', 'A'); insert into Enrolled_in values ( 1005, '601.107', 'C+'); insert into Enrolled_in values ( 1005, '601.113', 'C'); insert into Enrolled_in values ( 1005, '601.227', 'A'); insert into Enrolled_in values ( 1005, '601.303', 'B'); insert into Enrolled_in values ( 1006, '550.420', 'B'); insert into Enrolled_in values ( 1006, '601.107', 'B+'); insert into Enrolled_in values ( 1006, '601.227', 'B-'); insert into Enrolled_in values ( 1006, '601.232', 'C-'); insert into Enrolled_in values ( 1006, '601.303', 'A-'); insert into Enrolled_in values ( 1006, '601.315', 'A'); insert into Enrolled_in values ( 1007, '550.420', 'A'); insert into Enrolled_in values ( 1007, '601.113', 'A-'); insert into Enrolled_in values ( 1007, '601.227', 'C+'); insert into Enrolled_in values ( 1007, '601.315', 'A'); insert into Enrolled_in values ( 1007, '601.333', 'A-'); insert into Enrolled_in values ( 1007, '601.337', 'C'); insert into Enrolled_in values ( 1008, '601.415', 'A+'); insert into Enrolled_in values ( 1008, '601.463', 'B'); insert into Enrolled_in values ( 1008, '601.465', 'B'); insert into Enrolled_in values ( 1008, '601.657', 'B'); insert into Enrolled_in values ( 1008, '601.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, '601.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, '601.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, '601.107', 'A'); insert into Enrolled_in values ( 1012, '601.315', 'B'); insert into Enrolled_in values ( 1014, '601.107', 'A'); insert into Enrolled_in values ( 1014, '601.227', 'A'); insert into Enrolled_in values ( 1014, '601.232', 'A'); insert into Enrolled_in values ( 1014, '601.315', 'A+'); insert into Enrolled_in values ( 1014, '601.445', 'B'); insert into Enrolled_in values ( 1014, '601.461', 'B'); insert into Enrolled_in values ( 1014, '601.463', 'B'); insert into Enrolled_in values ( 1015, '550.420', 'A'); insert into Enrolled_in values ( 1015, '601.227', 'A+'); insert into Enrolled_in values ( 1015, '601.303', 'A'); insert into Enrolled_in values ( 1015, '601.315', 'C-'); insert into Enrolled_in values ( 1015, '601.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, '601.107', 'B+'); insert into Enrolled_in values ( 1016, '601.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, '601.109', 'A-'); insert into Enrolled_in values ( 1017, '601.461', 'A'); insert into Enrolled_in values ( 1017, '601.465', 'C'); insert into Enrolled_in values ( 1018, '520.213', 'A-'); insert into Enrolled_in values ( 1018, '601.211', 'A'); insert into Enrolled_in values ( 1018, '601.303', 'A'); insert into Enrolled_in values ( 1018, '601.337', 'C-'); insert into Enrolled_in values ( 1018, '601.463', 'B'); insert into Enrolled_in values ( 1018, '601.465', 'B'); insert into Enrolled_in values ( 1019, '601.103', 'B'); insert into Enrolled_in values ( 1019, '601.107', 'B'); insert into Enrolled_in values ( 1019, '601.113', 'D+'); insert into Enrolled_in values ( 1019, '601.227', 'A'); insert into Enrolled_in values ( 1019, '601.303', 'A'); insert into Enrolled_in values ( 1020, '601.333', 'A'); insert into Enrolled_in values ( 1020, '601.337', 'A'); insert into Enrolled_in values ( 1020, '601.415', 'A'); insert into Enrolled_in values ( 1020, '601.461', 'A'); insert into Enrolled_in values ( 1020, '601.465', 'A'); insert into Enrolled_in values ( 1021, '601.303', 'B-'); insert into Enrolled_in values ( 1021, '601.303', 'B'); insert into Enrolled_in values ( 1021, '601.415', 'B'); insert into Enrolled_in values ( 1021, '601.437', 'B'); insert into Enrolled_in values ( 1021, '601.437', 'B'); insert into Enrolled_in values ( 1021, '601.445', 'B-'); insert into Enrolled_in values ( 1021, '601.445', 'C'); insert into Enrolled_in values ( 1021, '601.463', 'A'); insert into Enrolled_in values ( 1021, '601.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, '601.107', 'A'); insert into Enrolled_in values ( 1022, '601.227', 'A'); insert into Enrolled_in values ( 1022, '601.227', 'A'); insert into Enrolled_in values ( 1022, '601.232', 'B'); insert into Enrolled_in values ( 1022, '601.303', 'B'); insert into Enrolled_in values ( 1022, '601.315', 'D'); insert into Enrolled_in values ( 1022, '601.461', 'A'); insert into Enrolled_in values ( 1023, '601.113', 'A-'); insert into Enrolled_in values ( 1023, '601.315', 'B'); insert into Enrolled_in values ( 1023, '601.333', 'B'); insert into Enrolled_in values ( 1023, '601.337', 'B+'); insert into Enrolled_in values ( 1023, '601.463', 'A'); insert into Enrolled_in values ( 1023, '601.465', 'A'); insert into Enrolled_in values ( 1023, '601.657', 'B'); insert into Enrolled_in values ( 1023, '601.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, '601.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, '601.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, '601.303', 'A'); insert into Enrolled_in values ( 1026, '601.437', 'A'); insert into Enrolled_in values ( 1026, '601.445', 'A'); insert into Enrolled_in values ( 1026, '601.463', 'B-'); insert into Enrolled_in values ( 1027, '601.107', 'B'); insert into Enrolled_in values ( 1027, '601.227', 'B'); insert into Enrolled_in values ( 1027, '601.232', 'B'); insert into Enrolled_in values ( 1027, '601.303', 'B'); insert into Enrolled_in values ( 1027, '601.315', 'B-'); insert into Enrolled_in values ( 1027, '601.461', 'B-'); insert into Enrolled_in values ( 1027, '601.463', 'B'); insert into Enrolled_in values ( 1028, '550.420', 'B+'); insert into Enrolled_in values ( 1028, '601.227', 'A'); insert into Enrolled_in values ( 1028, '601.315', 'A+'); insert into Enrolled_in values ( 1028, '601.333', 'A'); insert into Enrolled_in values ( 1028, '601.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, '601.113', 'B-'); insert into Enrolled_in values ( 1029, '601.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, '601.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, '601.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, '601.232', 'A-'); insert into Enrolled_in values ( 1032, '601.113', 'A+'); insert into Enrolled_in values ( 1032, '601.303', 'A'); insert into Enrolled_in values ( 1032, '601.315', 'A'); insert into Enrolled_in values ( 1033, '601.113', 'A'); insert into Enrolled_in values ( 1033, '601.227', 'A'); insert into Enrolled_in values ( 1033, '601.315', 'A'); insert into Enrolled_in values ( 1033, '601.333', 'A'); insert into Enrolled_in values ( 1033, '601.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, '601.107', 'B+'); insert into Enrolled_in values ( 1034, '601.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, '601.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"); INSERT INTO SportsInfo VALUES (1002, "Athletics", 6, 5, "N"); INSERT INTO SportsInfo VALUES (1003, "Athletics", 8, 39, "Y"); INSERT INTO SportsInfo VALUES (1007, "Athletics", 10, 50, "N"); INSERT INTO SportsInfo VALUES (1008, "Athletics", 70, 45, "Y"); INSERT INTO SportsInfo VALUES (1024, "Athletics", 28, 58, "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, '601.415', 'T', '6:30-8:30'); insert into Course_CA values (1014, '601.415', 'Th', '2:30-4:30'); insert into Course_CA values (1003, '601.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, '601.109', "2021-09-04"); insert into Slept_In_Class values (1007, '601.303', "2020-08-20"); insert into Slept_In_Class values (1017, '601.227', "2020-08-04"); insert into Slept_In_Class values (1022, '601.103', "2020-10-25"); insert into Slept_In_Class values (1002, '601.271', "2020-08-10"); insert into Slept_In_Class values (1010, '601.271', "2021-11-12"); insert into Slept_In_Class values (1011, '601.315', "2021-11-09"); insert into Slept_In_Class values (1019, '601.445', "2021-11-03"); insert into Slept_In_Class values (1019, '601.445', "2021-11-19"); insert into Slept_In_Class values (1019, '601.445', "2021-11-29"); 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); drop table Company; create table Company ( CompanyID INTEGER, Name VARCHAR(40), Industry VARCHAR(20) ); drop table WorkExp; create table WorkExp ( StuID INTEGER, CompanyID INTEGER, Number_Months_Worked INTEGER, Title VARCHAR(40) ); insert into Company values ( 1, 'Goldman Sachs', 'Finance'); insert into Company values ( 2, 'Meta', 'Software'); insert into Company values ( 3, 'Qualcomm', 'Software'); insert into Company values ( 4, 'JP Morgan Chase', 'Finance'); insert into Company values ( 5, 'Mercedes-Benz', 'Automobile'); insert into Company values ( 6, 'DE Shaw', 'Finance'); insert into Company values ( 7, 'Adobe', 'Software'); insert into Company values ( 8, 'Texas Instruments', 'Electronics'); insert into Company values ( 9, 'Dell', 'Electronics'); insert into Company values ( 10, 'Barclays', 'Finance'); insert into Company values ( 11, 'Bloomberg', 'Analytics'); insert into Company values ( 12, 'Capgemini', 'Analytics'); insert into Company values ( 13, 'Google', 'Software'); insert into Company values ( 14, 'Netflix', 'Software'); insert into Company values ( 15, 'NASA', 'Government'); insert into Company values ( 16, 'FBI', 'Government'); insert into Company values ( 17, 'Apple', 'Electronics'); insert into Company values ( 18, 'Pinterest', 'Software'); insert into Company values ( 19, 'Koenigsegg', 'Automobile'); insert into Company values ( 20, 'Lotus', 'Automobile'); insert into Company values ( 21, 'PricewaterhouseCoopers', 'Accounting'); insert into Company values ( 22, 'Deloitte', 'Accounting'); insert into Company values ( 23, 'Ernst & Young LLP', 'Accounting'); insert into Company values ( 24, 'KPMG', 'Accounting'); insert into Company values ( 25, 'Grant Thornton', 'Accounting'); insert into WorkExp values ( 1001, 4, 18, 'Consultant'); insert into WorkExp values ( 1002, 4, 18, 'Software Engineer'); insert into WorkExp values ( 1008, 1, 7, 'Software Engineer'); insert into WorkExp values ( 1010, 10, 9, 'Software Engineer'); insert into WorkExp values ( 1008, 12, 3, 'Consultant'); insert into WorkExp values ( 1023, 7, 8, 'Consultant'); insert into WorkExp values ( 1034, 11, 11, 'Consultant'); insert into WorkExp values ( 1012, 6, 10, 'Consultant'); insert into WorkExp values ( 1007, 9, 25, 'Consultant'); insert into WorkExp values ( 1010, 14, 36, 'Software Development Engineer-1'); insert into WorkExp values ( 1014, 13, 1, 'Software Development Engineer-1'); insert into WorkExp values ( 1024, 17, 2, 'Software Development Engineer-1'); insert into WorkExp values ( 1002, 2, 4, 'Software Development Engineer-2'); insert into WorkExp values ( 1013, 8, 7, 'Software Development Engineer-2'); insert into WorkExp values ( 1006, 15, 12, 'Software Development Engineer-2'); insert into WorkExp values ( 1024, 18, 14, 'Software Development Engineer-2'); insert into WorkExp values ( 1018, 20, 2, 'Analyst'); insert into WorkExp values ( 1003, 18, 20, 'Analyst'); insert into WorkExp values ( 1025, 16, 8, 'Analyst'); insert into WorkExp values ( 1019, 4, 10, 'Analyst'); insert into WorkExp values ( 1004, 6, 11, 'Business Development'); insert into WorkExp values ( 1017, 18, 26, 'Business Development'); insert into WorkExp values ( 1015, 16, 4, 'Business Development'); insert into WorkExp values ( 1012, 5, 4, 'Business Development'); insert into WorkExp values ( 1033, 3, 5, 'Socket on chip engineer'); insert into WorkExp values ( 1005, 17, 10, 'Socket on chip engineer'); insert into WorkExp values ( 1011, 19, 3, 'Socket on chip engineer'); insert into WorkExp values ( 1032, 20, 8, 'Socket on chip engineer'); insert into WorkExp values ( 1024, 2, 17, 'Machine Learning Engineer'); insert into WorkExp values ( 1009, 10, 22, 'Frontend Engineer'); insert into WorkExp values ( 1016, 12, 14, 'Systems Engineer'); insert into WorkExp values ( 1024, 11, 10, 'DevOps Engineer'); insert into WorkExp values ( 1029, 23, 8, 'Accountant'); insert into WorkExp values ( 1032, 22, 17, 'Accountant'); insert into WorkExp values ( 1017, 21, 22, 'Accountant'); insert into WorkExp values ( 1012, 25, 14, 'Accountant'); insert into WorkExp values ( 1001, 24, 10, 'Accountant'); DROP TABLE CoachedBy; CREATE TABLE CoachedBy ( stuID INTEGER, facID INTEGER, sport VARCHAR(30) ); -- First insert the coaches into the Faculty table INSERT INTO Faculty VALUES (9933, 'Lucia', 'Benjamin', 'HeadCoach', 'M', 7495, '154', 'Clark'); INSERT INTO Faculty VALUES (9940, 'Wasylyna', 'Leanne', 'HeadCoach', 'F', 3160, '189', 'Clark'); INSERT INTO Faculty VALUES (9945, 'Terpsichore', 'Steve', 'AsstCoach', 'M', 8854, '233', 'Clark'); INSERT INTO Faculty VALUES (9956, 'Maria', 'Theresa', 'AsstCoach', 'F', 6943, '276', 'Hodson'); INSERT INTO Faculty VALUES (9962, 'Shib', 'Frederick', 'AsstCoach', 'M', 1103, '310', 'Hodson'); -- Next insert entries into the CoachedBy table INSERT INTO CoachedBy VALUES (1005, 9956, 'Tennis'); INSERT INTO CoachedBy VALUES (1020, 9945, 'Soccer'); INSERT INTO CoachedBy VALUES (1005, 9962, 'Basketball'); INSERT INTO CoachedBy VALUES (1031, 9940, 'Swimming'); INSERT INTO CoachedBy VALUES (1024, 9940, 'Swimming'); DROP TABLE Building; CREATE TABLE Building ( name VARCHAR(13), numFloors INTEGER, numRooms INTEGER, location VARCHAR(50) ); INSERT INTO Building VALUES ('Krieger', 4, 67,'Keyser'); INSERT INTO Building VALUES ('Barton', 3, 55,'Wyman'); INSERT INTO Building VALUES ('Malone', 3, 72,'Decker'); INSERT INTO Building VALUES ('Hodson', 4, 44,'Decker'); drop table JobsAppliedFor; create table JobsAppliedFor ( stuid INTEGER, company VARCHAR(40), position VARCHAR(40), application_date DATE ); drop table OffersAccepted; create table OffersAccepted ( stuid INTEGER, company VARCHAR(40), position VARCHAR(40), compensation INTEGER ); insert into JobsAppliedFor values (1001, 'Tesla', 'Researcher', '2022-01-01'); insert into JobsAppliedFor values (1002, 'Tesla', 'Researcher', '2022-01-01'); insert into JobsAppliedFor values (1008, 'Google', 'SDE', '2022-03-15'); insert into JobsAppliedFor values (1011, 'Facebook', 'Researcher', '2022-01-30'); insert into JobsAppliedFor values (1015, 'Google', 'Researcher', '2021-08-23'); insert into JobsAppliedFor values (1022, 'Apple', 'SDE', '2022-02-11'); insert into JobsAppliedFor values (1022, 'Morgan', 'SDE', '2022-02-12'); insert into JobsAppliedFor values (1033, 'Facebook', 'SDE', '2022-04-01'); insert into OffersAccepted values (1001, 'Tesla', 'Researcher', 250000); insert into OffersAccepted values (1008, 'Google', 'SDE', 200000); insert into OffersAccepted values (1022, 'Apple', 'SDE', 300000); insert into OffersAccepted values (1011, 'Facebook', 'Researcher', 350000); drop table likesArtist; create table likesArtist ( stuid INTEGER, artID INTEGER, rating INTEGER ); drop table MusicalArtist; create table MusicalArtist ( artID INTEGER, artistName VARCHAR(40), birthYear INTEGER, MusicalGenre VARCHAR(20), monthlyListeners INTEGER ); insert into likesArtist values ( 1001, 1, 9); insert into likesArtist values ( 1034, 2, 10); insert into likesArtist values ( 1020, 3, 4); insert into likesArtist values ( 1001, 4, 6); insert into MusicalArtist values ( 1, 'Eminem', 1972, 'Rap', 52000000); insert into MusicalArtist values ( 2, 'Taylor Swift', 1989, 'Pop', 57000000); insert into MusicalArtist values ( 3, 'Dua Lipa', 1995, 'Pop', 63000000); insert into MusicalArtist values ( 4, 'Dr. Dre', 1965, 'Rap', 18000000); drop TABLE FinancialAid; CREATE TABLE FinancialAid ( StuID INTEGER, AidAmount FLOAT ); INSERT INTO FinancialAid VALUES (1001, 5000.00); INSERT INTO FinancialAid VALUES (1002, 6000.00); INSERT INTO FinancialAid VALUES (1003, 7000.00); INSERT INTO FinancialAid VALUES (1004, 8000.00); INSERT INTO FinancialAid VALUES (1005, 9000.00); INSERT INTO FinancialAid VALUES (1006, 10000.00); INSERT INTO FinancialAid VALUES (1007, 11000.00); INSERT INTO FinancialAid VALUES (1008, 12000.00); INSERT INTO FinancialAid VALUES (1009, 13000.00); INSERT INTO FinancialAid VALUES (1010, 14000.00); drop TABLE Alumni; CREATE TABLE Alumni ( AlumID INTEGER, LName VARCHAR(12), Fname VARCHAR(12), GradYear INTEGER, Major INTEGER, city_code VARCHAR(3) ); INSERT INTO Alumni VALUES (1, 'Smith', 'John', 2000, 101, 'NYC'); INSERT INTO Alumni VALUES (2, 'Johnson', 'Emily', 2001, 102, 'LAX'); INSERT INTO Alumni VALUES (3, 'Williams', 'Robert', 2002, 103, 'ORD'); INSERT INTO Alumni VALUES (4, 'Brown', 'Michael', 2003, 104, 'DFW'); INSERT INTO Alumni VALUES (5, 'Jones', 'Sarah', 2004, 105, 'DEN'); INSERT INTO Alumni VALUES (6, 'Miller', 'David', 2005, 106, 'JFK'); INSERT INTO Alumni VALUES (7, 'Davis', 'Daniel', 2006, 107, 'SFO'); INSERT INTO Alumni VALUES (8, 'Garcia', 'Nancy', 2007, 108, 'SEA'); INSERT INTO Alumni VALUES (9, 'Rodriguez', 'Paul', 2008, 109, 'LAS'); INSERT INTO Alumni VALUES (10, 'Wilson', 'Linda', 2009, 110, 'MIA'); drop table NBA_Championship_Winners; create table NBA_Championship_Winners ( teamName VARCHAR(40), winYear INTEGER, MVP VARCHAR(20) ); drop table Favorite_NBA_Team; create table Favorite_NBA_Team ( stuID INTEGER, teamName VARCHAR(40) ); insert into NBA_Championship_Winners values ( 'Denver Nuggets', 2023, 'Nikola Jokic' ); insert into NBA_Championship_Winners values ( 'Golden State Warriors', 2022, 'Stephen Curry' ); insert into NBA_Championship_Winners values ( 'Los Angeles Lakers', 2020, 'LeBron James' ); insert into Favorite_NBA_Team values ( 1001, 'Golden State Warriors' ); insert into Favorite_NBA_Team values ( 1002, 'Los Angeles Lakers' ); DROP TABLE Course_Prerequisite; CREATE TABLE Course_Prerequisite ( CourseID VARCHAR(7), HasPrerequisite VARCHAR(7) ); INSERT INTO Course_Prerequisite VALUES ('601.227', '601.121'); DROP TABLE AP_Exam_Equivalent; CREATE TABLE AP_Exam_Equivalent ( CourseID VARCHAR(7), AP_Exam VARCHAR(7), Minimum_Grade INTEGER ); DROP TABLE Volunteer_Work; CREATE TABLE Volunteer_Work ( volunteer_id INT, StuID INT, organization_name VARCHAR(255), start_date DATE, end_date DATE, role VARCHAR(255), hours_worked INT ); INSERT INTO Volunteer_Work VALUES (1, 1001, 'University Baptist Church', '2023-01-01', '2023-08-31', 'Volunteer', 100); INSERT INTO Volunteer_Work VALUES (2, 1002, 'Animal Shelter', '2023-06-01', '2023-09-10', 'Volunteer', 120); INSERT INTO Volunteer_Work VALUES (3, 1003, 'Community Food Bank', '2023-01-15', '2023-07-20', 'Coordinator', 150); INSERT INTO Volunteer_Work VALUES (4, 1004, 'Local Library', '2023-03-01', '2023-09-30', 'Assistant', 90); INSERT INTO Volunteer_Work VALUES (5, 1005, 'Senior Center', '2023-04-01', '2023-08-15', 'Volunteer', 80); INSERT INTO Volunteer_Work VALUES (6, 1006, 'Children’s Hospital', '2023-02-01', '2023-08-31', 'Care Helper', 100); INSERT INTO Volunteer_Work VALUES (7, 1002, 'Children’s Hospital', '2023-02-01', '2023-08-31', 'Care Helper', 100); DROP TABLE Student_Absence; CREATE TABLE Student_Absence ( absence_id INT, StuID INT, CID VARCHAR(7), absence_date DATE ); INSERT INTO Student_Absence VALUES (1, 1001, '601.101', '2023-10-01'); INSERT INTO Student_Absence VALUES (2, 1002, '601.101', '2023-10-02'); INSERT INTO Student_Absence VALUES (3, 1002, '601.103', '2023-10-02'); INSERT INTO Student_Absence VALUES (4, 1003, '601.107', '2023-10-03'); INSERT INTO Student_Absence VALUES (5, 1004, '601.109', '2023-10-04'); INSERT INTO Student_Absence VALUES (6, 1005, '601.113', '2023-10-05'); INSERT INTO Student_Absence VALUES (7, 1006, '601.121', '2023-10-06'); INSERT INTO Student_Absence VALUES (8, 1007, '601.211', '2023-10-07'); INSERT INTO Student_Absence VALUES (9, 1008, '601.227', '2023-10-08'); INSERT INTO Student_Absence VALUES (10, 1009, '601.232', '2023-10-09'); INSERT INTO Student_Absence VALUES (11, 1010, '601.271', '2023-10-10'); INSERT INTO Student_Absence VALUES (12, 1011, '601.303', '2023-10-11'); INSERT INTO Student_Absence VALUES (13, 1012, '601.315', '2023-10-12'); INSERT INTO Student_Absence VALUES (14, 1013, '601.333', '2023-10-13'); INSERT INTO Student_Absence VALUES (15, 1014, '601.337', '2023-10-14'); INSERT INTO Student_Absence VALUES (16, 1015, '601.363', '2023-10-15'); INSERT INTO Student_Absence VALUES (17, 1016, '601.389', '2023-10-16'); INSERT INTO Student_Absence VALUES (18, 1017, '601.415', '2023-10-17'); INSERT INTO Student_Absence VALUES (19, 1018, '601.437', '2023-10-18'); DROP TABLE Campus_Safety_Incidents; CREATE TABLE Campus_Safety_Incidents ( stuId INT, time_of_event DATETIME, place_of_event VARCHAR(255), severity VARCHAR(50) ); INSERT INTO Campus_Safety_Incidents VALUES (1001, '2023-09-15 09:30:00', 'Library', 'Moderate'); INSERT INTO Campus_Safety_Incidents VALUES (1005, '2023-08-10 14:45:00', 'Dormitory', 'High'); INSERT INTO Campus_Safety_Incidents VALUES (1035, '2023-03-20 17:15:00', 'Cafeteria', 'Low'); INSERT INTO Campus_Safety_Incidents VALUES (1004, '2023-04-05 11:20:00', 'Parking Lot', 'Medium'); INSERT INTO Campus_Safety_Incidents VALUES (1005, '2023-01-15 09:30:00', 'Library', 'Moderate'); INSERT INTO Campus_Safety_Incidents VALUES (1009, '2023-07-10 14:45:00', 'Dormitory', 'High'); INSERT INTO Campus_Safety_Incidents VALUES (1006, '2023-08-20 17:15:00', 'Cafeteria', 'Low'); INSERT INTO Campus_Safety_Incidents VALUES (1008, '2023-04-05 11:20:00', 'Parking Lot', 'Medium'); INSERT INTO Campus_Safety_Incidents VALUES (1016, '2023-05-12 08:00:00', 'Classroom Building', 'High'); DROP TABLE Office_Hours; CREATE TABLE Office_Hours ( office_hour_id INT, faculty_id INT, day_of_week VARCHAR(20), start_time TIME, end_time TIME, location VARCHAR(255), availability BOOLEAN); INSERT INTO Office_Hours VALUES (1, 2192, 'Monday', '09:00:00', '11:00:00', 'Malone 123', TRUE); INSERT INTO Office_Hours VALUES (2, 7134, 'Tuesday', '10:00:00', '12:00:00', 'Gilman 104', TRUE); INSERT INTO Office_Hours VALUES (3, 7134, 'Wednesday', '13:00:00', '15:00:00', 'Hackerman 431', TRUE); INSERT INTO Office_Hours VALUES (4, 1172, 'Thursday', '14:00:00', '16:00:00', 'Malone 1', TRUE); INSERT INTO Office_Hours VALUES (5, 1177, 'Friday', '11:30:00', '13:30:00', 'Ames 433', TRUE); INSERT INTO Office_Hours VALUES (6, 8723, 'Monday', '15:00:00', '17:00:00', 'Ames 123', TRUE); INSERT INTO Office_Hours VALUES (7, 1172, 'Tuesday', '08:30:00', '10:30:00', 'Gilman 311', TRUE); INSERT INTO Office_Hours VALUES (8, 7134, 'Wednesday', '12:30:00', '14:30:00', 'Levering 321', TRUE); INSERT INTO Office_Hours VALUES (9, 2192, 'Thursday', '09:45:00', '11:45:00', 'REC 111', TRUE); INSERT INTO Office_Hours VALUES (10, 8723, 'Friday', '14:15:00', '16:15:00', 'Maryland 321', TRUE); INSERT INTO Office_Hours VALUES (11, 8723, 'Monday', '09:00:00', '11:00:00', 'Gilam 222', TRUE); INSERT INTO Office_Hours VALUES (12, 7134, 'Tuesday', '10:00:00', '12:00:00', 'Malone 321', TRUE); INSERT INTO Office_Hours VALUES (13, 7134, 'Wednesday', '13:00:00', '15:00:00', 'Ames 111', TRUE); INSERT INTO Office_Hours VALUES (14, 7134, 'Thursday', '14:00:00', '16:00:00', 'REC 431a', TRUE); INSERT INTO Office_Hours VALUES (15, 2192, 'Friday', '11:30:00', '13:30:00', 'REC 433b', TRUE); INSERT INTO Campus_Safety_Incidents VALUES (1010, '2023-04-05 11:20:00', 'Parking Lot', 'Medium'); INSERT INTO Campus_Safety_Incidents VALUES (1015, '2023-01-15 09:30:00', 'Library', 'Moderate'); INSERT INTO Campus_Safety_Incidents VALUES (1012, '2023-07-10 14:45:00', 'Dormitory', 'High'); INSERT INTO Campus_Safety_Incidents VALUES (1034, '2023-01-15 09:30:00', 'Library', 'Moderate'); INSERT INTO Campus_Safety_Incidents VALUES (1025, '2023-07-10 14:45:00', 'Dormitory', 'High'); -------------- insert into Enrolled_in values ( 1002, '601.271', 'A-'); insert into Enrolled_in values ( 1010, '601.271', 'A-'); ----- INSERT INTO Course_Prerequisite VALUES('601.337', '520.345'); INSERT INTO Course_Prerequisite VALUES('601.337', '550.471'); INSERT INTO Course_Prerequisite VALUES('601.465', '550.310'); INSERT INTO Course_Prerequisite VALUES('601.465', '520.213'); INSERT INTO Course_Prerequisite VALUES('601.465', '601.415'); insert into likesArtist values ( 1002, 2, 10); insert into likesArtist values ( 1003, 2, 10); insert into likesArtist values ( 1004, 2, 10); insert into Loves values (1001, 1024); insert into Activity values (797, 'Basketball'); insert into Participates_in values (1001, 797); insert into Participates_in values (1002, 797); insert into Participates_in values (1003, 797); insert into Participates_in values (1004, 797); insert into Favorite_NBA_Team values ( 1003, 'Golden State Warriors' ); insert into Favorite_NBA_Team values ( 1004, 'Golden State Warriors' ); insert into Favorite_NBA_Team values ( 1005, 'Denver Nuggets' ); insert into Favorite_NBA_Team values ( 1006, 'Denver Nuggets' ); insert into Favorite_NBA_Team values ( 1007, 'Denver Nuggets' ); insert into Favorite_NBA_Team values ( 1008, 'Denver Nuggets' ); insert into Favorite_NBA_Team values ( 1013, 'Denver Nuggets' ); insert into likesArtist values ( 1004, 2, 10); insert into likesArtist values ( 1024, 1, 10); insert into likesArtist values ( 1024, 4, 10); insert into Course_CA values (1001, '601.109', 'WTh', '2:00-3:00'); insert into Volunteer_Work VALUES (8, 1008, 'Children’s Hospital', '2023-02-01', '2023-08-31', 'Care Helper', 200); insert into Volunteer_Work VALUES (9, 1008, 'Local Library', '2022-09-01', '2023-01-31', 'Bookshelf Organizer', 150); NSERT INTO Student VALUES (1050, 'Doe', 'John', 21, 'M', 601, 1121, 'LAX'); -- Enroll the student in the courses INSERT INTO Enrolled_in (StuID, CID) VALUES (1050, '550.681'); INSERT INTO Enrolled_in (StuID, CID) VALUES (1050, '601.303'); INSERT INTO Enrolled_in (StuID, CID) VALUES (1050, '601.315'); INSERT INTO Enrolled_in (StuID, CID) VALUES (1050, '601.337'); INSERT INTO Enrolled_in (StuID, CID) VALUES (1050, '601.461'); INSERT INTO Enrolled_in (StuID, CID) VALUES (1050, '601.465'); INSERT INTO Alumni VALUES (11, 'Doe', 'Jane', 2010, 111, 'NYC'); INSERT INTO Alumni VALUES (12, 'Lee', 'Brandon', 2009, 112, 'NYC'); INSERT INTO Alumni VALUES (13, 'Kim', 'Sophia', 2011, 113, 'SFO'); INSERT INTO Alumni VALUES (14, 'Singh', 'Amit', 2012, 114, 'SFO');