INSERT INTO ACADEMIC_REC VALUES (1, 1);
INSERT INTO ACADEMIC_REC VALUES (2, 2);
INSERT INTO ACADEMIC_REC VALUES (3, 3);
INSERT INTO ACADEMIC_REC VALUES (4, 4);
INSERT INTO ACADEMIC_REC VALUES (5, 5);
INSERT INTO ACADEMIC_REC VALUES (6, 6);
INSERT INTO ACADEMIC_REC VALUES (7, 7);
INSERT INTO ACADEMIC_REC VALUES (8, 8);


INSERT INTO ASSIGNED_LECTURER VALUES (1, 1);
INSERT INTO ASSIGNED_LECTURER VALUES (2, 2);
INSERT INTO ASSIGNED_LECTURER VALUES (3, 3);
INSERT INTO ASSIGNED_LECTURER VALUES (4, 4);
INSERT INTO ASSIGNED_LECTURER VALUES (5, 5);
INSERT INTO ASSIGNED_LECTURER VALUES (6, 6);
INSERT INTO ASSIGNED_LECTURER VALUES (7, 7);
INSERT INTO ASSIGNED_LECTURER VALUES (8, 8);


INSERT INTO CLASSROOM VALUES ('1A', 50);
INSERT INTO CLASSROOM VALUES ('2B', 50);
INSERT INTO CLASSROOM VALUES ('3C', 25);
INSERT INTO CLASSROOM VALUES ('4D', 40);
INSERT INTO CLASSROOM VALUES ('5E', 30);
INSERT INTO CLASSROOM VALUES ('6F', 20);
INSERT INTO CLASSROOM VALUES ('7G', 50);
INSERT INTO CLASSROOM VALUES ('8h', 40);


INSERT INTO COURSE VALUES ('MATH130', 1, 'Maths', 'LearnMaths', 70, 60, 35);
INSERT INTO COURSE VALUES ('MATH135', 1, 'AdvMaths', 'LearnMathsAgain', 70, 60, 35);
INSERT INTO COURSE VALUES ('ISYS100', 2, 'InfoSys', 'LearnInfoS', 60, 80, 50);
INSERT INTO COURSE VALUES ('ISYS104', 2, 'AdvInfoSys', 'AdvancedInfo', 70, 60, 35);
INSERT INTO COURSE VALUES ('ISYS114', 2, 'SQL', 'EasySQL', 70, 60, 20);
INSERT INTO COURSE VALUES ('ISYS224', 2, 'AdvSQL', 'HardSQL', 50, 80, 10);
INSERT INTO COURSE VALUES ('COMP115', 3, 'BasicComp', 'Processing', 80, 50, 25);
INSERT INTO COURSE VALUES ('COMP225', 3, 'AdvComp', 'C++', 40, 90, 15);


INSERT INTO DEPARTMENT VALUES (1, 98055055, 'Lincon');
INSERT INTO DEPARTMENT VALUES (2, 98123456, 'Albert');
INSERT INTO DEPARTMENT VALUES (3, 97654321, 'Ronald');
INSERT INTO DEPARTMENT VALUES (4, 96267344, 'Murphy');
INSERT INTO DEPARTMENT VALUES (5, 97386356, 'Wally');
INSERT INTO DEPARTMENT VALUES (6, 92475356, 'Xander');
INSERT INTO DEPARTMENT VALUES (7, 98645634, 'Malcom');
INSERT INTO DEPARTMENT VALUES (8, 97765757, 'Ralph');


INSERT INTO PERSON VALUES ('2EA', 'Simon', '2 Kulgoa st Ryde', 98077067, 'simonmorad712@hotmail.com',);
INSERT INTO PERSON VALUES ('3EA', 'Daniel', '4 Hell st Epping', 95555555, 'daniel@hotmail.com',);
INSERT INTO PERSON VALUES ('5BB', 'John', '32 Nowhere st Eastwood', 96666666, 'John@hotmail.com',);
INSERT INTO PERSON VALUES ('4CC', 'Harry', '24 Kulgoa st Ryde', 98045343, 'Harry@hotmail.com',);
INSERT INTO PERSON VALUES ('5CC', 'Luke', '12 Still st Epping', 9877777, 'Luke@hotmail.com',);
INSERT INTO PERSON VALUES ('7AB', 'Lisa', '8 Water st Eastwood', 94444444, 'Lisa@hotmail.com',);
INSERT INTO PERSON VALUES ('99A', 'Tom', '14 Yellow st Meadowbank', 88047047, 'Tom@hotmail.com',);
INSERT INTO PERSON VALUES ('66C', 'Jared', '7 Blue st Ryde', 88235232, 'Jared@hotmail.com',);


INSERT INTO STAFF VALUES (55, 1, 'Bob', 42352323, 'Bob@hotmail.com', 32, 'Lecturer');
INSERT INTO STAFF VALUES (66, 1, 'Mark', 33333333, 'Mark@hotmail.com', 32, 'Lecturer');
INSERT INTO STAFF VALUES (77, 1, 'Henry', 22222222, 'Henry@hotmail.com', 32, 'Tutor');
INSERT INTO STAFF VALUES (7E, 2, 'Levente', 55555555, 'Levente@hotmail.com', 44, 'Tutor');
INSERT INTO STAFF VALUES (3D, 2, 'Shawn', 77777777, 'Shawn@hotmail.com', 44, 'Tutor');
INSERT INTO STAFF VALUES (2D, 2, 'Silvia', 88888888, 'Silvia@hotmail.com', 44, 'Lecturer');
INSERT INTO STAFF VALUES (9T, 3, 'Josh', 55554444, 'Josh@hotmail.com', 55, 'Lecturer');
INSERT INTO STAFF VALUES (9B, 3, 'Harold', 33224466, 'Harold@hotmail.com', 55, 'Tutor');


INSERT INTO STUDENT VALUES ('2EA', 'Science', 'IT');
INSERT INTO STUDENT VALUES ('3EA', 'Arts', 'Health');
INSERT INTO STUDENT VALUES ('5BB', 'Science', 'Accounting');
INSERT INTO STUDENT VALUES ('4CC', 'Accounting', 'Banking');
INSERT INTO STUDENT VALUES ('5CC', 'Engineering', 'Math');
INSERT INTO STUDENT VALUES ('7AB', 'Engineering', 'Computer');
INSERT INTO STUDENT VALUES ('99A', 'Medicine', 'Health');
INSERT INTO STUDENT VALUES ('66C', 'Science', 'IS');


INSERT INTO TEACHING_INFORMATION VALUES ('MATH130', 1, 2012);
INSERT INTO TEACHING_INFORMATION VALUES ('MATH135', 1, 2012);
INSERT INTO TEACHING_INFORMATION VALUES ('ISYS100', 1, 2012);
INSERT INTO TEACHING_INFORMATION VALUES ('ISYS104', 1, 2012);
INSERT INTO TEACHING_INFORMATION VALUES ('ISYS114', 2, 2012);
INSERT INTO TEACHING_INFORMATION VALUES ('ISYS114', 2, 2012);
INSERT INTO TEACHING_INFORMATION VALUES ('COMP115', 2, 2012);
INSERT INTO TEACHING_INFORMATION VALUES ('COMP225', 2, 2012);


INSERT INTO TUTE_PRAC VALUES (33, '2E', 'MATH130', '2EA', 'Tute', 'Monday', '8:00am');
INSERT INTO TUTE_PRAC VALUES (22, '4D', 'MATH135', '3EA', 'Tute', 'Monday', '8:00am');
INSERT INTO TUTE_PRAC VALUES (55, '5C', 'ISYS100', '5BB', 'Prac', 'Monday', '8:00am');
INSERT INTO TUTE_PRAC VALUES (47, '3F', 'ISYS104', '4CC', 'Tute', 'Monday', '8:00am');
INSERT INTO TUTE_PRAC VALUES (52, '6H', 'ISYS114', '5CC', 'Prac', 'Monday', '8:00am');
INSERT INTO TUTE_PRAC VALUES (72, '7J', 'ISYS224', '7AB', 'Prac', 'Monday', '8:00am');
INSERT INTO TUTE_PRAC VALUES (13, '4V', 'COMP115', '99A', 'Prac', 'Monday', '8:00am');
INSERT INTO TUTE_PRAC VALUES (86, '8W', 'COMP125', '66C', 'Prac', 'Monday', '8:00am');