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,'msable@mit.edu','1-617-234-5678');

insert into students
(studentid, fname, lname, department, year, email, phone)
values (100100101, 'Christiaan','Adams','TPP',5,'adamscs@mit.edu','1-617-234-5432');

insert into students
(studentid, fname, lname, department, year, email, phone)
values (100100102, 'Julie','Kirschbaum','DUSP',5,'jbk@mit.edu','1-617-234-5238');

insert into students
(studentid, fname, lname, department, year, email, phone)
values (100100103, 'Jaecheol','kim','DUSP',5,'jaecheol@mit.edu','1-617-234-5238');

insert into students
(studentid, fname, lname, department, year, email, phone)
values (100100104, 'Jacky','Smith','DUSP',3,'jacks@mit.edu','1-617-234-5623');

insert into students
(studentid, fname, lname, department, year, email, phone)
values (100100105, 'Virat','Chatdarong','CIVIL',2,'virat@mit.edu','1-617-234-5432');

insert into teachers
(teacherid, fname, lname, email, phone, office, hours)
values (500100101, 'Joe','Ferreira','jf@mit.edu','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','lorlene@mit.edu','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 off;