--inserts into DEPARTMENT
insert into department values('100','Computer Science');
insert into department values('101','Mathematics');
insert into department values('102','Electrical Eng.');
insert into department values('103','Statistics');
insert into department values('104','Mech. Eng.');

--inserts into STUDENT
insert into student values(5001,'Simpson','Homer','M',45,'100',4);
insert into student values(5011,'Simpson','Marge','F',42,'100',3);
insert into student values(5021,'Simpson','Bart','M',9,'100',1);
insert into student values(5031,'Simpson','Lisa','F',8,'100',1);
insert into student values(5041,'Simpson','Magie','F',2,'100',1);
insert into student values(5101,'Greene','Rachel','F',24,'100',3);
insert into student values(5111,'Geller','Ross','M',25,'101',4);
insert into student values(5201,'Geller','Monica','F',22,'102',3);
insert into student values(5211,'Tribbiani','Joe','M',25,'101',4);
insert into student values(5221,'Buffray','Phoebe','F',22,'103',2);
insert into student values(5301,'Bing','Chandler','M',23,'100',1);
insert into student values(5311,'McCoy','Jack','M',50,'100',5);
insert into student values(5401,'Stabler','Elliot','M',45,'100',5);
insert into student values(5411,'Benson','Olivia','F',40,'100',4);

--inserts into INSTRUCTOR
insert into instructor values(200,'Mylopoulos','John','PhD','100');
insert into instructor values(201,'Clarke','Jim','MSC','100');
insert into instructor values(202,'Cook','Stephen','PhD','101');
insert into instructor values(203,'Corneil','Derek','PhD','101');
insert into instructor values(204,'Craig','Michelle','PhD','102');
insert into instructor values(205,'deLara','Eyal','PhD','102');
insert into instructor values(206,'Dickinson','Sven','PhD','103');
insert into instructor values(207,'Easterbrook','Steve','PhD','103');

--inserts into COURSE
insert into course values(300,'100','Intro. to Databases');
insert into course values(301,'100','Intro. to Algorithm');
insert into course values(302,'100','Intro. to Prog.');
insert into course values(303,'101','Discrete Mathematics');
insert into course values(304,'101','Calculus');
insert into course values(305,'102','Digital Systems');
insert into course values(306,'102','Comp Organization');
insert into course values(307,'103','Probability');
insert into course values(308,'100','Networks');
insert into course values(309,'100','Software Engineering');

--inserts into COURSESECTION
insert into courseSection values(400,300,'100',2006,9,'LEC00',200);
insert into courseSection values(401,300,'100',2005,1,'LEC00',200);
insert into courseSection values(402,300,'100',2005,5,'LEC01',200);
insert into courseSection values(403,300,'100',2005,5,'LEC00',200);
insert into courseSection values(404,301,'100',2005,9,'LEC00',201);
insert into courseSection values(405,301,'100',2005,1,'LEC00',201);
insert into courseSection values(406,302,'100',2005,5,'LEC01',201);
insert into courseSection values(407,302,'100',2005,5,'LEC00',201);
insert into courseSection values(408,302,'100',2005,9,'LEC00',201);
insert into courseSection values(409,303,'101',2005,1,'LEC00',202);
insert into courseSection values(410,304,'101',2005,5,'LEC01',202);
insert into courseSection values(411,304,'101',2006,5,'LEC00',202);
insert into courseSection values(412,304,'101',2006,9,'LEC00',203);
insert into courseSection values(413,304,'101',2006,1,'LEC00',203);
insert into courseSection values(414,305,'102',2006,5,'LEC01',204);
insert into courseSection values(415,305,'102',2006,5,'LEC00',204);
insert into courseSection values(416,306,'102',2006,9,'LEC00',205);
insert into courseSection values(417,306,'102',2006,1,'LEC00',205);
insert into courseSection values(418,306,'102',2006,5,'LEC01',205);
insert into courseSection values(419,306,'102',2005,5,'LEC00',205);
insert into courseSection values(420,307,'103',2006,5,'LEC00',206);
insert into courseSection values(421,308,'100',2006,9,'LEC00',201);
insert into courseSection values(422,308,'100',2006,1,'LEC00',201);
insert into courseSection values(423,308,'100',2006,5,'LEC01',200);
insert into courseSection values(424,309,'100',2005,5,'LEC00',200);

--inserts into STUDENTCOURSE
insert into studentCourse values(5001,400,0);
insert into studentCourse values(5001,401,80);
insert into studentCourse values(5001,402,81);  
insert into studentCourse values(5001,404,78);
insert into studentCourse values(5001,406,82);
insert into studentCourse values(5001,409,95);
insert into studentCourse values(5011,400,0);
insert into studentCourse values(5011,401,92);
insert into studentCourse values(5011,411,69);   
insert into studentCourse values(5011,404,70);
insert into studentCourse values(5011,406,43);
insert into studentCourse values(5011,410,67);
insert into studentCourse values(5021,400,0);
insert into studentCourse values(5021,401,68);
insert into studentCourse values(5021,402,59);
insert into studentCourse values(5021,405,85);
insert into studentCourse values(5021,407,70);
insert into studentCourse values(5031,409,80);
insert into studentCourse values(5031,400,75);
insert into studentCourse values(5031,401,71);  
insert into studentCourse values(5031,410,49);
insert into studentCourse values(5041,409,41);
insert into studentCourse values(5041,410,82);
insert into studentCourse values(5201,420,80);
insert into studentCourse values(5201,410,90);
insert into studentCourse values(5211,420,45);
insert into studentCourse values(5211,410,60);
insert into studentCourse values(5221,420,90);
insert into studentCourse values(5221,410,60);
insert into studentCourse values(5101,414,41);
insert into studentCourse values(5101,416,0);
insert into studentCourse values(5101,418,60);
insert into studentCourse values(5111,414,70);
insert into studentCourse values(5111,417,66);
insert into studentCourse values(5111,418,80);
insert into studentCourse values(5301,400,0);
insert into studentCourse values(5301,404,90);
insert into studentCourse values(5301,406,100);
insert into studentCourse values(5301,409,98);

--inserts into PREREQUISITES
insert into prerequisites values(300,'100',301,'100');
insert into prerequisites values(300,'100',302,'100');
insert into prerequisites values(301,'100',303,'101');
insert into prerequisites values(307,'103',304,'101');
insert into prerequisites values(306,'102',305,'102');
