set echo on spool K:\lectures\lecture9\insert.log set null NULL --insert data insert into students (studentid, fname, lname, department, year, email, phone) values (100100100, 'Michael','Sable','DUSP',5,'[email protected]','1-617- 234-5678'); insert into students (studentid, fname, lname, department, year, email, phone) values (100100101, 'Christiaan','Adams','TPP',5,'[email protected]','1- 617-234-5432'); insert into students (studentid, fname, lname, department, year, email, phone) values (100100102, 'Julie','Kirschbaum','DUSP',5,'[email protected]','1-617- 234-5238'); insert into students (studentid, fname, lname, department, year, email, phone) values (100100103, 'Jaecheol','kim','DUSP',5,'[email protected]','1-617- 234-5238'); insert into students (studentid, fname, lname, department, year, email, phone) values (100100104, 'Jacky','Smith','DUSP',3,'[email protected]','1-617-234- 5623'); insert into students (studentid, fname, lname, department, year, email, phone) values (100100105, 'Virat','Chatdarong','CIVIL',2,'[email protected]','1- 617-234-5432'); insert into teachers (teacherid, fname, lname, email, phone, office, hours) values (500100101, 'Joe','Ferreira','[email protected]','1-617-434-3438','room 9-552','T2-3;R3-4'); insert into teachers (teacherid, fname, lname, email, phone, office, hours) values (500100102, 'Lorlene','Hoyt','[email protected]','1-617-674- 3754','room 9-554','T1-2;W2-3'); insert into courses (courseid, coursenumber, name, description, www, courselevel, credit) values (100100, '11.521/11.523/11.524','Spatial Database Management and Advanced GIS','http://crl.mit.edu/classes/11.521','This course ...','high',12); insert into courses (courseid, coursenumber, name, description, www, courselevel, credit) values (100101, '11.220','QR','http://crl.mit.edu/classes/11.521','This course ...','graduate',12);insert into tea_cou (teacherid, courseid)values (500100101, 100100); insert into tea_cou (teacherid, courseid)values (500100102, 100100); insert into tea_cou (teacherid, courseid)values (500100101, 100101); insert into stu_cou (studentid, courseid)values (100100100, 100100); insert into stu_cou (studentid, courseid)values (100100101, 100100); insert into stu_cou (studentid, courseid)values (100100102, 100100); insert into stu_cou (studentid, courseid)values (100100102, 100101); insert into stu_cou (studentid, courseid)values (100100103, 100100); insert into stu_cou (studentid, courseid)values (100100104, 100100); insert into stu_cou (studentid, courseid)values (100100105, 100100); commit; spool
View Full Document