
CONNECT 'university.fdb';

INSERT INTO Departments VALUES ('Applied Mechanics', 'Gothenburg 1');
INSERT INTO Departments VALUES ('Computer Science and Engineering', 'Gothenburg 2');
INSERT INTO Departments VALUES ('Radio and Space Science', 'Gothenburg  3');
INSERT INTO Departments VALUES ('Energy and Environment', 'Gothenburg 4');
INSERT INTO Departments VALUES ('Architecture', 'Gothenburg 5');


INSERT INTO Programs VALUES ('Combustion','CMB');
INSERT INTO Programs VALUES ('Dynamics','DYN');
INSERT INTO Programs VALUES ('Fluid Dynamics','FD');
INSERT INTO Programs VALUES ('Computing Science','CS');
INSERT INTO Programs VALUES ('Computer Engineering','CE');
INSERT INTO Programs VALUES ('Transport theory','TT');
INSERT INTO Programs VALUES ('Nonlinear electrodynamics','NE');
INSERT INTO Programs VALUES ('Optical remote sensing','ORS');
INSERT INTO Programs VALUES ('Heat and Power Technology','HPT');
INSERT INTO Programs VALUES ('Environmental Systems Analysis','ESA');
INSERT INTO Programs VALUES ('Historical Architecture','HA');
INSERT INTO Programs VALUES ('Sustainable Architecture','SA');


INSERT INTO DepartmentsPrograms VALUES ('Applied Mechanics','Combustion');
INSERT INTO DepartmentsPrograms VALUES ('Applied Mechanics','Dynamics');
INSERT INTO DepartmentsPrograms VALUES ('Applied Mechanics','Fluid Dynamics');
INSERT INTO DepartmentsPrograms VALUES ('Computer Science and Engineering','Fluid Dynamics');
INSERT INTO DepartmentsPrograms VALUES ('Computer Science and Engineering','Computing Science');
INSERT INTO DepartmentsPrograms VALUES ('Computer Science and Engineering','Computer Engineering');
INSERT INTO DepartmentsPrograms VALUES ('Computer Science and Engineering','Transport theory');
INSERT INTO DepartmentsPrograms VALUES ('Radio and Space Science','Transport theory');
INSERT INTO DepartmentsPrograms VALUES ('Radio and Space Science','Nonlinear electrodynamics');
INSERT INTO DepartmentsPrograms VALUES ('Radio and Space Science','Optical remote sensing');
INSERT INTO DepartmentsPrograms VALUES ('Energy and Environment','Optical remote sensing');
INSERT INTO DepartmentsPrograms VALUES ('Energy and Environment','Heat and Power Technology');
INSERT INTO DepartmentsPrograms VALUES ('Energy and Environment','Environmental Systems Analysis');
INSERT INTO DepartmentsPrograms VALUES ('Architecture','Environmental Systems Analysis');
INSERT INTO DepartmentsPrograms VALUES ('Architecture','Historical Architecture');
INSERT INTO DepartmentsPrograms VALUES ('Architecture','Sustainable Architecture');


INSERT INTO Branches VALUES (1,'Branch1','Combustion');
INSERT INTO Branches VALUES (2,'Branch2','Combustion');
INSERT INTO Branches VALUES (3,'Branch3','Combustion');
INSERT INTO Branches VALUES (4,'Branch1','Dynamics');
INSERT INTO Branches VALUES (5,'Branch2','Dynamics');
INSERT INTO Branches VALUES (6,'Branch1','Computing Science');
INSERT INTO Branches VALUES (7,'Branch2','Computing Science');
INSERT INTO Branches VALUES (8,'Branch3','Computing Science');
INSERT INTO Branches VALUES (9,'Branch1','Computer Engineering');
INSERT INTO Branches VALUES (10,'Branch2','Computer Engineering');
INSERT INTO Branches VALUES (11,'Branch3','Computer Engineering');
INSERT INTO Branches VALUES (12,'Branch1','Transport theory');
INSERT INTO Branches VALUES (13,'Branch1','Nonlinear electrodynamics');
INSERT INTO Branches VALUES (14,'Branch2','Nonlinear electrodynamics');
INSERT INTO Branches VALUES (15,'Branch1','Optical remote sensing');
INSERT INTO Branches VALUES (16,'Branch2','Optical remote sensing');
INSERT INTO Branches VALUES (17,'Branch1','Environmental Systems Analysis');
INSERT INTO Branches VALUES (18,'Branch1','Historical Architecture');
INSERT INTO Branches VALUES (19,'Branch2','Historical Architecture');
INSERT INTO Branches VALUES (20,'Branch1','Sustainable Architecture');


INSERT INTO Courses VALUES ('AME101','Mechanics of solids and fluids ',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME102','Computations in mechanics',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME103','Rigid body dynamics',5,'Applied Mechanics',7);
INSERT INTO Courses VALUES ('AME104','Material mechanics',5,'Applied Mechanics',5);
INSERT INTO Courses VALUES ('AME105','Fatigue design',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME106','Advanced material mechanics',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME107','Computational nonlinear mechanics',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME108','Mechanics of solids and fluids',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME109','Turbulent flow',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME110','Computational fluid dynamics ',5,'Applied Mechanics',15);
INSERT INTO Courses VALUES ('AME111','Compressible flow',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME112','Turbulence theory',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME113','Heat Transfer',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME114','Turbulence modelling',5,'Applied Mechanics',2);
INSERT INTO Courses VALUES ('AME115','Gas turbine technology',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME116','Multiphase flow',5,'Applied Mechanics',35);
INSERT INTO Courses VALUES ('AME117','Vibration control',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('AME118','Fundamental structural dynamics',5,'Applied Mechanics',12);
INSERT INTO Courses VALUES ('AME119','Mechanics of solids and fluids',5,'Applied Mechanics',NULL);
INSERT INTO Courses VALUES ('CSE201','Agile Software Development Process',5,'Computer Science and Engineering',4);
INSERT INTO Courses VALUES ('CSE202','Programming Paradigms',5,'Computer Science and Engineering',45);
INSERT INTO Courses VALUES ('CSE203','Algorithms',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE204','Software Constraints',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE205','System Development in Teams',5,'Computer Science and Engineering',2);
INSERT INTO Courses VALUES ('CSE207','Software Architecture',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE208','Real-time Systems',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE209','Logic in Computer Science',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE210','Programming Languages',5,'Computer Science and Engineering',20);
INSERT INTO Courses VALUES ('CSE211','Cryptography',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE212','Network Security ',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE213','Computer Architecture ',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('CSE214','Active Safety ',5,'Computer Science and Engineering',30);
INSERT INTO Courses VALUES ('CSE215','Space Techniques ',5,'Computer Science and Engineering',NULL);
INSERT INTO Courses VALUES ('RSS301','Space science and techniques',5,'Radio and Space Science',3);
INSERT INTO Courses VALUES ('RSS302','Radio and microwave engineering',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS303','Astrophysics and Earth science',5,'Radio and Space Science',10);
INSERT INTO Courses VALUES ('RSS304','Electromagnetic waves and spectroscopy',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS305','Interstellar medium and star formation',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS306','Numerical methods in radio and space science',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS307','High energy astrophysics',5,'Radio and Space Science',35);
INSERT INTO Courses VALUES ('RSS308','Radioastron. techniques and interferometry ',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS309','Stellar structure and evolution',5,'Radio and Space Science',4);
INSERT INTO Courses VALUES ('RSS310','Astroparticle physics and cosmology',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS311','Galaxies and observ. cosmology',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS312','Plasma physics with applications',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS313','Image processing',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS314','Astrophysical dynamics',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS315','Atomic and molecular physics ',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS316','Gravitation and cosmology',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS317','Remote sensing',5,'Radio and Space Science',4);
INSERT INTO Courses VALUES ('RSS318','Image analysis',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS319','Satellite positioning',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('RSS320','Foundations for microwave engineering',5,'Radio and Space Science',NULL);
INSERT INTO Courses VALUES ('EAE401','Assessing Sustainability - Assignments',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE402','Science of Environmental Change',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE403','Environmental System Analysis',5,'Energy and Environment',15);
INSERT INTO Courses VALUES ('EAE404','Strategic Environmental Impact Assessment',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE405','Atmospheric Measurements 1',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE406','Geographical Information Systems',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE407','Environmental Risk Assessment in Engineering',5,'Energy and Environment',15);
INSERT INTO Courses VALUES ('EAE408','Atmospheric Measurements 2',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE409','Environmental Impact Assessment',5,'Energy and Environment',25);
INSERT INTO Courses VALUES ('EAE410','Aquatic measurement techniques 1',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE411','Aquatic measurement techniques 2',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE412','Risk Based Remediation',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE413','Remote Sensing',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('EAE414','Environmental Management',5,'Energy and Environment',4);
INSERT INTO Courses VALUES ('EAE415','Life-Cycle Assessment',5,'Energy and Environment',NULL);
INSERT INTO Courses VALUES ('ARC501','Matter, space, structure',5,'Architecture',NULL);
INSERT INTO Courses VALUES ('ARC502','Space for Healthcare, Housing and Work',5,'Architecture',NULL);
INSERT INTO Courses VALUES ('ARC503','Urban design and development',5,'Architecture',NULL);
INSERT INTO Courses VALUES ('ARC504','Sustainable development and the design professions',5,'Architecture',12);
INSERT INTO Courses VALUES ('ARC505','Nordic architecture',5,'Architecture',NULL);
INSERT INTO Courses VALUES ('ARC506','Architectural competitions ',5,'Architecture',NULL);
INSERT INTO Courses VALUES ('ARC507','Reseach by design',5,'Architecture',NULL);
INSERT INTO Courses VALUES ('ARC508','Process in planning and building',5,'Architecture',3);
INSERT INTO Courses VALUES ('ARC509','Architectural conservation and transformation',5,'Architecture',NULL);


INSERT INTO BranchMandatoryCourses VALUES ('AME109',1);
INSERT INTO BranchMandatoryCourses VALUES ('EAE403',1);
INSERT INTO BranchMandatoryCourses VALUES ('EAE407',1);
INSERT INTO BranchMandatoryCourses VALUES ('AME102',4);
INSERT INTO BranchMandatoryCourses VALUES ('AME111',4);
INSERT INTO BranchMandatoryCourses VALUES ('CSE208',5);
INSERT INTO BranchMandatoryCourses VALUES ('CSE208',4);
INSERT INTO BranchMandatoryCourses VALUES ('CSE201',5);
INSERT INTO BranchMandatoryCourses VALUES ('CSE211',10);
INSERT INTO BranchMandatoryCourses VALUES ('CSE210',10);
INSERT INTO BranchMandatoryCourses VALUES ('CSE209',11);
INSERT INTO BranchMandatoryCourses VALUES ('RSS313',11);
INSERT INTO BranchMandatoryCourses VALUES ('AME107',13);
INSERT INTO BranchMandatoryCourses VALUES ('AME114',14);
INSERT INTO BranchMandatoryCourses VALUES ('RSS309',15);
INSERT INTO BranchMandatoryCourses VALUES ('RSS306',17);
INSERT INTO BranchMandatoryCourses VALUES ('EAE401',17);
INSERT INTO BranchMandatoryCourses VALUES ('ARC508',18);
INSERT INTO BranchMandatoryCourses VALUES ('ARC507',19);
INSERT INTO BranchMandatoryCourses VALUES ('ARC506',20);
INSERT INTO BranchMandatoryCourses VALUES ('ARC509',2);


INSERT INTO BranchRecommendedCourses VALUES ('AME102',1);
INSERT INTO BranchRecommendedCourses VALUES ('AME103',1);
INSERT INTO BranchRecommendedCourses VALUES ('EAE405',2);
INSERT INTO BranchRecommendedCourses VALUES ('EAE406',2);
INSERT INTO BranchRecommendedCourses VALUES ('EAE408',3);
INSERT INTO BranchRecommendedCourses VALUES ('EAE409',3);
INSERT INTO BranchRecommendedCourses VALUES ('AME101',4);
INSERT INTO BranchRecommendedCourses VALUES ('AME107',4);
INSERT INTO BranchRecommendedCourses VALUES ('CSE201',5);
INSERT INTO BranchRecommendedCourses VALUES ('CSE205',5);
INSERT INTO BranchRecommendedCourses VALUES ('CSE207',6);
INSERT INTO BranchRecommendedCourses VALUES ('CSE209',7);
INSERT INTO BranchRecommendedCourses VALUES ('CSE210',7);
INSERT INTO BranchRecommendedCourses VALUES ('CSE211',8);
INSERT INTO BranchRecommendedCourses VALUES ('CSE212',9);
INSERT INTO BranchRecommendedCourses VALUES ('CSE214',10);
INSERT INTO BranchRecommendedCourses VALUES ('CSE215',11);
INSERT INTO BranchRecommendedCourses VALUES ('RSS302',12);
INSERT INTO BranchRecommendedCourses VALUES ('RSS303',12);
INSERT INTO BranchRecommendedCourses VALUES ('AME119',13);
INSERT INTO BranchRecommendedCourses VALUES ('AME114',13);
INSERT INTO BranchRecommendedCourses VALUES ('AME113',14);
INSERT INTO BranchRecommendedCourses VALUES ('AME118',14);
INSERT INTO BranchRecommendedCourses VALUES ('RSS304',15);
INSERT INTO BranchRecommendedCourses VALUES ('RSS316',15);
INSERT INTO BranchRecommendedCourses VALUES ('RSS315',16);
INSERT INTO BranchRecommendedCourses VALUES ('EAE402',17);
INSERT INTO BranchRecommendedCourses VALUES ('EAE404',17);
INSERT INTO BranchRecommendedCourses VALUES ('ARC504',18);
INSERT INTO BranchRecommendedCourses VALUES ('ARC507',19);
INSERT INTO BranchRecommendedCourses VALUES ('ARC506',20);


INSERT INTO ProgramMandatoryCourses VALUES ('AME101','Combustion');
INSERT INTO ProgramMandatoryCourses VALUES ('EAE413','Combustion');
INSERT INTO ProgramMandatoryCourses VALUES ('AME109','Dynamics');
INSERT INTO ProgramMandatoryCourses VALUES ('AME112','Fluid Dynamics');
INSERT INTO ProgramMandatoryCourses VALUES ('CSE203','Computing Science');
INSERT INTO ProgramMandatoryCourses VALUES ('CSE202','Computer Engineering');
INSERT INTO ProgramMandatoryCourses VALUES ('RSS317','Transport theory');
INSERT INTO ProgramMandatoryCourses VALUES ('AME104','Nonlinear electrodynamics');
INSERT INTO ProgramMandatoryCourses VALUES ('RSS301','Optical remote sensing');
INSERT INTO ProgramMandatoryCourses VALUES ('EAE414','Heat and Power Technology');
INSERT INTO ProgramMandatoryCourses VALUES ('EAE415','Environmental Systems Analysis');
INSERT INTO ProgramMandatoryCourses VALUES ('ARC505','Historical Architecture');
INSERT INTO ProgramMandatoryCourses VALUES ('ARC509','Sustainable Architecture');


INSERT INTO RequiredCourses VALUES ('AME104','AME106');
INSERT INTO RequiredCourses VALUES ('EAE405','EAE408');
INSERT INTO RequiredCourses VALUES ('EAE410','EAE411');


INSERT INTO ClassifiedCourses VALUES ('AME101','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME102','Research');
INSERT INTO ClassifiedCourses VALUES ('AME103','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME104','Research');
INSERT INTO ClassifiedCourses VALUES ('AME105','Research');
INSERT INTO ClassifiedCourses VALUES ('AME106','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME107','Research');
INSERT INTO ClassifiedCourses VALUES ('AME108','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME109','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('ARC506','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE202','Research');
INSERT INTO ClassifiedCourses VALUES ('CSE208','Research');
INSERT INTO ClassifiedCourses VALUES ('RSS306','Seminar');
INSERT INTO ClassifiedCourses VALUES ('CSE202','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('RSS301','Research');
INSERT INTO ClassifiedCourses VALUES ('EAE415','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE210','Research');
INSERT INTO ClassifiedCourses VALUES ('EAE407','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME101','Research');
INSERT INTO ClassifiedCourses VALUES ('AME102','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME103','Research');
INSERT INTO ClassifiedCourses VALUES ('AME104','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME105','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('AME106','Seminar');
INSERT INTO ClassifiedCourses VALUES ('AME107','Seminar');
INSERT INTO ClassifiedCourses VALUES ('AME108','Research');
INSERT INTO ClassifiedCourses VALUES ('AME109','Seminar');
INSERT INTO ClassifiedCourses VALUES ('ARC506','Research');
INSERT INTO ClassifiedCourses VALUES ('RSS306','Research');
INSERT INTO ClassifiedCourses VALUES ('CSE202','Seminar');
INSERT INTO ClassifiedCourses VALUES ('RSS301','Seminar');
INSERT INTO ClassifiedCourses VALUES ('EAE415','Research');
INSERT INTO ClassifiedCourses VALUES ('CSE210','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('EAE407','Research');
INSERT INTO ClassifiedCourses VALUES ('EAE403','Research');
INSERT INTO ClassifiedCourses VALUES ('EAE405','Research');
INSERT INTO ClassifiedCourses VALUES ('CSE208','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE201','Seminar');
INSERT INTO ClassifiedCourses VALUES ('AME119','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE201','Research');
INSERT INTO ClassifiedCourses VALUES ('CSE207','Research');
INSERT INTO ClassifiedCourses VALUES ('CSE209','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE205','Research');
INSERT INTO ClassifiedCourses VALUES ('RSS307','Seminar');
INSERT INTO ClassifiedCourses VALUES ('RSS309','Research');
INSERT INTO ClassifiedCourses VALUES ('RSS309','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('RSS315','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('RSS316','Research');
INSERT INTO ClassifiedCourses VALUES ('RSS317','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('RSS317','Research');
INSERT INTO ClassifiedCourses VALUES ('AME104','Seminar');
INSERT INTO ClassifiedCourses VALUES ('EAE414','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('ARC508','Research');
INSERT INTO ClassifiedCourses VALUES ('ARC509','Seminar');
INSERT INTO ClassifiedCourses VALUES ('EAE403','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('EAE405','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE201','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE207','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('CSE205','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('RSS307','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('RSS316','Mathematical');
INSERT INTO ClassifiedCourses VALUES ('ARC508','Mathematical');


INSERT INTO Students VALUES (1,'Billy Mack',1);
INSERT INTO Students VALUES (2,'Gregor Fisher',2);
INSERT INTO Students VALUES (3,'Rory MacGregor',2);
INSERT INTO Students VALUES (4,'Colin Firth',3);
INSERT INTO Students VALUES (5,'Sienna Guillory',4);
INSERT INTO Students VALUES (6,'Liam Neeson',5);
INSERT INTO Students VALUES (7,'Emma Thompson',5);
INSERT INTO Students VALUES (8,'Lulu Popplewell',6);
INSERT INTO Students VALUES (9,'Kris Marshall',6);
INSERT INTO Students VALUES (10,'Heike Makatsch',7);
INSERT INTO Students VALUES (11,'Martin Freeman',8);
INSERT INTO Students VALUES (12,'Joanna Page',8);
INSERT INTO Students VALUES (13,'Chiwetel Ejiofor',9);
INSERT INTO Students VALUES (14,'Andrew Lincoln',10);
INSERT INTO Students VALUES (15,'Keira Knightley',17);
INSERT INTO Students VALUES (16,'Hugh Grant',12);
INSERT INTO Students VALUES (17,'Nina Sosanya',12);
INSERT INTO Students VALUES (18,'Frank Moorey',14);
INSERT INTO Students VALUES (19,'Jill Freud',15);
INSERT INTO Students VALUES (20,'Martine McCutcheon',16);
INSERT INTO Students VALUES (21,'Tim Hatwell',16);
INSERT INTO Students VALUES (22,'Laura Linney',11);
INSERT INTO Students VALUES (23,'Lynden David Hall',17);
INSERT INTO Students VALUES (24,'The Big Blue',18);
INSERT INTO Students VALUES (25,'Jont Whittington',19);
INSERT INTO Students VALUES (26,'Dan Fredenburgh',19);
INSERT INTO Students VALUES (27,'Julia Davis',20);
INSERT INTO Students VALUES (28,'Abdul Salis',20);
INSERT INTO Students VALUES (29,'Alan Barnes',10);
INSERT INTO Students VALUES (30,'Shaughan Seymour',14);


-- ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY-MM-DD HH24:MI:SS';

INSERT INTO CoursesStudents VALUES ('RSS316',26,'2008-02-17 11:00:00',1);
INSERT INTO CoursesStudents VALUES ('RSS317',27,'2008-02-17 12:00:00',1);
INSERT INTO CoursesStudents VALUES ('RSS317',7,'2008-02-16 10:20:00',1);
INSERT INTO CoursesStudents VALUES ('RSS317',28,'2008-02-16 20:40:00',1);
INSERT INTO CoursesStudents VALUES ('RSS317',29,'2008-02-16 20:40:00',1);
INSERT INTO CoursesStudents VALUES ('AME104',12,'2008-02-18 12:00:00',1);
INSERT INTO CoursesStudents VALUES ('AME104',22,'2008-02-18 10:30:00',1);
INSERT INTO CoursesStudents VALUES ('AME104',13,'2008-02-17 16:00:00',1);
INSERT INTO CoursesStudents VALUES ('AME104',23,'2008-02-18 10:00:00',1);
INSERT INTO CoursesStudents VALUES ('AME104',24,'2008-02-16 14:10:00',1);
INSERT INTO CoursesStudents VALUES ('EAE414',5,'2008-02-17 15:00:00',1);
INSERT INTO CoursesStudents VALUES ('EAE414',4,'2008-02-18 10:00:00',1);
INSERT INTO CoursesStudents VALUES ('EAE414',15,'2008-02-16 15:00:00',1);
INSERT INTO CoursesStudents VALUES ('EAE414',11,'2008-02-17 10:00:00',1);
INSERT INTO CoursesStudents VALUES ('ARC506',3,'2008-02-18 12:00:00',1);
INSERT INTO CoursesStudents VALUES ('ARC506',2,'2008-02-17 13:10:00',1);
INSERT INTO CoursesStudents VALUES ('ARC506',13,'2008-02-18 11:50:00',1);
INSERT INTO CoursesStudents VALUES ('ARC506',23,'2008-02-16 10:00:00',1);
INSERT INTO CoursesStudents VALUES ('ARC506',18,'2008-02-16 10:20:00',1);
INSERT INTO CoursesStudents VALUES ('ARC506',25,'2008-02-16 12:20:00',1);
INSERT INTO CoursesStudents VALUES ('ARC508',17,'2008-02-17 13:50:00',1);
INSERT INTO CoursesStudents VALUES ('ARC508',7,'2008-02-17 16:40:00',1);
INSERT INTO CoursesStudents VALUES ('ARC508',2,'2008-02-16 17:00:00',1);
INSERT INTO CoursesStudents VALUES ('ARC509',27,'2008-02-16 16:20:00',1);
INSERT INTO CoursesStudents VALUES ('AME103',2,'2008-02-17 18:00:00',1);
INSERT INTO CoursesStudents VALUES ('AME103',12,'2008-02-17 17:20:00',1);
INSERT INTO CoursesStudents VALUES ('AME103',28,'2008-02-18 11:55:00',1);
INSERT INTO CoursesStudents VALUES ('AME103',29,'2008-02-17 19:10:00',1);
INSERT INTO CoursesStudents VALUES ('AME103',30,'2008-02-17 18:40:00',1);
INSERT INTO CoursesStudents VALUES ('AME103',15,'2008-02-16 19:30:00',1);


INSERT INTO CoursesStudents VALUES ('RSS317',30,'2008-02-18 14:00:00',0);
INSERT INTO CoursesStudents VALUES ('RSS317',21,'2008-02-18 16:00:00',0);
INSERT INTO CoursesStudents VALUES ('RSS317',1,'2008-02-18 18:00:00',0);
INSERT INTO CoursesStudents VALUES ('AME104',14,'2008-02-18 15:00:00',0);
INSERT INTO CoursesStudents VALUES ('EAE414',21,'2008-02-18 16:30:00',0);
INSERT INTO CoursesStudents VALUES ('ARC508',27,'2008-02-18 12:30:00',0);
INSERT INTO CoursesStudents VALUES ('ARC508',5,'2008-02-18 17:30:00',0);
INSERT INTO CoursesStudents VALUES ('ARC508',1,'2008-02-18 18:30:00',0);
INSERT INTO CoursesStudents VALUES ('ARC508',21,'2008-02-18 19:00:00',0);


INSERT INTO CoursesStudents VALUES ('AME101',1,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('AME102',1,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('AME101',2,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME104',1,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME105',2,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME106',2,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME107',3,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME108',3,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME109',3,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('ARC501',28,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE202',29,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('CSE201',14,'2008-02-10 10:00:00',2);
INSERT INTO CoursesStudents VALUES ('AME108',5,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('CSE201',6,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('CSE207',7,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('CSE210',14,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('RSS306',15,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('CSE201',22,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('RSS301',19,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('EAE415',23,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('CSE215',29,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME103',1,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('AME109',1,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('EAE407',1,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('EAE403',1,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('EAE405',2,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE208',7,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE202',7,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE205',7,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('AME119',8,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME119',18,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('AME102',5,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME111',5,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('AME109',5,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE208',5,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('EAE401',15,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('EAE415',15,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('CSE211',15,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('CSE202',14,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE202',22,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE209',22,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('RSS313',22,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME113',30,'2008-02-10 10:00:00',3);
INSERT INTO CoursesStudents VALUES ('AME118',30,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('AME114',30,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE211',29,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('CSE210',29,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('CSE214',29,'2008-02-10 10:00:00',4);
INSERT INTO CoursesStudents VALUES ('ARC506',28,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('EAE413',1,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('AME109',7,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('CSE201',7,'2008-02-10 10:00:00',5);
INSERT INTO CoursesStudents VALUES ('ARC509',28,'2008-02-10 10:00:00',4);

COMMIT;
